Read box files in python

Follow

New post

ishan42d

• March 27, 2020 15:22

I want to read a set of excel files directly from BOX to my jupyter notebook where I can work with them every-time these files are updated within BOX. I have tried much of the documents available but no luck.

My company has an enterprise version of box and the url looks like abc.ent.box.com

I want to read this url > go to a folder location and read the file from there or directly read the file from the file id.

 

I do have a developers account with client id, client secret and development token available but I am not sure how to use this information while connecting with box. 

 

The basic question, to read box files directly into python

1

• 

  Nayak

  • March 29, 2020 22:49

  Hi , I stongly recommend you to use the Box Python SDK and authenticate (either via JWT approach or 3 legged Oauth2) and get the access token & client connection setup. Post this you can call the List Folder Items & download required files. Hope this helps

  -1

  Comment actions Permalink
• 

  George Avetisyan

  • January 15, 2021 04:31

  Hey, Nayak. I did try everything you just mentioned above, pandas is not able to read excel files. In fact its not reading any files. When I do pd.read_excel () in the parameter I tried to pass content, link to the file, file id, everything. Its not working. Please let me know what is the problem

  0

  Comment actions Permalink
• 

  Guy Huinen

  • February 16, 2021 11:59

   

  from io import StringIO
  import pandas as pd

  file_content = client.file(file_id).content()

  s=str(file_content,'utf-8')

  data = StringIO(s)

  df=pd.read_csv(data)

  0

  Comment actions Permalink
• 

  Shobin Joyakin

  • October 27, 2023 15:45

  Hi George.. Did you find a way to read Excel file in Box using python script? The solution Guy Huinen shared works only with CSV files.

  0

  Comment actions Permalink

Please sign in to leave a comment.