Load a CSV File With Python and Pandas

1import pandas as pd

1# Read the CSV file
2car_sales_data = pd.read_csv("Car Sales.csv")
3
4# Show the first 5 rows
5car_sales_data.head(5)

1from os.path import expanduser as ospath
2
3user_home_directory = ospath("~")

1# Make sure to use "/" slashes and not "\" slashes
2# There actually needs to be folders named "Path" and "To" and "CSV" and "File"
3# in your home directory (the "~" means "home directory") for this cell to work
4csv_file_path = user_home_directory + "/Path/To/CSV/File/Car Sales.csv"
5
6other_path_car_sales_data = pd.read_csv(csv_file_path)
7
8# Show the first 5 rows
9other_path_car_sales_data.head(5)

1# Note the URL Encoding with "%20" for spaces
2url_to_csv_file = "/datasets/Car%20Sales.csv"
3
4# Read the CSV file
5url_car_sales_data = pd.read_csv(url_to_csv_file)
6
7# Show the first 5 rows
8url_car_sales_data.head(5)