Finally, copy the Path as shown below: path = “copy_path_here” df_bonus = pd.

Right click on the file and select Copy Path.Ħ. Locate the folder you created previously and locate your csv file. Then click on the > icon at the top left of the Colab Notebook and then click on Files. After accepting the conditions, copy the verification code and paste it in the area indicated in your Notebook Colab.ĥ. You should see a screen with Google Drive File Stream wishing to access your Google account. This command will take you to a Google authentication step. In your Notebook Colab, write the following code:įrom lab import drive drive.mount(‘/content/drive’)Ĥ.Upload your csv file to your Google Drive in the folder you just created.In my opinion, this method is the simpler of the two.

import io df = pd.read_csv(io.BytesIO(data_to_load)) B. Go to My Computer (This PC in Windows 10) and You should see your windows hard drive Partition Available and ready to use. Format Partition - Finally, Select the Format Type to create a new Windows 10 Partition. Finally, write the following code to import your file into a Pandas DataFrame (make sure the file name matches the name of the downloaded file). Assign Drive Letter - Next, Select a Drive Letter for the new Windows 10 Partition. If the Add to My Drive button is grayed out, it means you have already moved this document/folder to your drive. You should see the name of the file displayed after Colab downloads it.ģ. The Add to My Drive button appears in the top right corner in docs that have been shared with you, and is also one of the choices that appear when you check the box next to something in the Shared With Me section of your drive. Click on “Choose files” then select and download the csv file of your choice.

Start by writing the following and run the code cell :įrom lab import files data_to_load = files.upload()Ģ.

From there add a code cell and import Pandas as shown below:.

Then go to and click on New Python 3 Notebook.

To get started, sign in to your Google Account.I’m going to show you two ways to load a csv file into Colab as a Pandas DataFrame. However, loading a csv file requires writing code. Some of the advantages of Google Colab include easy installation and sharing of Notebooks between users in real time (like other documents in the G-cloud suite). This platform allows you to train Machine Learning models directly in the cloud and all for free. Google Colab is a cloud service, offered by Google (free), based on Jupyter Notebook.

Add to my drive