零基础学Python--不得不说的Pandas小技巧(21)

运行结果:

>>>>date open  high  low close volume

5 19991117 26.5 27.18 26.37 27.18   NaN

6 19991118 27.2 27.58 26.78 27.02   NaN

7 19991119 27.5 27.53 26.80 26.88   NaN

重置索引号

import pandas as pd

file = 'ohlcv.txt'

df = pd.read_csv(file)

df = df[(df['date'
>19991116) & (df['date'
<19991120)

df = df.reset_index()

运行结果:

>>>>index   date open  high  low close volume

推荐阅读