python：pandas DataFrame 连接表

以画基金净值与龙头股收盘价比较图为例：

512071.csv 数据格式

date,jz,ljjz
2016-01-04,1.7296,1.7296

600030.csv tushare 数据格式

,date,open,close,high,low,volume,code
0,2017-04-11,15.537,15.546,15.565,15.345,559001.0,600030
1,2017-04-12,15.575,15.642,15.756,15.517,947871.0,600030

different.py

# coding: utf-8
import os, sys
import matplotlib.pyplot as plt
import pandas as pd

# 512070,易方达沪深300非银ETF基金
df = pd.read_csv('512070.csv', index_col='date')
df1 = df[['jz']]
print(df1.head())

# 600030,中信证券，为了与基金净值比较，收盘价/10
df = pd.read_csv('600030.csv', index_col='date')
df2 = df[['close']].apply(lambda x:x/10)
print(df2.head())

# pandas DataFrame 连接表
df3 = pd.merge(df1, df2, left_index=True, right_index=True, how='inner')
#df3 = df1.join(df2, how='inner')
print(df3.head())

df3.index = pd.to_datetime(df3.index)
# 画基金净值与龙头股收盘价比较图
df3[['jz','close']].plot(kind='line',grid=True,title='512070 vs 600030')
plt.show()