Pandas Adding Column To DataFrame - 5 Methods

Thanks for the information brother. Keep making such videos. All the best.

Helped me! Thanks !!

great content

Solid work

Thank you, Sir! but there's question from me. in question 3, using df.assign. what if we want to access starting from the second index?

Thanks ... helpful

How can I add a column to my dataframe which will contain values of a column in another dataframe
eg. I have 2 dataframes : df1 and df2
df2 has a column named "Education"
I want to add this "Education" column in df1 with its values

Sir can you tell me how to do this?

Thanks you, but just a question.
How can you use 3. .assign. in a df:

I have a column fill with strings with multiple values separated by a comma. (example: column = genres, values = 'action,crime,drama') but every row might have one, two or three genres.
I want to add the amount of genres into that new column. (example: if column = genres, values = 'action,crime,drama' , new_column = 3)

thanks!

Helpful, I was trying the assign function. I've a column "Age" and I wanted another column with half the value of age. So, as you mentioned, I wrote:

data_pandas.assign(HalfAge=lambda x:x.Age)

It's not making any difference, the output dataframe is the same as the input one, any possible error that you may think of?

short and concise, thanks

What is the best way of performing some numerical calculations on existing columns and then output that to two addition columns and choose which index you wish to have them insert at. I've tried using the lambda as you've shown here but it's not showing up on my csv.

Short and complete! Bravo

thanks man

Thanks Bro!!!

Thank you. I could not get my code to run. Thank you….

Outstanding well done!