Plotting a Line Plot in Pandas on a double-indexed dataframe

Asked Mar 21 '19 at 09:03

Active Mar 21 '19 at 09:03

Viewed 69 times

I have a dataframe as shown below with double index 'month' and 'day'

    query_sorted_gross = '''
    SELECT days.Gross, days.month, days.day
    FROM days, horror_movies
    WHERE horror_movies."Movie ID" = days."Movie ID"

'''
df_q1 = pd.read_sql_query(query_sorted_gross, conn)
df_q1_grouped = df_q1.groupby(['month', 'day']).mean()

I want to create a line plot that shows date on the X-axis and Gross on the Y-axis. How do I plot a double-indexed dataframe with a line plot.

asked Mar 21 '19 at 09:03

Amit Gelbhart

check this post https://stackoverflow.com/questions/49834883/scatter-plot-form-dataframe-with-index-on-x-axis – Julia Mar 21 '19 at 09:10
@Julia that did not work for my case, thanks for the link however. – Amit Gelbhart Mar 21 '19 at 09:20

Plotting a Line Plot in Pandas on a double-indexed dataframe

0 Answers0