Feedback on External Data notebook

[afeld]

These are suggested edits rather than a feature, but I had to pick an issue template.

Is your feature request related to a problem? Please describe.
I teach Python and pandas in Colab. My students don't necessarily have coding experience, so I need to explain how they can upload and load data. I'd like to point to the External data: Local Files, Drive, Sheets, and Cloud Storage notebook, but it's somewhat incomplete, in my opinion.

Describe the solution you'd like
I suggest adding the following:

• Uploading from the Files tab
• How to load uploaded data from pandas
  • Linking to the IO tools page in pandas
• For mounting Drive locally, mentioning Copy path
• For InteractiveSheet, explaining how to use url to load an existing spreadsheet, as shown in the demo video

Describe alternatives you've considered
Creating my own explanation, which I have.

Additional context
I also happen to be a pandas maintainer.

---

Thanks!

[Shubham-Jain52]

hi can you please assign this to me.
if possible add the hacktober fest label to it as well.

[afeld]

Non-maintainer here: I don't see the notebook in GitHub so someone from Google would need to finalize the edits, but you could make a copy with the suggested edits for them to pull from if you like.

[spencersgoogle]

@afeld we have the notebook, this is great feedback and we will update. Can you share a bit more about what you mean with this point?
"For mounting Drive locally, mentioning Copy path"

Internal tracking bug:
b/454696665

[afeld]

Oh, sure: My introductory class moves fast and we kinda breeze over file paths, so they wouldn't necessarily understand what this cell is implying:

with open('/content/drive/My Drive/foo.txt', 'w') as f:
  f.write('Hello Google Drive!')

For the "Mounting Google Drive locally" (existing) and uploading from the Files tab (proposed) sections, it would be helpful to include something like:

Once the file shows up under the Files tab, you can get the path by:

1. Navigating to the file
2. Clicking the three dots to the right
3. Clicking "Copy path"

This can then be used with open(), pd.read_csv(), etc.

Does that help?

[afeld]

I don't see the notebook in GitHub

Opened #5674.