使用panda连接2个csv文件,不包括行索引

2024-04-20 00:15:44 发布

您现在位置:Python中文网/ 问答频道 /正文

如何使用panda连接2个CSV文件,使生成的CSV文件没有行索引?见下例:

文件1.csv

date                    type      price           amount    
2017-09-02 00:00:01     b         0.279111        94000       
2017-09-02 00:00:01     b         0.279           43800          
2017-09-02 00:00:01     b         0.2789          6000     
2017-09-02 00:00:01     b         0.278812        2000         
2017-09-02 00:00:01     b         0.278           7250   

文件2.csv

date                    type    price           amount    
2018-03-02 00:00:01     q         0.279111       1400       
2018-05-01 00:00:01     q         0.279          3800          
2017-09-02 00:00:01     q         0.2789         640  

想要的_文件.csv你知道吗

date                   type       price           amount    
2017-09-02 00:00:01     b         0.279111        94000       
2017-09-02 00:00:01     b         0.279           43800          
2017-09-02 00:00:01     b         0.2789          6000     
2017-09-02 00:00:01     b         0.278812        2000         
2017-09-02 00:00:01     b         0.278           7250     
2018-03-02 00:00:01     q         0.279111        1400       
2018-05-01 00:00:01     q         0.279           3800          
2017-09-02 00:00:01     q         0.2789          640   

不是这个:

     date                   type       price           amount    
1    2017-09-02 00:00:01     b         0.279111        94000       
2    2017-09-02 00:00:01     b         0.279           43800          
3    2017-09-02 00:00:01     b         0.2789          6000     
4    2017-09-02 00:00:01     b         0.278812        2000         
5    2017-09-02 00:00:01     b         0.278           7250     
6    2018-03-02 00:00:01     q         0.279111        1400       
7    2018-05-01 00:00:01     q         0.279           3800          
8    2017-09-02 00:00:01     q         0.2789          640   

我的代码:

import pandas as pd

a = pd.read_csv("file1.csv")
b = pd.read_csv("file2.csv")

combined = pd.concat([a, b])

combined.to_csv("desired_file.csv")

谢谢:)


Tags: 文件csv代码importpandasreaddateas