You can set a column as index using the function .set_index()
in Pandas.
import pandas as pd
car_data = {'Unique_Number': ['12', '89','63','43','85','11','44','33'],
'Brand': ['Tesla', 'Tesla','Tesla','Ford','Ford','Ford','Toyota','Toyota'],
'Location': ['CA', 'CA','NY','MA','CA','WA','CA','TX'],
'Year':['2019','2018','2020','2019','2016','2010','2018','2021']}
car_data=pd.DataFrame(data=car_data)
print(car_data)
Unique_Number Brand Location Year 0 12 Tesla CA 2019 1 89 Tesla CA 2018 2 63 Tesla NY 2020 3 43 Ford MA 2019 4 85 Ford CA 2016 5 11 Ford WA 2010 6 44 Toyota CA 2018 7 33 Toyota TX 2021
#set unique_number as the index
car_data=car_data.set_index('Unique_Number')
print(car_data)
Brand Location Year Unique_Number 12 Tesla CA 2019 89 Tesla CA 2018 63 Tesla NY 2020 43 Ford MA 2019 85 Ford CA 2016 11 Ford WA 2010 44 Toyota CA 2018 33 Toyota TX 2021