text_html_output_1.png
import pandas as pd

hits = pd.read_csv('../input/hits.csv')
musics = pd.read_csv('../input/music_data.csv')
genre = pd.read_csv('../input/genre.csv')
state = pd.read_csv('../input/state.csv')

hits.columns

musics.columns

genre.columns

state.columns

df = hits.merge(genre, on='genre_id').merge(state, on='state_id').merge(musics, on='music_id')

df.columns

df.query('user_id==878')