dataframe两表横向拼接
时间: 2023-11-18 22:54:07 浏览: 151
要实现DataFrame两表的横向拼接,可以使用`pd.concat()`函数。首先,将需要拼接的DataFrame以列表形式传递给`pd.concat()`函数,然后指定`axis=1`参数来表示横向拼接。具体代码如下所示:
```python
import pandas as pd
df1 = pd.DataFrame([['Tom','2001',98], ['Jack','2002',63], ['Lucy','2003',88], ['Nick','2004',100]], columns=['姓名','学号','成绩'])
df2 = pd.DataFrame([['Tom','2001','一班'], ['Jack','2002','二班'], ['Lucy','2003','二班'], ['Anny','2005','一班']], columns=['姓名','学号','班级'])
result = pd.concat([df1, df2], axis=1)
```
其中,`df1`和`df2`分别是需要拼接的两个DataFrame,`axis=1`表示沿着列的方向进行拼接。拼接后的结果存储在`result`变量中。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* *3* [dataframe横向和纵向拼接](https://blog.csdn.net/Monkey_wang_/article/details/116245602)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]
阅读全文
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)