downloading CSV file in python using pandas

Question

I am trying to download a csv file to python. For some reason I can not do it. I suppose I need to add an additional argument to read_csv?

import pandas as pd

url = "https://raw.githubusercontent.com/UofGAnalyticsData/"\
          "DPIP/main/assesment_datasets/assessment3/starwars.csv"

df = pd.read_csv(url)

It creates a dataframe and assigns it to a variable named df. You can see a sample of the contents of this dataframe with print(df.head()) — inspectorG4dget
– inspectorG4dget, Commented Nov 18, 2022 at 15:46

Salman Ahmad · Accepted Answer · 2022-11-19 06:36:19Z

1

The code you attempt is downloading the content from the url and pasting it in the data frame named 'df'. You need to save the output csv by using the following line. You will find the output file in the same directory where the python script is saved.

import pandas as pd

url = "https://raw.githubusercontent.com/UofGAnalyticsData/"\
          "DPIP/main/assesment_datasets/assessment3/starwars.csv"

df = pd.read_csv(url)
df.to_csv('output.csv')

answered Nov 19, 2022 at 6:36

Salman Ahmad

216 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

downloading CSV file in python using pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related