Skip to content
import json
import pandas as pd
from sqlalchemy import create_engine
engine = create_engine('sqlite://', echo = False)

df = pd.concat([pd.read_json('StreamingHistory0.json'), pd.read_json('StreamingHistory1.json'),pd.read_json('StreamingHistory2.json'),pd.read_json('StreamingHistory3.json')])

df['minPlayed'] = df['msPlayed']/60000

df_by_track_name = df['trackName'].value_counts(sort=True)
df_total_min_per_track = df.groupby('trackName')['minPlayed'].sum()

print(df_by_track_name.head(10))