text_plain_output_1.png
import pandas as pd

file_path = '../input/car-price-prediction/CarPrice_Assignment.csv'
cars = pd.read_csv(file_path, index_col='car_ID')

cars.shape

cars.columns

cars.isnull().sum()

CompanyName = cars['CarName'].apply(lambda x: x.split(' ')[0])
cars.insert(2, 'CompanyName', CompanyName)
cars.drop(['CarName'], axis=1, inplace=True)
cars.head()