Python Automation#1: 🧽Data Cleaning w/janitor, pandas-profiling, dataprep, pandas
1. Clean Messy Column Names (janitor.clean_names)
import pandas as pd
import janitor
# Sample DataFrame
df = pd.DataFrame({"Col 1 ": [1, 2], "COL@2": [3, 4]})
# Clean column names
df = janitor.clean_names(df)
print(df)
Output:
col_1 col_2
0 ...
anixblog.hashnode.dev3 min read