Reports-Datasets

Car Price Dataset

Power Query Editor used for data preprocessing

1. Removed null values
2. Removed error values
3. Renamed columns names
4. Separated the date and time column
5. Replaced each value in the state column (e.g., CA -> California, AL -> Alabama) for 34 states
6. Capitalized each word in the columns

   By doing this, we obtain clean data for use.