<h2 id="heading-load-remote-csv-data-into-a-pandas-dataframe">Load remote CSV data into a Pandas DataFrame</h2>
<pre><code># 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
</code></pre><a target="_blank" href="https://colab.research.google.com/drive/10o9z4Dtbn4S4kXZoqAgiRr_4xJE-u0yo#scrollTo=SLq460CWNCyi">colab example</a>
<h2 id="heading-upload-csv-file-via-upload-object-to-be-read-by-pandas-dataframe">Upload CSV file via upload object to be read by Pandas DataFrame</h2>
<pre><code># 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
</code></pre><a target="_blank" href="https://colab.research.google.com/drive/10o9z4Dtbn4S4kXZoqAgiRr_4xJE-u0yo#scrollTo=cabyNmRZNeyN">colab example</a>

## 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](https://colab.research.google.com/drive/10o9z4Dtbn4S4kXZoqAgiRr_4xJE-u0yo#scrollTo=SLq460CWNCyi)

## 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](https://colab.research.google.com/drive/10o9z4Dtbn4S4kXZoqAgiRr_4xJE-u0yo#scrollTo=cabyNmRZNeyN)

Mohamad Mahmood

Mohamad Mahmood

Working with CSV on COLAB

Table of contents

Load remote CSV data into a Pandas DataFrame

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