Use file.content() or file.download_to() -> to data frame

Follow

New post

mcha54

• January 23, 2020 18:09

Using Python SDK in a Juypter Notebook

Say I have an Excel or CSV on Box. I need the contents of the file and put it into a pandas data frame for further processing.

Is it better to use file.content() or temporarily download the file to a local network drive?

 

 

0

• 

  jcleblanc

  • February 05, 2020 18:32

  Hi ,

   

  file.content() will download the file content into a local variable. If you can inject the file content directly into the data frame that way then it'll be the easiest method. If the frame needs to reference a local file in the file system then save the content to a local file.

   

  - Jon

  0

  Comment actions Permalink
• 

  mcha54

  • February 06, 2020 09:46

   Thank you! Do you know if content() will retry if there's a connection issue during the process? Some of the CSV/Excel files we'd like to read are large files, a bit worried about lost bytes if we use content(). Or will it just fail and return an error code?

  0

  Comment actions Permalink

Please sign in to leave a comment.