问题描述
import numpy as np import pandas as pd import matplotlib.pyplot as plt # create dataframes df0 and df1: index0 = pd.date_range(start='2014-06-01 00:00:00', end='2014-06-01 00:15:00', freq='1S') data0 = np.random.rand(len(index0)) df0 = pd.DataFrame(data=data0, index=index0, columns=['DF0']) index1 = pd.date_range(start='2014-06-01 00:00:00', end='2014-06-01 00:15:00', freq='15S') data1 = np.random.rand(len(index1)) df1 = pd.DataFrame(data=data1, index=index1, columns=['DF1']) # plot df0 and df1: fig,ax1 = plt.subplots(figsize=(40,10)) ax2 = ax1.twinx() df0.plot.line( color="r", ax = ax1) df1.plot.bar( color ='b', linewidth = 5, ax = ax2, alpha = 0.7) plt.show()
我可以将数据框叠加为两个线图或两个条形图.但是无论我多么努力,我都无法用条形图或相反的方式覆盖线图?使用上面的代码,我只得到了 df1 的条形图,但看不到 df0 的线图.我有什么不同的做法?
I can overlay the dataframes as two line plots or as two barplots. But however hard I try, I can't manage to overlay a line plot with a bar plot or the other way round? With the code above I only get the barplot of df1 but don't see the lineplot of df0. What do I have to do differently?
推荐答案
bar plot 仅将分类(字符串)值作为 x 值.因此,简单的 hack 可以将时间戳转换为字符串.
bar plot takes categorical (string) values only as the x values. hence simple hack can be converting the time stamps to strings.
当您输入浮点值时,它将它们转换为 str ,因此它们与线图 x 值的索引不匹配.
when you feed the float values, it converts them into str thereby they are not matching with the index of line plot x-values.
df0.index = df0.index.map(str)
此操作也不需要辅助轴.
Secondary axis would also be not required for this.
试试这个!
import numpy as np import pandas as pd import matplotlib.pyplot as plt # create dataframes df0 and df1: index0 = pd.date_range(start='2014-06-01 00:00:00', end='2014-06-01 00:15:00', freq='1S') data0 = np.random.rand(len(index0)) df0 = pd.DataFrame(data=data0, index=index0, columns=['DF0']) df0.index = df0.index.map(str) index1 = pd.date_range(start='2014-06-01 00:00:00', end='2014-06-01 00:15:00', freq='15S') data1 = np.random.rand(len(index1)) df1 = pd.DataFrame(data=data1, index=index1, columns=['DF1']) # plot df0 and df1: fig, ax1 = plt.subplots(figsize=(40, 10)) ax = df0.plot.line(color="r") df1.plot.bar(color='b', linewidth=5, ax=ax, alpha=0.7) plt.show()