Python 导入不同文件格式的文件

数据输入
CSV

import pandas as pd
url = 'http://www.quandl.com/api/v1/datasets/WORLDBANK/CHN_NY_GDP_MKTP_CN.csv?column=1'
data = pd.read_csv(url, header=0, index_col=0, parse_dates=True)
data.plot() 

Excel

import pandas as pd
path = '/home/peter/Desktop/gdp.xlsx'
xls = pd.read_excel('/home/peter/Desktop/gdp.xlsx', 0, index_col=0, header=0, parse_dates=True)
xls.plot()