/hha-data-cleanup

HHA 507 // Assignment #2

Primary LanguagePython

hha-data-cleanup

507 assignment 2

A csv file was loaded into the python file

Using '.shape' and 'list()', able to see the number of rows and columns and then have the column names listed out

Now needed to clean up the column names by removing white space and replacing spaces in names with underscores

Ran '.dtypes' to see types of data in each column and changed the 'Week' column from object to the integer of Day of the Week

Removed duplicate rows of data

got a count of missing values in each row

Based on the 'Learning Modality' column, created a new column that gives back the True or False of if the learning was 'In Person' or not

Saved the new data file in a clean csv file