Working with CSV on COLAB

UpdatedDecember 8, 2022

•1 min read

Mohamad's interest is in Programming (Mobile, Web, Database and Machine Learning). He is studying at the Center For Artificial Intelligence Technology (CAIT), Universiti Kebangsaan Malaysia (UKM).

Part of seriescolab

Load remote CSV data into a Pandas DataFrame

# load the remote data into a Pandas DataFrame
import pandas as pd
df = pd.read_csv('https://archive.org/download/crowdflower/text_emotion.csv', on_bad_lines='skip', encoding='latin-1')
df

colab example

Upload CSV file via upload object to be read by Pandas DataFrame

# using upload object to upload csv
from google.colab import files
import pandas as pd

uploaded = files.upload()
# assume that the user uploaded only one file
# and the file is a csv format
df = pd.read_csv(io.BytesIO(uploaded[list(uploaded.keys())[0]]))
df

colab example

#google-colab #colab #csv-files

35 views

Comments

Join the discussion

No comments yet. Be the first to comment.

colab

Part 2 of 6

Google Colaboratory (Colab)

Up next

Get JSON from remote link and load into pandas data frame # load the remote data into a Pandas DataFrame import pandas as pd df = pd.read_json('https://archive.org/download/crowdflower/text_emotion.json', encoding='latin-1') df see colab example Get ...

More from this blog

Power BI Data Transformation Quiz

QUESTION 1 Which of these operations adds rows to an existing table? Ⓐ Group By. Ⓑ Pivoting. Ⓒ Merging queries. Ⓓ Appending queries. . QUESTION 2 When would you use a tool from the Transform tab over the Add Column tab? Ⓐ When you want to overwrite...

Sep 14, 20244 min read59

RunCode Online Coding Platform

Write and run code on a free online platform [1] Register for an account Register at https://runcode.io/auth/login/ Click Connect with Google. Create a new workspace.

Sep 19, 20231 min read7

Install Power BI Using MS Store

Run MS Store application and search for Power BI Desktop. . Click the Install button. . . Click Open. . .

Sep 19, 20231 min read2

Ubuntu - Install PHP and Composer

[1] Update Ubuntu sudo apt update [2] Install PHP CLI sudo apt install php-cli unzip [3] Install Composer Change directory to home. Install Composer cd ~ curl -sS https://getcomposer.org/installer -o /tmp/composer-setup.php Using curl, fetch the l...

Sep 19, 20231 min read9

Laravel 10 With Laravel/UI BootStrap 5 Auth

[1] Create a Laravel Project e.g. Laravel v.10.23.0 PHP v.8.2 [2] Add Package Add Laravel UI package composer require laravel/ui --dev [3] Install Bootstrap Styling Add Bootstrap Styling for the Laravel UI Auth php artisan ui bootstrap --auth Add b...

Sep 19, 20231 min read227

Mohamad Mahmood

49 posts