Python pandas，从具有这些属性的 2 个数据帧构建一个数据帧 [英] Python pandas, build a dataframe from 2 dataframes with these properties

问题描述

我需要解决这个问题.

我需要从两个数据帧构建一个完整的数据帧，但如果需要，只包含来自第二个数据帧的某些信息.

I need to build a whole dataframe from two dataframes, but include only certain info from a second Dataframe if required.

示例:

DF1:

    MATERIAL_N° Description DATE DUE
0   123123300   Lightbulb X 01/05/2018
1   220466      Lightbulb Y 04/04/2018
2   220000      Lightbulb Z 07/07/2018
3   1241241     Lightbulb A 02/01/2019
4   7775447     Lightbulb B 02/01/2019

DF2:

    BG GROUP    MATERIAL N° TRANSIT TIME
0   9001        123123300   45D
1   9002        220466      30D
2   9004        220000      30D
3   9003        44124       20D
4   9000        2512222     15D
5   9002        1241241     40D

预期结果 DF3:

    MATERIAL N° Description     DATE DUE    BG GROUP TRANSIT TIME
0   123123300   Lightbulb X     01/05/2018  9001.0  45D
1   220466      Lightbulb Y     04/04/2018  9002.0  30D
2   220000      Lightbulb Z     07/07/2018  9004.0  30D
3   1241241     Lightbulb A     02/01/2019  9002.0  40D
4   7775447     Lightbulb B     02/01/2019  NaN     NaN

我希望这个例子足够清楚，我需要制作一个大数据框(DF3)在伴随列中添加信息，仅在DF2有可用信息的情况下，否则将该位置留空.

I hope this example is clear enough, i need to make a big dataframe (DF3) adding info in adjoint columns, only in those cases where there is info avaliable from DF2, otherwise leave empty that position.

谢谢！JL

推荐答案

你需要用左参数合并

df1.merge(df2, how = 'left')

    MATERIAL N° Description DATE DUE    BG GROUP    TRANSIT TIME
0   123123300   Lightbulb X 01/05/2018  9001.0      45D
1   220466      Lightbulb Y 04/04/2018  9002.0      30D
2   220000      Lightbulb Z 07/07/2018  9004.0      30D
3   1241241     Lightbulb A 02/01/2019  9002.0      40D
4   7775447     Lightbulb B 02/01/2019  NaN         NaN

这篇关于Python pandas，从具有这些属性的 2 个数据帧构建一个数据帧的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！