Cleaning Mixed Data TypesExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] April 8, 2024 in Python tagged clean / pandas / cleaning / Pandas EDA Cleaning by Mike
Data Imputation of AgeExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] March 17, 2024 in Python tagged clean / apply / python / missing / pandas / groupby / function / boxplot / search / seaborn / replace / impute / Pandas EDA Cleaning by Mike
Clean Phone Numbers in PandasDo you have a pandas DataFrame that has a column of phone numbers that need to be cleaned? […] March 5, 2024 in Python tagged clean / numbers / phone / telephone by Mike
Remove Bad Characters in PandasIf you are working with a pandas DataFrame and you need to remove some faulty characters that should […] March 5, 2024 in Python tagged strip / bad / data / clean / characters by Mike
Data Structuring & Cleaning with MikeWhat are the steps to cleaning your data in a data analysis project? This article combines a few […] March 4, 2024 in Data Analytics tagged clean / analysis / EDA / exploratory / cleaning / data / Data Cleaning by Mike
Data Imputation of Negative NumbersExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] October 14, 2023 in Data Analytics tagged data / clean / outliers / impute / imputation / errors / estimate / Pandas EDA Cleaning by Mike
Replace Values in PandasAre you working with a DataFrame in pandas? Do you need to change some values in one of […] October 12, 2023 in Python tagged replace / clean / where / set / update / condition by Mike
Cleaning Categories in pandasYou have a dataset in pandas represented as a DataFrame. One of the columns has categories in it. […] July 26, 2023 in Python tagged cleaning / spelling / typo / category / replacement / replace / clean / set / dictionary / pandas / dataframe by Mike
Loop Through pandas DataFrameHow would we iterate (loop) through the rows of a pandas DataFrame? What’s the context? Why would we […] July 23, 2023 in Python tagged dataframe / clean / loc / drop / iterate / structure / apply / for / loop / rows / dataset / Data Cleaning by Mike
Cleaning Data with Strip in pandasIf we have a DataFrame that has a column of data the looks messy, strip() might work for […] July 23, 2023 in Python tagged strip / test / clean / trim by Mike
EDA Cleaning with PandasExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] July 10, 2023 in Python tagged clean / EDA / cleaning / Pandas EDA Cleaning by Mike
Exploring Data Types in pandasExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] June 17, 2023 in Python tagged data / lambda / clean / types / pandas / EDA / structuring / dirty / cleaning / Pandas Data Types by Mike