import pandas as pd
import bamboolib as bam
df = pd.read_csv("business_employment_data.csv")
# Step: Drop columns
df = df.drop(columns=['Series_title_4', 'Series_title_5'])
# Step: Sort column(s) Period ascending (A-Z)
df = df.sort_values(by=['Period'], ascending=[True])
# Step: Change data type of UNITS to Boolean
df['ValueOrNumber'] = df['UNITS'].astype(bool)
# Step: Drop columns
df = df.drop(columns=['ValueOrNumber'])
# Step: OneHotEncode column(s) UNITS
df = pd.get_dummies(df, columns=['UNITS'], drop_first=False, dummy_na=False)
df
import plotly.express as px
fig = px.histogram(df, x='Period', y='Group')
fig