Pandas对文件的处理

读取文件

#读取csv文件
# pandas.read_csv(filepath_or_buffer,sep=',',header='infer',names-None,index_col=None,dtype=None,
#     engine=None,nrows=None)
#  filepath_or_buffer  #接受str,文件路径，可以是有效的URL方案（http，ftp，S3,FILE）
#  sep                 # 接收str，分隔符，read_csv默认为 ， 
#  header              #接受int或sequence，表示是否将某行数据作为列名，默认为自动识别
#  names               # header=None 时设置此字段使用列表初始化列名
#  index_col           # 表示选择哪列作为行索引，默认为None
#  usecols             #选择读取文件中的某些列。设置为相应列的索引列表
#  skiprows            #跳过行 可选择跳过前n行或给出跳过的行索引列表
#  encoding            # 编码，常用的编码 utf-8 、utf-16、gbk，gb2312、gb18030d等

import numpy as np
import pandas as pd
import os

record = pd.read_csv(r"C:\Users\Johnny Zhou\Desktop\record.csv",
                 usecols = ['CUSTOMER_ID','CONSUME_TYPE','CONSUME_NUM','BILL_NO'])
record

980602 rows × 4 columns

# record01 = pd.read_excel(r"C:\Users\Johnny Zhou\Desktop\用户价值分层企业名单明细.xlsx")
# record01

5744 rows × 8 columns

写入文件

new_record = pd.DataFrame.to_csv('D:\学习\numpy')

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-38-da50e4312e35> in <module>()
----> 1 new_record = pd.DataFrame.to_csv('D:\学习\numpy')
E:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py in to_csv(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, line_terminator, chunksize, tupleize_cols, date_format, doublequote, escapechar, decimal)
   1742                                  date_format=date_format,
   1743                                  doublequote=doublequote,
-> 1744                                  escapechar=escapechar, decimal=decimal)
   1745         formatter.save()
   1746 
E:\ProgramData\Anaconda3\lib\site-packages\pandas\io\formats\csvs.py in __init__(self, obj, path_or_buf, sep, na_rep, float_format, cols, header, index, index_label, mode, nanRep, encoding, compression, quoting, line_terminator, chunksize, tupleize_cols, quotechar, date_format, doublequote, escapechar, decimal)
     69 
     70         self.tupleize_cols = tupleize_cols
---> 71         self.has_mi_columns = (isinstance(obj.columns, MultiIndex) and
     72                                not self.tupleize_cols)
     73 
AttributeError: 'str' object has no attribute 'columns'