Python Forum
Add a column in a dataframe from another dataframe
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Add a column in a dataframe from another dataframe
#1
Hi there,

I'm a newbie in Python and I need your help.
I tried to search my answer in the forum but I think I don't have the good keywords... It's a shame because the issue seems to be simple (but I'm even not sure of this !). Here's the problem :
I work with 2 dataframes df1 and df2.

df1 has n rows and 3 columns (A has only "NaN") :


ColA |ColB| ColC
_____________________________
NaN | B4 | C1
NaN | B4 | C2
NaN | B1 | C3
...... | .... | ....
NaN | B39 | C(n-1)
NaN | B74 | Cn


df2 has n rows and 2 columns (A and B) :


ColA|ColB
____________________
A1 | B1
A2 | B2
A3 | B3
.... | ....
A(n-1) | B(n-1)
An | Bn


The goal here is to fill the A column from df1 thanks to df2 and to get a dataframe like this :

df1 wanted :
ColA|ColB| ColC
_____________________________
A4 | B4 | C1
A4 | B4 | C2
A1 | B1 | C3
.... | .... | ....
A74 | B74 | Cn

I tried a lot of things (double for loops, pandas methods, etc.) but nothing worked. I think I don't have enough experience.

Someone can direct me towards the good way to solve the issue ?

Thanks !

Bilsix.
Reply
#2
Hiya, Bilsix!

You want to join two tables together. Use the DataFrame.join() method to join them together. This method will create a new DataFrame so be sure to store it.
Reply
#3
Hi stullis,

This method does exactly what I want !
Thanks a lot !

I solved my issue temporarely with a double for loop, but I'll use the "join" method, which is much more clear.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Elegant way to apply each element of an array to a dataframe? sawtooth500 5 219 3 hours ago
Last Post: deanhystad
  Dataframe copy warning sawtooth500 4 193 Mar-25-2024, 11:38 PM
Last Post: sawtooth500
  FutureWarning: The behavior of DataFrame concatenation with empty or all-NA entries i sawtooth500 3 411 Mar-22-2024, 03:08 AM
Last Post: deanhystad
  Adding PD DataFrame column bsben 2 246 Mar-08-2024, 10:46 PM
Last Post: deanhystad
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 690 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Comparing Dataframe to String? RockBlok 2 363 Nov-24-2023, 04:55 PM
Last Post: RockBlok
  Filter data into new dataframe as main dataframe is being populated cubangt 8 923 Oct-23-2023, 12:43 AM
Last Post: cubangt
  DataFRame.concat() nafshar 3 731 Jul-14-2023, 04:41 PM
Last Post: nafshar
  Convert dataframe from str back to datafarme Creepy 1 585 Jul-07-2023, 02:13 PM
Last Post: snippsat
  Question on pandas.dataframe merging two colums shomikc 4 783 Jun-29-2023, 11:30 AM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020