I have ordered a data from an organization. They provided me with a huge file with .$$1
extension.
I just what to know what is this file and how can I open it with R or python?
I first tried to open this file with notepad , but it was not a text file.
7-zip shows that it contains worksheets with a json
in it, but it failed to extract it.
Notepad sliced output of the first line:
PK .vëT.¶ç#¢I]ªx xl/worksheets/sheet1.xml
CodePudding user response:
If it starts with b'PK'
, try unzip the file
import zipfile
with zipfile.ZipFile(file, "r", compression=zipfile.ZIP_DEFLATED) as zfile:
zfile.extractall()
or open it with excel