Load a CSV File With Python and Pandas

import pandas as pd

# Read the CSV file
car_sales_data = pd.read_csv("Car Sales.csv")

# Show the first 5 rows
car_sales_data.head(5)

from os.path import expanduser as ospath

user_home_directory = ospath("~")

# Make sure to use "/" slashes and not "\" slashes
# There actually needs to be folders named "Path" and "To" and "CSV" and "File"
# in your home directory (the "~" means "home directory") for this cell to work
csv_file_path = user_home_directory + "/Path/To/CSV/File/Car Sales.csv"

other_path_car_sales_data = pd.read_csv(csv_file_path)

# Show the first 5 rows
other_path_car_sales_data.head(5)

# Note the URL Encoding with "%20" for spaces
url_to_csv_file = "https://github.com/andrewcbancroft/datadaylife-blog/raw/master/datasets/Car%20Sales.csv"

# Read the CSV file
url_car_sales_data = pd.read_csv(url_to_csv_file)

# Show the first 5 rows
url_car_sales_data.head(5)