Cleaning US Census Data Project - Solution Code

moeabdelkader · December 29, 2020, 11:01pm

Hello everyone!

Below is my solution for the US Census Data cleaning project. Feedback is appreciated!

MoeAbdelKader/DataScienceCareerTrack---Codecademy/blob/main/DataCleaning/us_census.py

#solution code for Codecademy "Clean US Census Data" challenge.

import pandas as pd
import numpy as np
import matplotlib.pyplot as pyplot
import codecademylib3_seaborn
import glob

#Use glob to grab multiple CSV files
temp_df = glob.glob("states*.csv")
temp_list = []

#Append the CSV files into a temporary list
for myfile in temp_df:
  data = pd.read_csv(myfile)
  temp_list.append(data)

#Concatenate the files within the list to create a dataframe with the needed data.
us_census = pd.concat(temp_list)

This file has been truncated. show original

Topic		Replies	Views
Data Cleaning Pandas Project Feedback: US Census Projects	3	539	August 31, 2020
US Census Cleaning Completed Projects	0	862	March 30, 2020
Solution: Cleaning US Census Data (Project) Projects	19	6023	September 18, 2021
Cleaning US Census Data feedback Projects	2	1089	November 17, 2022
Data Cleaning with Pandas - [Cleaning US Census Data] Computer Science	3	2655	October 17, 2022

Cleaning US Census Data Project - Solution Code

Related topics