Forum Discussion

ramlalr's avatar
ramlalr
New Member
2 years ago
Solved

Issue while extracting files from a zip file placed in files section of lakehouse

I have placed a zip file in a RAW subfolder under files folder in lakehouse, when I try to unzip using zipfile package getting  "FileNotFoundError: [Errno 2] No such file or directory: '/RAW/data_Q2_2017.zip'"

 

Code Used:

import zipfile
with zipfile.ZipFile("/RAW/data_Q2_2017.zip", 'r') as zip_ref:
    zip_ref.extractall()
data engineering
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi ramlalr 

     

    Thanks for using Microsoft Fabric Community.

    The error message you are seeing, “FileNotFoundError: [Errno 2] No such file or directory: ‘/RAW/data_Q2_2017.zip’”, typically means that Python cannot find the file you’re trying to unzip. In your case, you are trying to unzip the file located at “/RAW/data_Q2_2017.zip”. This path is an absolute path, which means Python is looking for the file starting from the root directory (“/”). If your file is located in a subdirectory of your current working directory, you should use a relative path instead of an absolute path. A relative path starts from your current working directory, not from the root directory.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Thank you.

3 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi ramlalr 

     

    Thanks for using Microsoft Fabric Community.

    The error message you are seeing, “FileNotFoundError: [Errno 2] No such file or directory: ‘/RAW/data_Q2_2017.zip’”, typically means that Python cannot find the file you’re trying to unzip. In your case, you are trying to unzip the file located at “/RAW/data_Q2_2017.zip”. This path is an absolute path, which means Python is looking for the file starting from the root directory (“/”). If your file is located in a subdirectory of your current working directory, you should use a relative path instead of an absolute path. A relative path starts from your current working directory, not from the root directory.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Thank you.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi ramlalr 

       

      Glad that your query got resolved.
      Please continue using Fabric Community for further queries.

       

      Thank you.