matplotlib画出畸形图

plok1221

各位大佬帮忙看看,两只股票的EOD close图形,用tableau和plt画出来不一样,plt明显有问题~

import matplotlib.pyplot as plt  
import seaborn as sns
stock_df1 = stock_close_list['300171.SZ']
stock_df2 = stock_close_list['300494.SZ']
stock_df1.plot(); stock_df2.plot()
plt.xlabel("Time"); plt.ylabel("Price")
plt.legend(["300171", "300494"],loc='best')

plt:

                               
登录/注册后可看大图

tableau:

                               
登录/注册后可看大图

plok1221

请高手帮忙看一下

plok1221

stock_close_list['300171.SZ']

trade_date
20160104    26.56
20160105    26.26
20160106    26.18
20160107    23.56
20160108    22.59
20160111    20.34
20160112    20.66
20160113    18.99
20160114    20.26
20160115    19.34
20160118    19.75
20160119    20.66
20160120    20.50
20160121    19.61
20160122    19.88
20160125    20.33
20160126    18.59
20160127    18.30
20160128    16.92
20160129    18.19
20160201    17.77
20160202    18.50
20160203    18.86
20160204    19.25
20160205    19.09
20160215    19.67
20160216    20.51
20160217    20.48
20160218    19.98
20160219    20.04
            ...  
20181009     6.35
20181010     6.36
20181011     5.72
20181012     5.55
20181015     5.47
20181016     5.32
20181017     5.41
20181018     5.28
20181019     5.40
20181022     5.62
20181023     5.55
20181024     5.56
20181025     5.57
20181026     5.61
20181029     5.49
20181030     5.53
20181031     5.65
20181101     5.67
20181102     5.79
20181105     5.84
20181106     5.87
20181107     6.01
20181108     5.93
20181109     5.84
20181112     6.01
20181113     6.14
20181114     6.14
20181115     6.75
20181116     7.43
20181119     8.17
Name: 300171.SZ, Length: 702, dtype: float64

塔利班

plt的代码和数据发下，我试试

wyyax187

PLT代码看看啊

plok1221

@wyyax187 @塔利班

import matplotlib.pyplot as plt  
import pandas as pd
import seaborn as sns
stock_df1 = pd.read_csv(r'stock_df1.csv',sep=',',engine ='python')
stock_df1.plot()
plt.xlabel("Time"); plt.ylabel("Price")
plt.legend()

塔利班

1. import matplotlib.pyplot as plt  
   
2. import pandas as pd
   
3. import seaborn as sns
   
4. stock_df1 = pd.read_csv(r'stock_df1.csv',sep=',')
   
5. stock_df1['300171_close'].plot()
   
6. plt.xlabel("Time"); plt.ylabel("Price")
   
7. plt.legend()
   
8. plt.show()

复制代码

这么整价格就没问题了，我研究下怎么调整x轴

塔利班

1. import matplotlib.pyplot as plt  
   
2. import pandas as pd
   
3. import seaborn as sns
   
4. 
   
5. s = pd.read_csv(r'stock_df1.csv',sep=',')
   
6. s['date']=s['date'].astype('str')
   
7. s['date']=pd.to_datetime(s['date'])
   
8. t=pd.DataFrame(s['300171_close'])
   
9. t.index=s['date']
   
10. t.plot()
    
11. plt.xlabel("Time"); plt.ylabel("Price")
    
12. plt.legend()
    
13. plt.show()

复制代码

完全不懂，一顿查搞出来了

plok1221

多谢啦!@塔利班