[FIXED] How to open a file with ".$$1" format

Issue

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

Answered By - Devyl