Eliminate Clutter in VisualizationsIt is advised to eliminate any clutter in your data visualizations. This makes sense. Clutter distracts from the […] May 25, 2024 in Data Visualization tagged chart / graph / tidy / clutter / distraction / neat / remove / clean / Storytelling with Data by Mike
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 excel / clean / read / 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 seaborn / replace / impute / clean / apply / python / missing / pandas / groupby / function / boxplot / search / 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 characters / strip / bad / data / clean 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 data / clean / analysis / EDA / exploratory / cleaning / 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 estimate / data / clean / outliers / impute / imputation / errors / 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 condition / replace / clean / where / set / update 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 pandas / dataframe / cleaning / spelling / typo / category / replacement / replace / clean / set / dictionary 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 clean / dataframe / drop / loc / structure / iterate / apply / telephone / for / loop / phone / 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 test / clean / trim / strip 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