天池大赛查漏补缺:CSV打开设定列名,及取指定列、行索引,和修改列名

#delimiter=',' 以 , 分割成列  也可以以"/n"替代  
#name为指定列名

test_r=pd.read_csv("H:\\pythonchengx_u\\Antai\\Antai\\data\\Antai_AE_round1_submit_20190715.csv",delimiter=',', header=None, names= ["buyer_id", '1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30'])
#取出指定列
buyer = pd.DataFrame(test_r, columns = ["buyer_id"])

如果要自己指定行索引和列索引,可以使用 index 和 column 参数:

 

ridership_df = pd.DataFrame(
    data=[[   0,    0,    2,    5,    0],
          [1478, 3877, 3674, 2328, 2539],
          [1613, 4088, 3991, 6461, 2691],
          [1560, 3392, 3826, 4787, 2613],
          [1608, 4802, 3932, 4477, 2705],
          [1576, 3933, 3909, 4979, 2685],
          [  95,  229,  255,  496,  201],
          [   2,    0,    1,   27,    0],
          [1438, 3785, 3589, 4174, 2215],
          [1342, 4043, 4009, 4665, 3033]],
    index=['05-01-11', '05-02-11', '05-03-11', '05-04-11', '05-05-11',
           '05-06-11', '05-07-11', '05-08-11', '05-09-11', '05-10-11'],
    columns=['R003', 'R004', 'R005', 'R006', 'R007']
)

 

#修改列名

buyer =buyer .rename(columns={'buyer_id':'buyitem_id'})