如何将整个数据帧保存在csv文件中？

Question

当我尝试执行file.write（）csv文件中的输出未完成时，我有更多的3000行数据，而我在文件中获得的所有数据都是顶部和底部50行。我究竟做错了什么？

PS进出口编程:)相当新鲜

import pandas as pd 
import quandl 
import unicodecsv 

#getting stock data from Quandl API 
df = quandl.get("WIKI/GOOGL") 
#defining the columns I want to use 
df = df[['Adj. Open', 'Adj. High', 'Adj. Low', 'Adj. Close', 'Adj. Volume']] 
#creating new column and calculating using data from previously defined columns 
df['HL_PCT'] = (df['Adj. High'] - df['Adj. Low'])/df['Adj. Close'] * 100 

df = df[['Adj. Close', 'HL_PCT']] 
print(df) 

file = open('adjClosePCT.csv', 'w') 
file.write(str(df)) 

file.close() 

Answer 1

大熊猫内置to_csv应该做的工作：

df.to_csv('adjClosePCT.csv')