The difference between concat, merge and join

Описание: This video discusses what is the difference between concat(), merge(), and join(). Which setting is suitable to which kind of function. Data block means columns in this lecture.


Let’s summarize our findings.
We have used concat() when we were trying to add multiple data blocks with the same structure and put them in one data frame one below the other.
In order to add column data to existing entries, we have used merge(). The data was added based on the same values for columns on which were merging data frames.
Join() was a special case of merge() when at least one of the entries we are joining on was the index.

The script of this discussion is placed at:
https://github.com/faisalnawazmir/Pyt...

The next lecture will discuss the advanced use of these two functions and a separated lecture will discuss the types of joins,
inner, outer, left, and right join.