Python Pandas Join merge two CSV files using Dataframes | Python for Scott Episode 1

The very first episode of Python for Scott! In this episode, Adam will show Scott how to join merge two CSV files using Python and Pandas dataframes.

#python #pandas #datascience #dataframe #tutorial

[bhangra]

if there is a different in values how you do you do that

[scottevanson]

Wow! Out of all the Scott Evanson specific coding lessons out there this is really one of the best. A must have if you're a Scott Evanson.

[mariei]

You actually helped solve my project after 2 unsuccessful days, with coding appearing in my sleep. Thank you!!!!

[ulfgj]

my wife just waked past the screen seeing your mic. "honey... what r u looking at? a bearded dude holding a machine gun...?"

[Ihatehandlesfashyyoutube]

I have a Bachelor's degree, and followed a professional state sponsored course in Python using many libraries.
He has taught me better than THEM today

[andrewburnley]

This tutorial was really helpful and easy to follow!! always good to add a bot of humour as

[harshbedmutha]

Quite helpful for not so Scott Evanson's too

[RoboCrax]

My name is not Scott but this helped me. Thanks

[ushnakhan]

Thanx buddy for this helpful video❤ keep up tye good work!!!!

[leehelmick]

TY!! You're amazing! Please keep your mistakes in the vid, as it helps idiots like me.

[antonioarana]

BRO! your video is perfect jajaja please don't attack yourself just for a simple human error! jajaj blessings

[Grizathvili]

dude, line 146 is still long, we miss the syntax there. It was truncated.

[brianyang]

Thank you for your video. You mentioned that some numeric data end with a '.0'. Could you provide an example about how to fix it?

[abhishekkarwa]

Please make video with some louder voice....but good content.

[vinayakchikkorde]

I have the source file and target file. so in that, I have to compare 140 columns and show the result if it matches or not. for example, there is a column as Country1 in source and in target as Country2. to compare that i will use True else return false. to compare 140+ columns it will take time to compare 140 columns. and in both of the file columns are not in ordered. so how can I solve this?

[tripod_]

You are awesome, I have a question

I am trying to merge my fields but I am trying to merge them while some of them have errors

For example:

First Name, Last Name, Title

\tFirst Name, \t\tLast Name, Title

I feel like you can explain that pretty good

[jatinsharma]

Only Scott can hear what you're saying.
PS: Thanks

[dipenraj]

How can I combine 3 tables with these code?