Pandas example using `explode()`

README.md

Created using the following ChatGPT conversation: https://chat.openai.com/share/9cac1fad-851d-4f43-87da-17d64b3f4e02

log.csv

main.py

import pandas as pd

df = pd.read_csv('log.csv')
df['Date'] = pd.to_datetime(df['Date'], format='%m/%d/%Y')
df['Owners'] = df['Owners'].str.split(';')
df = df.explode('Owners')
df['Month'] = df['Date'].dt.month
print(df)

avg_time_spent = df.groupby(['Month', 'Owners'])['Spent'].mean().reset_index()
print(avg_time_spent)


import seaborn as sns
import matplotlib.pyplot as plt

sns.set_style('whitegrid')
plt.figure(figsize=(10, 6))
sns.lineplot(data=avg_time_spent, x='Month', y='Spent', hue='Owners', style='Owners', marker='o')
plt.title('Average Time Spent per Month')
plt.xlabel('Month')
plt.ylabel('Average Time Spent')
plt.legend(title='Owners')
plt.show()