CSV to DataFrame (2)


Tue Nov 23 2021 12:46:33 GMT+0000 (UTC)

Saved by @Sourabh ##dictionary ##pandas #defining_data_frame #csv #dataframe

# Import pandas as pd
import pandas as pd

# Fix import by including index_col
cars = pd.read_csv('cars.csv', index_col = 0)

# Print out cars

Your read_csv() call to import the CSV data didn't generate an error, but the output is not entirely what we wanted. The row labels were imported as another column without a name. Remember index_col, an argument of read_csv(), that you can use to specify which column in the CSV file should be used as a row label? Well, that's exactly what you need here! Python code that solves the previous exercise is already included; can you make the appropriate changes to fix the data import?