I'd like to thank the author. You really do a great job. Everything is structured, decomposed and coherent. Some guys just jump in complex coding without really explaining what's going on there.
I just wanted to thank you for such a great explanation of joins. I did not have it explained to me and struggled for the longest time to understand them. It takes a good teacher and someone who can understand it simply for one to understand it. Seriously, you are amazing!!
The best new feature with merge is the validate option to make sure your join is 1:1, 1:M, etc. This is very useful for machine learning projects or end user reports that rely on upstream data that is updated regularly. It's saved me headaches a few times.
Thanks for the videos Kevin! I love your teaching style and how you make each concept so crystal clear. Please keep making these videos! Just signed up to become a patron of yours and am taking your course on Data Camp (I wish you taught more courses on there!) Once I master Pandas will try out your machine learning course too :) ps your son is so adorable
Your videos are fantastic. I really appreciate the simple "common sense" approach to the teaching. It is quite easy for instructors to dive right into python lingo.
Really appreciate the work you put in for this video :) I've been working with dataframes for a few months, and this merge/join/concat always was a bit confusing for me. This video was perfect for clearing some of my doubts, and I'll definitely be back to reference again soon ;)
Brilliant Stuff, All videos are awesome. Clearly explained all fundamentals...Thanks for making this stuff easy. On a different line, you remind me of "Sheldon" from the TV series The Big bang theory and this is a compliment. :)
Your videos are always amazing. You are a national treasure in my book. Don't change a thing, but for viewer 1.75 speed is the speed to watch these in.
This is 1st time i walked into your video and i am very much impressed by your explaination and your english speaking pace is perfect. loved your content. Thanks a lot. :)
I'm not able to read that file "u.item" , I copied the same code from GitHub but pandas wasn't able to read that. It showed me Unicode Error... How do I solve that issue..
You are a great instructor. I have learned a lot from you regarding pandas. The video with title "How do I merge DataFrames in pandas?" has left some queries in my mind. I would be thankful to you if you clear those too. What type of join is used here movie_ratings = pd.merge(movies , ratings)? if it is inner join it should result in 1682 rows in total in movie_ratings dataframe, as movies dataframe has 1682 rows. But in video i have observed that movie_ratings results in 100,000 rows of data.
hi, when I used pd.concat([df1,df2]), I got a tuple object instead of a dataframe object. I am using Python 3.9 environment. I would like to know what should I do to get a dataframe object rather than a tuple object?
Hi Kevin, thanks to your turtoring, I learn a lot from your channel, it's amazing! Since I just learn Pandas, I'm a little bit confused about concat(), melt(), merge(), pivot(), stack()...They're really annoying to me >< I really hope we have a one for all solution of how to use these functions XD Thank you!
I really enjoy your tutorials, thanks so much! I have 5 csv files that come out daily each containing a date column. i want to merge them all using the date as the merge field. i tried a basic merge with 2 of the csv files and date was used as the merge-on field by default - so it worked. ultimately i just need one date column in my masterfile with all the other column data merged. should I continue to do this or is it better to set the date column as the index, or something else?
Great work as allways. Very useful. Thanks for sharing it! By the way, any chance you get some video done about PySpark? It will be very usefull to treat this from the biginning considering examples based on a local connection (one computer) first and then a couple of examples emulating a cluster connection.
Great video. However I have a little issue. I have 3 data frames that I am trying to merge together. The first is a pretty long database with columns (cust_id, gained_on gained_from_supplier, lost_to_supplier, sales_channel_id) the second is the supplier data frame (supplier_name, supplier_id) what I am trying to do is merge the supplier id and name from the second data frame, to the database frame which has the ID so supplier id to the number using the lefton/right on but instead it returns both columns - the supplier ID and name of both dataframes. Then the same with the channel data frame (sales_channel_name, sales_channel_id) and merge this with the sales_channel_id in the database dataframe and show the name instead. Any help would be appreciated, thank you!
You're great teacher! I see the despite having a large 100K row file, the number of rows do not get expanded after the merge. They beautifully stay the same and just add the movie titles to the reviews. Can you comment on why this is not always the case. I have tried and my output file gets expanded by a few rows (17 out of 1000) and I have not been able to figure out why. I have checked multiple videos and some come absurd not practical solutions (like the files are the same size) or arbitrarily eliminate any dups (despite some may be valid rows), but none explain the reason and how to identify those rows that could be dups. Your comments are appreciated.
Hi Kevin , First of all thanks for the wonderful lecturer , I am facing a problem to merge two data frames which i have shown you below .. Data frame 1: BackupServer BackupDay StartDate ClientName BackupStatus Backup re-run(Y/N) Incident Reason for the Backup Failures Backup Final Outcome RGSIBAK004 01-05-2020 2020-04-30 06:40:29 RGBPLNM110 Completed NaN NaN NaN NaN RGSIBAK004 01-05-2020 2020-04-30 06:53:07 RGPIAPP037 Completed NaN NaN NaN NaN RGSIBAK004 01-05-2020 2020-04-30 15:32:38 RGPIISD001 Failed Yes IN893523 VM disconnected Failed RGSIBAK004 01-05-2020 2020-04-30 18:00:08 RGPPFTP005 Completed NaN NaN NaN NaN RGSIBAK004 01-05-2020 2020-04-30 18:00:02 RGPQWEB069 Completed NaN NaN NaN NaN Data Frame 2 : BackupServer BackupDay StartDate Client Name Backup Status Backup Rerun (Y/N) Incident Failures Backup Final Result RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpqbda112.fdnet.com Activity completed successfully. NaN NaN NaN NaN RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpppcc051.fdnet.com Activity completed successfully. NaN NaN NaN NaN RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpppcc050.fdnet.com Activity completed successfully. NaN NaN NaN NaN RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpppcc011.fdnet.com Activity completed successfully. NaN NaN NaN NaN RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpdbda105.fdnet.com Activity completed successfully. NaN NaN NaN NaN Although the two data frames have three column names "Backupserver" , "Backupday" and start date ...the content in the columns is different and i am not able to merge these two data frames into one ? Can you help me on this?
How to merge multiple large dataframes in a fast way? I joined with usual merge() but it seems too slow. I found a clue of using pandas.Index() with the merge method, but i don't know how to use it.
above logic is beautifully explained, hi kevin, i have a question if you could please reply, I have three csv files csv1(20000 rows), csv2(20000 rows),cvs3(20000 rows), i want to merge these files into single data frame without losing a single record? Like i want to read these files into a one data frame that should have 60000 rows ideally. P.S: All the files have same columns (PostID, time, tweetURL, Content, RetweetNum , LikeNum, CommentsNum, Verified, Following, Follower). And in the resulting data frame i want to have all these columns at once as heading and want all 60000 rows. Is it possible ? kevin i will wait for your reply man, i know this post is old, maybe your read my question. THANK YOU
Sir if we have hundreds of columns without the name. Then how can we name them using pandas and a for loop or lambda function because if we try to name them using names=[] it will be a very time-consuming process. The name of the columns can be col1, col2 , col3...etc.
Thank you very much for that amazing and cleary explanation. By the way, is there a simple way to merge two dataframes with partial match string between the rows?
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 if(source['country1]==target['country2])return 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?
I have a data frame and I have a list and a tuple , I want to merge all three together . I am aware merge can only do two tables at a time, but do you have any helpful hints on how to go about merged the table , list and df. I want make to make the result a new data frame
slowly talk is very helpfull to me. I have 2 questions. The first is : What's if i want merge only one certain column (rating) from df rating to df movie . The second: What's if I want to sum the rate of each Movie_Id . Tks you so much and looking for your answer.
I am a beginner in python, I am not sure what join is the best to use in different scenarios. Can you help me through it?? I genuinely learnt a lot from your videos. I would really appreciate your help. Thank you in advance
hi bro, I am currently working in a project. The mentors says that use foreign keys and primary keys in pandas and create table with the keys. so my question is, the usage of foreign and primary keys in pandas is possible or if we can't what shall I do to merge the two tables contains the same column which we are doing in the MYSQL coding. Thank you.
Lets say a pandas df and mysql have column A, B, C and same schema, Column A in SQL is the primary key. now how to upsert a pandas df to mysql table? When primary key conflicts, then update the remaining columns, when doesn't conflict/exists, then do an Insert Into.. Whats the most efficient way to do this?
Say I want to merge 2 dataframes with the same columns because someone else was working on an excel file. I want to keep everything in both dataframes, but I want, say, the column "category" from dataframe 2 to override the "category" column text in dataframe 1. Would that be left or right merge?
As usual nice tutorial. so thank you for making and sharing. Can you please elaborate about pandas assign function. Also when will you share the code because I want to practice :)
Here is the code for the merge video: nbviewer.jupyter.org/github/justmarkham/pandas-videos/blob/master/pandas_merge.ipynb As for the pandas assign function, this might help you to understand its usage: twitter.com/justmarkham/status/1173995596631478272
You are really good at explaining things. One of the better teachers on youtube. Thanks a ton for this video and I hope there's more coming.
Thank you!
I'd like to thank the author. You really do a great job. Everything is structured, decomposed and coherent. Some guys just jump in complex coding without really explaining what's going on there.
I just wanted to thank you for such a great explanation of joins. I did not have it explained to me and struggled for the longest time to understand them. It takes a good teacher and someone who can understand it simply for one to understand it. Seriously, you are amazing!!
Thank you so much! 🙏
This, by far, is the best explanation of these concepts. Thanks for sharing.
Wow, thank you so much for your kind words! 🙏
Thanks, Kevin.. this is the clearest explanation of the merge I have seen.
Thank you so much!
The best new feature with merge is the validate option to make sure your join is 1:1, 1:M, etc. This is very useful for machine learning projects or end user reports that rely on upstream data that is updated regularly. It's saved me headaches a few times.
The "validate" option is great, I agree! I also like "indicator", which I explained here: twitter.com/justmarkham/status/1153653794829418496
This is one of the best ever videos on pandas functions that I have watched. Well done Data School. I will look forward to more such videos.
Thank you so much! 🙏
Thanks for the videos Kevin! I love your teaching style and how you make each concept so crystal clear. Please keep making these videos! Just signed up to become a patron of yours and am taking your course on Data Camp (I wish you taught more courses on there!) Once I master Pandas will try out your machine learning course too :) ps your son is so adorable
You are too kind, Summer! Thank you SO much for your kind words AND for becoming a patron! 🙌
Great as teacher, calm, taking your time to clearly explain fundamentals!
Thanks so much for your kind words, I truly appreciate it!
That was honestly really good! thank you so much for your work
Your videos are fantastic. I really appreciate the simple "common sense" approach to the teaching. It is quite easy for instructors to dive right into python lingo.
Thank you so much for your kind words!
Really appreciate the work you put in for this video :) I've been working with dataframes for a few months, and this merge/join/concat always was a bit confusing for me. This video was perfect for clearing some of my doubts, and I'll definitely be back to reference again soon ;)
Thanks so much for your kind words! 🙏
wonderfull, loved your slow passed english, that helped me a lot
Glad it helped!
Supercool. Very impressive how you manage to explain the pretty complicated functionality of merge. Thanks.
Glad it was helpful!
Dude! Let me tell you, you saved me a lot of time and work! Thank you so much!
Great to hear!
Excellent way of teaching. Thanks Kevin
Glad it was helpful! 🙌
Nice teaching method. precision over pace.
Glad it was helpful!
Brilliant Stuff, All videos are awesome. Clearly explained all fundamentals...Thanks for making this stuff easy.
On a different line, you remind me of "Sheldon" from the TV series The Big bang theory and this is a compliment. :)
Ha! So many people have said that 😄
This was a well-paced, clear and complete explanation of the topic, thank you very much! It helped me a lot
That's awesome to hear!
You're an amazing teacher. Thanks a lot for these.
Thank you! 😃
Thanks Kevin I have been looking for this for long time!
Awesome! I'm so glad to hear this is the video you needed! 🙌
Your videos are always amazing. You are a national treasure in my book. Don't change a thing, but for viewer 1.75 speed is the speed to watch these in.
Thank you! 🙌
This is 1st time i walked into your video and i am very much impressed by your explaination and your english speaking pace is perfect. loved your content. Thanks a lot. :)
Thanks so much for your kind words!
Kevin you are a super hero of Data science, best videos on tube...
Thank you!
Thanks! very nicely explained. Now, I can perform joins using Pandas, quite effortlessly.
Glad it helped!
@@dataschool Yeah! beside books, I follow you, especially for Pandas. Great help. Thanx...
You're welcome!
You are an excellent teacher!!! I'm a fan. TY.
Very easy to follow, and thanks for making very useful video!
Thank you!
Thank you so much Kevin, your neat explanation along with the file you share makes it so clear, was really needing it!
I'm not able to read that file "u.item" , I copied the same code from GitHub but pandas wasn't able to read that. It showed me Unicode Error... How do I solve that issue..
insert this encoding='latin-1' and you will be fine
Finally a clear explaination of merge function !! Thanks, subscribed
Please keep making these videos! You are awesome!
Thank you!
Not wait too much to watch this.
I hope the video is helpful to you!
This video is pure GOLD, absolutely wonderful, loved the clear explanations , thank you...
So glad to hear it was helpful to you! 🙌
Very clear and informative. Thank you very much.
You're very welcome!
Excellently explained as always. Keep up the great work!!
Thank you!
Were is the link of the data set which has been used in this video.
I want to practice this with your data set can you please send me link?
Thanks a lot Kevin
We have missed you.
Thank you! 😊
Great video, informative and clear. Thanks
You're welcome!
You are doing a really great job with this. Thank you so much! :)
Thanks!
Thank you so much for the concise clear explanation. Much appreciated.
This video was very helpful and clear. Thank you for this content.
You're welcome!
Thank you very much for the precise explanation, just what I needed to know!
You're very welcome! 🙏
You are a great instructor. I have learned a lot from you regarding pandas.
The video with title "How do I merge DataFrames in pandas?" has left some queries in my mind. I would be thankful to you if you clear those too.
What type of join is used here movie_ratings = pd.merge(movies , ratings)?
if it is inner join it should result in 1682 rows in total in movie_ratings dataframe, as movies dataframe has 1682 rows. But in video i have observed that movie_ratings results in 100,000 rows of data.
hi, when I used pd.concat([df1,df2]), I got a tuple object instead of a dataframe object. I am using Python 3.9 environment. I would like to know what should I do to get a dataframe object rather than a tuple object?
Good to see you. I love the logic you teach.
Thank you! Glad my videos are helpful to you 👍
Love the way you explain it, thanks for your vids. Keep it up (thumbs)
Great to see you again as well as your high-quality content in your video
Thanks so much for your kind words! 😄
Missing your pandas tutorials.. thanks
It's nice to be missed! You can find all of my pandas tutorials here: ruclips.net/p/PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y
Thank you so much for the clear and concise explanation
You're welcome!
Awesome tutorial, Thank you very much man!
You're welcome!
Thank you for this video.
I have been struggling with merge and concat today :)
You're very welcome! Glad it's helpful to you!
thnx for the video, that's awesome, particular the parts on explaining joins. clear and concise
Great to hear!
This is very helpful. Thank you so much.
You're very welcome!
Wow, I've seen some of your videos and I just can say THANK YOU. It's so easy to understand you :3
Thanks for your kind words! Glad you like my videos!
Hi Kevin, thanks to your turtoring, I learn a lot from your channel, it's amazing! Since I just learn Pandas, I'm a little bit confused about concat(), melt(), merge(), pivot(), stack()...They're really annoying to me >< I really hope we have a one for all solution of how to use these functions XD Thank you!
I agree, it's tricky to separate out when you should use each one of those!
Excelent video! keep sharing content like this. Greetings from Argentina
Thanks!
Thanks man! You saved my weekend :*
Glad I could help!
Thank you so much for explaining it clearly. Now I understand on merging dataframe more. TQVM
You're welcome!
Superb!!!
I got Evey explanation, thanks
You're welcome!
thank u so much. very clear and to the point.
You're welcome!
Thank you!! I finally got the dataframe I wanted!
I wish we had 3x on youtube, great video!
I really enjoy your tutorials, thanks so much! I have 5 csv files that come out daily each containing a date column. i want to merge them all using the date as the merge field. i tried a basic merge with 2 of the csv files and date was used as the merge-on field by default - so it worked. ultimately i just need one date column in my masterfile with all the other column data merged. should I continue to do this or is it better to set the date column as the index, or something else?
Great work as allways.
Very useful.
Thanks for sharing it!
By the way, any chance you get some video done about PySpark? It will be very usefull to treat this from the biginning considering examples based on a local connection (one computer) first and then a couple of examples emulating a cluster connection.
Thanks for your kind words as always, Hector! Sorry, I don't have any videos about PySpark, but I appreciate the suggestion! 👍
@@dataschool I would love for you to do that. I am possitive that you will get a lot of interested guys, among them me of course.
My best regards!
Just what I needed.
Great to hear!
Great video. However I have a little issue. I have 3 data frames that I am trying to merge together. The first is a pretty long database with columns (cust_id, gained_on gained_from_supplier, lost_to_supplier, sales_channel_id) the second is the supplier data frame (supplier_name, supplier_id) what I am trying to do is merge the supplier id and name from the second data frame, to the database frame which has the ID so supplier id to the number using the lefton/right on but instead it returns both columns - the supplier ID and name of both dataframes. Then the same with the channel data frame (sales_channel_name, sales_channel_id) and merge this with the sales_channel_id in the database dataframe and show the name instead. Any help would be appreciated, thank you!
Единственный англоговорящий человек, которого можно понять не зная английский
Thank you! Crystal clear explanation.
Máster! Regresó! chévere.
😄
You're great teacher! I see the despite having a large 100K row file, the number of rows do not get expanded after the merge. They beautifully stay the same and just add the movie titles to the reviews. Can you comment on why this is not always the case. I have tried and my output file gets expanded by a few rows (17 out of 1000) and I have not been able to figure out why. I have checked multiple videos and some come absurd not practical solutions (like the files are the same size) or arbitrarily eliminate any dups (despite some may be valid rows), but none explain the reason and how to identify those rows that could be dups. Your comments are appreciated.
How to merge two dataframes based on 4 common columns with repatative elements?
This is the best explanation
Thanks so much!
You're very welcome!
Hi Kevin , First of all thanks for the wonderful lecturer , I am facing a problem to merge two data frames which i have shown you below ..
Data frame 1:
BackupServer BackupDay StartDate ClientName BackupStatus Backup re-run(Y/N) Incident Reason for the Backup Failures Backup Final Outcome
RGSIBAK004 01-05-2020 2020-04-30 06:40:29 RGBPLNM110 Completed NaN NaN NaN NaN
RGSIBAK004 01-05-2020 2020-04-30 06:53:07 RGPIAPP037 Completed NaN NaN NaN NaN
RGSIBAK004 01-05-2020 2020-04-30 15:32:38 RGPIISD001 Failed Yes IN893523 VM disconnected Failed
RGSIBAK004 01-05-2020 2020-04-30 18:00:08 RGPPFTP005 Completed NaN NaN NaN NaN
RGSIBAK004 01-05-2020 2020-04-30 18:00:02 RGPQWEB069 Completed NaN NaN NaN NaN
Data Frame 2 :
BackupServer BackupDay StartDate Client Name Backup Status Backup Rerun (Y/N) Incident Failures Backup Final Result
RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpqbda112.fdnet.com Activity completed successfully. NaN NaN NaN NaN
RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpppcc051.fdnet.com Activity completed successfully. NaN NaN NaN NaN
RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpppcc050.fdnet.com Activity completed successfully. NaN NaN NaN NaN
RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpppcc011.fdnet.com Activity completed successfully. NaN NaN NaN NaN
RGPIAUN003.FDNET.COM 2020-05-01 Thu Apr 30 21:00:03 EDT 2020 rgpdbda105.fdnet.com Activity completed successfully. NaN NaN NaN NaN
Although the two data frames have three column names "Backupserver" , "Backupday" and start date ...the content in the columns is different and i am not able to merge these two data frames into one ? Can you help me on this?
Dear Kiven, I have some difficulties in fine tuning PLSRegression sklearn.cross_decomposition.PLSRegression. Can you please touch this issue one day?
Thanks for your suggestion!
Does it happen while merging two data frames, only heads get to merge, No data get merged inside the new data frame?
How to merge multiple large dataframes in a fast way? I joined with usual merge() but it seems too slow. I found a clue of using pandas.Index() with the merge method, but i don't know how to use it.
above logic is beautifully explained, hi kevin, i have a question if you could please reply,
I have three csv files csv1(20000 rows), csv2(20000 rows),cvs3(20000 rows), i want to merge these files into single data frame without losing a single record? Like i want to read these files into a one data frame that should have 60000 rows ideally.
P.S: All the files have same columns (PostID, time, tweetURL, Content, RetweetNum , LikeNum, CommentsNum, Verified, Following, Follower). And in the resulting data frame i want to have all these columns at once as heading and want all 60000 rows. Is it possible ? kevin i will wait for your reply man, i know this post is old, maybe your read my question. THANK YOU
Thanks for the vid data school !
You're welcome!
Sir if we have hundreds of columns without the name. Then how can we name them using pandas and a for loop or lambda function because if we try to name them using names=[] it will be a very time-consuming process. The name of the columns can be col1, col2 , col3...etc.
Plesae i am trying to merge two datasets as you have explained but it is giving an error that i should check for duplicates
Thank you very much for that amazing and cleary explanation. By the way, is there a simple way to merge two dataframes with partial match string between the rows?
Love your videos!! excellent tutorial - by chance does Pandas have a facility to do a semi_join() like Dplyrs function?
Thanks for your kind words! I'm not familiar with semi_join, sorry...
great video. my question is when im working on project when exactly i have to combine ?
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 if(source['country1]==target['country2])return 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?
at timestamp 8:22 , how did you open the signature box that showed methods ?
What would we use to show ONLY all the values that do not match ? .... i.e. anything other that inner join
I have a data frame and I have a list and a tuple , I want to merge all three together . I am aware merge can only do two tables at a time, but do you have any helpful hints on how to go about merged the table , list and df. I want make to make the result a new data frame
slowly talk is very helpfull to me. I have 2 questions. The first is : What's if i want merge only one certain column (rating) from df rating to df movie . The second: What's if I want to sum the rate of each Movie_Id . Tks you so much and looking for your answer.
I am a beginner in python, I am not sure what join is the best to use in different scenarios. Can you help me through it??
I genuinely learnt a lot from your videos. I would really appreciate your help. Thank you in advance
hi bro, I am currently working in a project. The mentors says that use foreign keys and primary keys in pandas and create table with the keys. so my question is, the usage of foreign and primary keys in pandas is possible or if we can't what shall I do to merge the two tables contains the same column which we are doing in the MYSQL coding. Thank you.
the resulting dataset I got has a value of null. What do i do?
Lets say a pandas df and mysql have column A, B, C and same schema, Column A in SQL is the primary key.
now how to upsert a pandas df to mysql table?
When primary key conflicts, then update the remaining columns, when doesn't conflict/exists, then do an Insert Into..
Whats the most efficient way to do this?
Thanks for the amazing video. One simple question. How to join tables on multiple indices (like 4 or 5)?
thanks Kevin, but where is the concat video
Say I want to merge 2 dataframes with the same columns because someone else was working on an excel file. I want to keep everything in both dataframes, but I want, say, the column "category" from dataframe 2 to override the "category" column text in dataframe 1. Would that be left or right merge?
How to get the common mobile number from two different csv file having the different column name
How to verify if all the columns are incorporated in the merged DataFrame by using simple comparison Operator in Python after merging two DataFrame?
Very helpful, thank you.
You're welcome!
As usual nice tutorial. so thank you for making and sharing. Can you please elaborate about pandas assign function. Also when will you share the code because I want to practice :)
Here is the code for the merge video: nbviewer.jupyter.org/github/justmarkham/pandas-videos/blob/master/pandas_merge.ipynb As for the pandas assign function, this might help you to understand its usage: twitter.com/justmarkham/status/1173995596631478272
how about not a specific file? for example all .csv or all .tsv file? how to concatenate a header to that file? Thanks