DataFrame对象的merge函数使用小结

最新推荐文章于 2024-04-10 05:03:30 发布
最新推荐文章于 2024-04-10 05:03:30 发布
阅读量908 收藏 1
点赞数
分类专栏： # pandas 文章标签： DataFrame merge
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/On_theway10/article/details/86654867
版权

NBA_basic_dataset:

+-------------+-----------+---------+--------+--------+
|     name    |    team   | poision | height | weight |
+-------------+-----------+---------+--------+--------+
|    jordan   |   Bulls   |    SG   |  198   |  98.0  |
|     kobe    |   Lakers  |    SG   |  198   |  96.0  |
|    Oneil    |   Lakers  |    C    |  216   | 147.0  |
|   McGradyg  |  Rockets  |    SF   |  203   | 101.0  |
|  Larry_Bird |   Boston  |    PF   |  206   | 100.0  |
|   Iverson   |    76s    |    PG   |  183   |  75.0  |
|   Olajuwon  |  Rockets  |    C    |  208   | 116.0  |
+-------------+-----------+---------+--------+--------+

NBA_record_dataset:

+-------------+-------+------------+--------+-------------+---------+
|     name    | nmvps | nChampions | nfmvps | n_all_stars | nscores |
+-------------+-------+------------+--------+-------------+---------+
|    jordan   |   5   |     6      |   6    |      14     |  32292  |
|     kobe    |   1   |     5      |   2    |      18     |  33643  |
|    Duncan   |   2   |     5      |   3    |      15     |  26496  |
|   Johnson   |   3   |     5      |   3    |      12     |  17707  |
+-------------+-------+------------+--------+-------------+---------+
  • df = pd.merge(df_basic, df_record, on='name', how='left')
+------------+---------+---------+--------+--------+-------+------------+--------+-------------+---------+
|    name    |   team  | poision | height | weight | nmvps | nChampions | nfmvps | n_all_stars | nscores |
+------------+---------+---------+--------+--------+-------+------------+--------+-------------+---------+
|   jordan   |  Bulls  |    SG   |  198   |  98.0  |  5.0  |    6.0     |  6.0   |     14.0    | 32292.0 |
|    kobe    |  Lakers |    SG   |  198   |  96.0  |  1.0  |    5.0     |  2.0   |     18.0    | 33643.0 |
|   Oneil    |  Lakers |    C    |  216   | 147.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|  McGradyg  | Rockets |    SF   |  203   | 101.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
| Larry_Bird |  Boston |    PF   |  206   | 100.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|  Iverson   |   76s   |    PG   |  183   |  75.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|  Olajuwon  | Rockets |    C    |  208   | 116.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
+------------+---------+---------+--------+--------+-------+------------+--------+-------------+---------+
  • df = pd.merge(df_record, df_basic, on='name', how='left')
+---------+-------+------------+--------+-------------+---------+--------+---------+--------+--------+
|   name  | nmvps | nChampions | nfmvps | n_all_stars | nscores |  team  | poision | height | weight |
+---------+-------+------------+--------+-------------+---------+--------+---------+--------+--------+
|  jordan |   5   |     6      |   6    |      14     |  32292  | Bulls  |    SG   | 198.0  |  98.0  |
|   kobe  |   1   |     5      |   2    |      18     |  33643  | Lakers |    SG   | 198.0  |  96.0  |
|  Duncan |   2   |     5      |   3    |      15     |  26496  |  nan   |   nan   |  nan   |  nan   |
| Johnson |   3   |     5      |   3    |      12     |  17707  |  nan   |   nan   |  nan   |  nan   |
+---------+-------+------------+--------+-------------+---------+--------+---------+--------+--------+
  • df = pd.merge(df_basic, df_record, on='name', how='right')
+---------+--------+---------+--------+--------+-------+------------+--------+-------------+---------+
|   name  |  team  | poision | height | weight | nmvps | nChampions | nfmvps | n_all_stars | nscores |
+---------+--------+---------+--------+--------+-------+------------+--------+-------------+---------+
|  jordan | Bulls  |    SG   | 198.0  |  98.0  |   5   |     6      |   6    |      14     |  32292  |
|   kobe  | Lakers |    SG   | 198.0  |  96.0  |   1   |     5      |   2    |      18     |  33643  |
|  Duncan |  nan   |   nan   |  nan   |  nan   |   2   |     5      |   3    |      15     |  26496  |
| Johnson |  nan   |   nan   |  nan   |  nan   |   3   |     5      |   3    |      12     |  17707  |
+---------+--------+---------+--------+--------+-------+------------+--------+-------------+---------+
  • df = pd.merge(df_record, df_basic, on='name', how='right')
+------------+-------+------------+--------+-------------+---------+---------+---------+--------+--------+
|    name    | nmvps | nChampions | nfmvps | n_all_stars | nscores |   team  | poision | height | weight |
+------------+-------+------------+--------+-------------+---------+---------+---------+--------+--------+
|   jordan   |  5.0  |    6.0     |  6.0   |     14.0    | 32292.0 |  Bulls  |    SG   |  198   |  98.0  |
|    kobe    |  1.0  |    5.0     |  2.0   |     18.0    | 33643.0 |  Lakers |    SG   |  198   |  96.0  |
|   Oneil    |  nan  |    nan     |  nan   |     nan     |   nan   |  Lakers |    C    |  216   | 147.0  |
|  McGradyg  |  nan  |    nan     |  nan   |     nan     |   nan   | Rockets |    SF   |  203   | 101.0  |
| Larry_Bird |  nan  |    nan     |  nan   |     nan     |   nan   |  Boston |    PF   |  206   | 100.0  |
|  Iverson   |  nan  |    nan     |  nan   |     nan     |   nan   |   76s   |    PG   |  183   |  75.0  |
|  Olajuwon  |  nan  |    nan     |  nan   |     nan     |   nan   | Rockets |    C    |  208   | 116.0  |
+------------+-------+------------+--------+-------------+---------+---------+---------+--------+--------+
  • df = pd.merge(df_basic, df_record, on='name', how='inner')
+--------+--------+---------+--------+--------+-------+------------+--------+-------------+---------+
|  name  |  team  | poision | height | weight | nmvps | nChampions | nfmvps | n_all_stars | nscores |
+--------+--------+---------+--------+--------+-------+------------+--------+-------------+---------+
| jordan | Bulls  |    SG   |  198   |  98.0  |   5   |     6      |   6    |      14     |  32292  |
|  kobe  | Lakers |    SG   |  198   |  96.0  |   1   |     5      |   2    |      18     |  33643  |
+--------+--------+---------+--------+--------+-------+------------+--------+-------------+---------+
  • df = pd.merge(df_record, df_basic, on='name', how='inner')
+--------+-------+------------+--------+-------------+---------+--------+---------+--------+--------+
|  name  | nmvps | nChampions | nfmvps | n_all_stars | nscores |  team  | poision | height | weight |
+--------+-------+------------+--------+-------------+---------+--------+---------+--------+--------+
| jordan |   5   |     6      |   6    |      14     |  32292  | Bulls  |    SG   |  198   |  98.0  |
|  kobe  |   1   |     5      |   2    |      18     |  33643  | Lakers |    SG   |  198   |  96.0  |
+--------+-------+------------+--------+-------------+---------+--------+---------+--------+--------+
  • df = pd.merge(df_basic, df_record, on='name', how='outer')
+------------+---------+---------+--------+--------+-------+------------+--------+-------------+---------+
|    name    |   team  | poision | height | weight | nmvps | nChampions | nfmvps | n_all_stars | nscores |
+------------+---------+---------+--------+--------+-------+------------+--------+-------------+---------+
|   jordan   |  Bulls  |    SG   | 198.0  |  98.0  |  5.0  |    6.0     |  6.0   |     14.0    | 32292.0 |
|    kobe    |  Lakers |    SG   | 198.0  |  96.0  |  1.0  |    5.0     |  2.0   |     18.0    | 33643.0 |
|   Oneil    |  Lakers |    C    | 216.0  | 147.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|  McGradyg  | Rockets |    SF   | 203.0  | 101.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
| Larry_Bird |  Boston |    PF   | 206.0  | 100.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|  Iverson   |   76s   |    PG   | 183.0  |  75.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|  Olajuwon  | Rockets |    C    | 208.0  | 116.0  |  nan  |    nan     |  nan   |     nan     |   nan   |
|   Duncan   |   nan   |   nan   |  nan   |  nan   |  2.0  |    5.0     |  3.0   |     15.0    | 26496.0 |
|  Johnson   |   nan   |   nan   |  nan   |  nan   |  3.0  |    5.0     |  3.0   |     12.0    | 17707.0 |
+------------+---------+---------+--------+--------+-------+------------+--------+-------------+---------+

df = pd.merge(df_record, df_basic, on='name', how='outer')

+------------+-------+------------+--------+-------------+---------+---------+---------+--------+--------+
|    name    | nmvps | nChampions | nfmvps | n_all_stars | nscores |   team  | poision | height | weight |
+------------+-------+------------+--------+-------------+---------+---------+---------+--------+--------+
|   jordan   |  5.0  |    6.0     |  6.0   |     14.0    | 32292.0 |  Bulls  |    SG   | 198.0  |  98.0  |
|    kobe    |  1.0  |    5.0     |  2.0   |     18.0    | 33643.0 |  Lakers |    SG   | 198.0  |  96.0  |
|   Duncan   |  2.0  |    5.0     |  3.0   |     15.0    | 26496.0 |   nan   |   nan   |  nan   |  nan   |
|  Johnson   |  3.0  |    5.0     |  3.0   |     12.0    | 17707.0 |   nan   |   nan   |  nan   |  nan   |
|   Oneil    |  nan  |    nan     |  nan   |     nan     |   nan   |  Lakers |    C    | 216.0  | 147.0  |
|  McGradyg  |  nan  |    nan     |  nan   |     nan     |   nan   | Rockets |    SF   | 203.0  | 101.0  |
| Larry_Bird |  nan  |    nan     |  nan   |     nan     |   nan   |  Boston |    PF   | 206.0  | 100.0  |
|  Iverson   |  nan  |    nan     |  nan   |     nan     |   nan   |   76s   |    PG   | 183.0  |  75.0  |
|  Olajuwon  |  nan  |    nan     |  nan   |     nan     |   nan   | Rockets |    C    | 208.0  | 116.0  |
+------------+-------+------------+--------+-------------+---------+---------+---------+--------+--------+

 

ReLuJie
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
pandas由入门到精通—实现DataFrame的Merge(合并)
qq_48081868的博客
08-30 1万+
10.Pandas实现DataFrame的Merge(合并) 文章目录10.Pandas实现DataFrame的Merge(合并)前言Merge的语法：一、电影数据集的join实例二、程序演示1.合并不同表的信息2.理解merge时数量的对齐关系3.理解left join、right join、inner join、outer join的区别4. 如果出现非Key的字段重名怎么办总结 前言 笔者最近正在学习Pandas数据分析，将自己的学习笔记做成一套系列文章。本节主要记录Pandas中DataFram
Pandas中DataFrame基本函数整理(小结)
12-17
本篇文章将对DataFrame的一些基本函数进行整理和总结，帮助你更好地理解和使用这些功能。 1. **构造DataFrame** - `DataFrame(data, index, columns, dtype, copy)`：用于创建DataFrame对象，其中`data`可以是字典...
DataFrame的merge函数
gulie8的博客
04-19 1353
import pandas as pd import numpy as np from pandas import Series, DataFrame df1 = DataFrame({'key':['X','Y','Z'], 'data_set_1':[1,2,3]}) df1 Out[5]: data_set_1 key 0 1 X 1 ...
python dataframe merge_Pandas DataFrame.merge()用法详解
weixin_39636857的博客
12-15 760
本文概述Pandas merge()定义为以下过程：将两个数据集合为一个, 并根据公共属性或列对齐行。它是DataFrame对象之间所有标准数据库联接操作的入口点：句法pd.merge(left, right, how='inner', on=None, left_on=None, right_on=None, left_index=False, right_index=False, sort=T...
Pandas怎样实现DataFrame的Merge（十二）
小龙龙品牌的博客
05-06 245
Pandas的Merge，相当于Sql的Join，将不同的表按key关联到一个表 1、merge的语法： pd.merge(left, right, how=‘inner’, on=None, left_on=None, right_on=None, left_index=False, right_index=False, sort=True, suffixes=(‘x’, ‘y’), copy=...
Pandas教程06：DataFrame.merge数据的合并处理
我的Python教程
12-02 1517
indicator：在合并后的 DataFrame 中添加一个指示列，指示哪些行来自左侧 DataFrame，哪些行来自右侧 DataFrame。可以是 ‘left’（左连接）、‘right’（右连接）、‘outer’（全连接）或 ‘inner’（内连接，默认）。只保留左侧DataFrame中的所有行，如果在键列中没有匹配的行，则填充NaN。保留左侧和右侧DataFrame中的所有行，如果在键列中没有匹配的行，则填充NaN。只保留右侧DataFrame中的所有行，如果在键列中没有匹配的行，则填充NaN。
python pandas.DataFrame.loc函数使用详解
09-17
在Python的Pandas库中，DataFrame对象是处理二维表格数据的核心结构。`DataFrame.loc`是一个强大的功能，用于根据标签（label）或布尔数组选择行和列。它允许我们以多种方式选择、过滤和操作DataFrame中的数据。下面...
pandas创建DataFrame的7种方法小结
01-21
笔者在学习pandas,在学习过程中总结了一下创建dataframe的方法，通过查阅资料总结遗下几种方法，如果你有其他的方法欢迎留言补充。 练习代码 请点击此处下载 学习环境： 第一种： 用Python中的字典生成 第二种： ...
python DataFrame数据合并 merge()、concat()方法，2024年最新进阶加薪全靠它
最新发布
2401_84181536的博客
04-10 2202
df_merge = pd.merge(df1, df2, on=‘id’, how=‘left’)print(df_merge)使用来自右数据集的键df_merge = pd.merge(df1, df2, on=‘id’, how=‘right’)print(df_merge)2.多对一合并import pandas as pddf1 = pd.DataFrame({‘id’: [‘001’, ‘002’, ‘003’],‘num1’: [120, 101, 104],‘num2’: [110, 102
pandas-多个DataFrame同时进行merge合并
Elvis__c的博客
08-18 3395
用merge两个两个合并太繁琐，考虑使用reduce聚合方法。有表df1,df2,df3,df4需要进行合并。或是目录下的所有文件进行合并等。。。。
dataframe的merge操作
热门推荐
lyzkks的博客
04-10 5万+
merge操作的原则 dataframe的merge是按照两个dataframe共有的column进行连接，两个dataframe必须具有同名的column。 如果两个dataframe的column都不相同，则会在merge的时候报错： 而当两个dataframe具有相同的column时，若两个column中没有相同的value，则会merge一个空的dataframe： ...
python DataFrame数据合并 merge()、concat()方法
2301_76348171的博客
04-07 1518
相比方法①，区别在于，如图，方法②合并出的数据中有重复列。| 参数 | 描述 || — | — || left | 左表，合并对象，DataFrame或Series || right | 右表，合并对象，DataFrame或Series || how | 合并方式，可以是left(左合并), right(右合并), outer(外合并), inner(内合并) || on | 基准列 的列名 || left_on | 左表基准列列名 || right_on | 右表基准列列名 || left_index |
dataframe 合并_数据分析之Pandas合并操作总结
weixin_39646970的博客
11-27 3063
↑↑↑关注后"星标"Datawhale每日干货 &每月组队学习，不错过Datawhale干货作者：耿远昊，Datawhale成员，华东师范大学pandas 是一个强大的分析结构化数据的工具集，它的使用基础是Numpy(提供高性能的矩阵运算)，用于数据挖掘和数据分析，同时也提供数据清洗功能。Pandas做分析数据，可以分为索引、分组、变形及合并四种操作。前边已经介绍过索引操作...
python DataFrame数据合并 merge()、concat()方法(1)，看完这篇
2401_83946570的博客
04-04 1530
别在网上瞎学了，我最近也做了一些资源的更新，只要你是我的粉丝，这期福利你都可拿走。我先来介绍一下这些东西怎么用，文末抱走。
python DataFrame merge 函数 合并两个DataFrame（与sql联系）
weixin_49583390的博客
08-31 2180
pd.merge(df1,df2,on="class_id",how="right") 创建两个dataframe temp_dict1 = [{"id":1,"name":"cyw","age":20,"class_id":1}, {"id":2,"name":"xiaogang","age":18,"class_id":2}, {"id":2,"name":"老王","age":18,"class_id":3}, {"id...
python中dataframe合并列名日期到季度_合并dataframe时用零填充缺少的日期数据
weixin_39895684的博客
12-10 257
import pandas as pdimport numpy as npone = pd.read_csv('data1.csv')two = pd.read_csv('data2.csv')我是这么写的，还有一个节目^{pr2}$两场演出B Date15 2011-01-0115 2011-01-0215 2011-01-0325 2011-01-0735 ...
使用pandas.merge合并dataframe，并指定多个关联条件
大数据-攻城狮
10-12 2361
【代码】使用pandas.merge合并dataframe，并指定多个关联条件。
dataframe 合并_Python之Pandas使用系列(四)：Dataframe中merge的用法介绍
weixin_39574246的博客
11-27 749
Pandas可以实现高性能的内存合并和连接。当我们需要组合非常大的DataFrame时，Merge是非常有效并且快速的方法。Merge只能在两个DataFrame上进行联接，分别表示为左表(left)和右表(right)。key是将两个DataFrame连接在一起的公共列。最好使用在整个列中具有唯一值的key，以避免意外的行值重复。Pandas提供了merge()，作为DataFrame之间joi...
深刻理解merge函数中on参数
weixin_40893448的博客
10-05 1438
on列表中无参数时 如果未传递且left_index和right_index为False，则DataFrame中的列的交集将被推断为连接键。 import pandas as pd left = pd.DataFrame({'key': ['K0', 'K1', 'K2', 'K3'], 'A': ['A0', 'A1', 'A2', 'A3'], 'B': ['B0', 'B1', 'B2', 'B3']
dataframe merge函数
03-24
可以使用 pandas 库中的 merge 函数来合并 DataFrame。该函数可以根据指定的列将两个 DataFrame 进行合并，例如： ```python import pandas as pd # 创建两个 DataFrame df1 = pd.DataFrame({'key': ['A', 'B', 'C...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

ReLuJie

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值