Plot Pandas DataFrame as Bar and Line on the same one chart

by

The DataFrame plotting methods return a matplotlib AxesSubplot or list of AxesSubplots. (See the docs for plot, or boxplot, for instance.)

You can then pass that same Axes to the next plotting method (using ax=ax) to draw on the same axes:

ax = df_13_14_target[['month','2014_target_val']].plot(x='month',linestyle="-", marker="o")
df_13_14_target[['month','2013_val','2014_val']].plot(x='month', kind='bar', 
   ax=ax)

import pandas as pd
import matplotlib.pyplot as plt

left_2013 = pd.DataFrame(
    {'month': ['jan', 'feb', 'mar', 'apr', 'may', 'jun', 'jul', 'aug', 'sep',
               'oct', 'nov', 'dec'],
     '2013_val': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 9, 6]})

right_2014 = pd.DataFrame({'month': ['jan', 'feb'], '2014_val': [4, 5]})

right_2014_target = pd.DataFrame(
    {'month': ['jan', 'feb', 'mar', 'apr', 'may', 'jun', 'jul', 'aug', 'sep',
               'oct', 'nov', 'dec'],
     '2014_target_val': [2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13]})

df_13_14 = pd.merge(left_2013, right_2014, how='outer')
df_13_14_target = pd.merge(df_13_14, right_2014_target, how='outer')

ax = df_13_14_target[['month', '2014_target_val']].plot(
    x='month', linestyle="-", marker="o")
df_13_14_target[['month', '2013_val', '2014_val']].plot(x='month', kind='bar',
                                                        ax=ax)

plt.show()

enter image description here

More Related Contents:

  1. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  2. Stacked Bar Chart with Centered Labels
  3. Pandas timeseries plot setting x-axis major and minor ticks and labels
  4. FutureWarning: elementwise comparison failed; returning scalar, but in the future will perform elementwise comparison
  5. Pandas – Plotting a stacked Bar Chart
  6. Improve subplot size/spacing with many subplots in matplotlib
  7. Seaborn Barplot – Displaying Values
  8. How to give a pandas/matplotlib bar graph custom colors
  9. How to add hovering annotations to a plot
  10. How to invert the x or y axis
  11. Matplotlib DateFormatter for axis label not working
  12. How to plot multi-color line if x-axis is date time index of pandas
  13. How to dynamically update a plot in a loop in IPython notebook (within one cell)
  14. How to save a Seaborn plot into a file
  15. Plotting time-series data with seaborn
  16. How to plot different groups of data from a dataframe into a single figure
  17. How to create a grouped bar plot
  18. Seaborn Bar Plot Ordering
  19. Matplotlib showing x-tick labels overlapping
  20. matplotlib plot window won’t appear
  21. matplotlib savefig() size control
  22. How to display percentage above grouped bar chart
  23. Hierarchic pie/donut chart from Pandas DataFrame using bokeh or matplotlib
  24. Python making combined bar and line plot with secondary y-axis
  25. Discrete legend in seaborn heatmap plot
  26. seaborn heatmap using pandas dataframe
  27. Seaborn factor plot custom error bars instead of bootstrapping
  28. Sorted bar charts with pandas/matplotlib or seaborn
  29. Color a scatter plot by Column Values
  30. Is it possible to add a string as a legend item

Leave a Comment