Hey there I'm pretty new to using matplotlib and am trying to plot multiple datasets on the same figure, like so:
graph_df_pivot = df1.pivot_table(index='source_dt', values='num_rws', fill_value=0)
graph_df_pivot2 = df2.pivot_table(index='source_dt', values='num_rws', fill_value=0)
ax = graph_df_pivot.plot(kind='line', figsize=(20, 5), grid=True, title='') # , use_index=True)
ax.set_xticks(range(0, len(graph_df_pivot.index.tolist())))
ax.set_xticklabels([str(i) for i in graph_df_pivot.index.tolist()], rotation=90)
ax.set_xticks(range(0, len(graph_df_pivot2.index.tolist())))
ax.set_xticklabels([str(i) for i in graph_df_pivot2.index.tolist()], rotation=90)
plt.show()
This is only plotting the data from the first dataset and the second is being overlooked. Any help would be greatly appreciated!
codegraph_df_pivot2.plot(kind='line', figsize=(20,5), grid=True, title='')#, use_index=Truecode