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
>Solution :
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