我有一個csv文件,當我用pandas.read_csv過濾列並使用多個索引與usecols輸出。
- import pandas as pd
- from StringIO import StringIO
- csv = r"""dummy,date,loc,x
- bar,20090101,a,1
- bar,20090102,a,3
- bar,20090103,a,5
- bar,20090101,b,1
- bar,20090102,b,3
- bar,20090103,b,5"""
- df = pd.read_csv(StringIO(csv),
- header=0,
- index_col=["date", "loc"],
- usecols=["date", "loc", "x"],
- parse_dates=["date"])
複製代碼
輸出- date loc x
- 2009-01-01 a 1
- 2009-01-02 a 3
- 2009-01-03 a 5
- 2009-01-01 b 1
- 2009-01-02 b 3
- 2009-01-03 b 5
複製代碼 文章出處
|