Import or Upload Local File to Google Colab

How to read CSV file in Google Colab

Google Colab is a powerful tool that allows you to run Python code in the cloud. This can be useful for a variety of tasks, including data analysis and machine learning. One of the lesser known features of Google Colab is that you can also import or upload files stored on your local drive. In this article, we will show you how to read a file from your local drive in Google Colab using a quick code sample.

There are a few reasons why you as a data scientist might need to learn how to read files from your local drive in Google Colab.

  • One reason is that you may not have access to the data you need in the cloud. For example, if you are working on a project that requires data that is not stored in the cloud, you can access it on your local drive.
  • Another reason is that using files from your local drive can be faster than using files from the cloud.
  • Finally, using files from your local drive can be easy to customize and manage.

Executing the code below will prompt to select a file from the local drive and upload.

import pandas as pd
import io
from google.colab import files
uploaded = files.upload()

Once done with the above, all you need to do is execute the following code. The “FileName.csv” should be the name of the file that you uploaded.

df = pd.read_csv(io.BytesIO(uploaded['FileName.csv']))

In order to test if the file is loaded appropriately, execute the following command:

df.head()

If you have any questions about how to use Google Colab or need help getting started, don’t hesitate to reach out. We’re here to help!

Ajitesh Kumar
Follow me
Latest posts by Ajitesh Kumar (see all)

Ajitesh Kumar

I have been recently working in the area of Data analytics including Data Science and Machine Learning / Deep Learning. I am also passionate about different technologies including programming languages such as Java/JEE, Javascript, Python, R, Julia, etc, and technologies such as Blockchain, mobile computing, cloud-native technologies, application security, cloud computing platforms, big data, etc. For latest updates and blogs, follow us on Twitter. I would love to connect with you on Linkedin. Check out my latest book titled as First Principles Thinking: Building winning products using first principles thinking
Posted in AI, Data Science, Machine Learning, Python. Tagged with , , .

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.