Reading CSV Files
As a data analyst, you most likely will not create DataFrames by yourself - often you will work with some tabular data, most likely stored in the csv format.
To read a csv file, use the pd.read_csv()
function, passing the path to file (web link, or path in file system). When reading, you may set the column that will be used as indexes (index_col
parameter, either column' name, or index).
During this course, we will work with one dataset audi_cars
(source). This dataset contains information of price, transmission, mileage, fuel type, road tax, miles per gallon (mpg), and engine size of used cars. First, let's read this file (from web link).
123456# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') print(df)
Tak for dine kommentarer!
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Spørg mig spørgsmål om dette emne
Opsummér dette kapitel
Vis virkelige eksempler
Awesome!
Completion rate improved to 3.33
Reading CSV Files
Stryg for at vise menuen
As a data analyst, you most likely will not create DataFrames by yourself - often you will work with some tabular data, most likely stored in the csv format.
To read a csv file, use the pd.read_csv()
function, passing the path to file (web link, or path in file system). When reading, you may set the column that will be used as indexes (index_col
parameter, either column' name, or index).
During this course, we will work with one dataset audi_cars
(source). This dataset contains information of price, transmission, mileage, fuel type, road tax, miles per gallon (mpg), and engine size of used cars. First, let's read this file (from web link).
123456# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') print(df)
Tak for dine kommentarer!