Working with files
Connecting to data sources
Coding and analysis tools
Security and privacy
Deepnote for education
Deepnote can fetch files from OneDrive, for example, Excel files that you collaborate on with your team. Follow these docs to create your own notebook to pull files from OneDrive, query data, and visualize it.
1. Duplicate the OneDrive template
Open the template by following this link ->
Click the "duplicate" button on the top right corner to do this. Once you've got the template in your Deepnote workspace, you can download files from OneDrive.
2. Share files with Deepnote from OneDrive
You need to create a public sharing link so Deepnote can download the file. Follow these instructions from Microsoft making sure that anyone with the link can at least view the file.
Change the variable
ONEDRIVE_SHARE_LINK in the notebook to link to the file you just made.
3. Fetch OneDrive files from Deepnote
The template notebook has a function called
get_onedrive_download, which takes a share link and creates a URL that will download that file directly. You can use a library like
requests to fetch the file or pass it to
pandas to read a CSV or Excel file directly. In the below example, the shared file is an Excel file.
ONEDRIVE_SHARE_LINK = "https://1drv.ms/x/s!AjP7y6eiYDDSafV7BusEaDHrI0o?e=cL0Fqi" df = pd.read_excel(get_onedrive_download(ONEDRIVE_SHARE_LINK)) df
When executing the code above, Deepnote will visualize the output dataframe, as we see in the example below.
Now that you're querying data, you can share it with your team. You can even turn your charts into a shareable dashboard.
Still need help? Deepnote's community of over 5,000 data enthusiasts and professionals is always there for you. Post any questions into the Q&A channel here.