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

file = 'ohlcv.txt'

df = pd.read_csv(file)

print(df.fillna(0.0))

运行结果:

>>>>date open high low close volume

0 19991110 29.50 29.80 27.00 27.75 0.0

1 19991111 27.58 28.38 27.53 27.71 0.0

2 19991112 27.86 28.30 27.77 28.05 0.0

3 19991115 28.20 28.25 27.70 27.75 0.0

4 19991116 27.88 27.97 26.48 26.55 0.0

5 19991117 26.50 27.18 26.37 27.18 0.0

6 19991118 27.20 27.58 26.78 27.02 0.0

7 19991119 27.50 27.53 26.80 26.88 0.0

8 19991122 26.88 26.95 26.30 26.45 0.0

推荐阅读