Unable to unpack or read rar file

TechExplorer
New Contributor II

Hi everyone,

I'm encountering an issue with the following code when trying to unpack or read a RAR file in Databricks: 

with rarfile.RarFile(s3_path) as rf:
    for file_info in rf.infolist():
        with rf.open(file_info) as file:
            file_content = io.BytesIO(file.read())
            df = pd.read_csv(file_content, nrows=10)
            display(df)

The error message I receive is: "cannot find working tool".

Has anyone successfully managed to unpack or read a RAR file using rarfile.RarFile in Databricks? Any insights or alternative approaches would be greatly appreciated!

Thanks in advance!