Python Merge data 、 Multi table join query - Tencent cloud developer community - Tencent cloud We can go through DataFrame or Series Type of concat Method , To connect , When the connection , Will align according to the index .
https://cloud.tencent.com/developer/article/1859924
1、concat()
We can go through DataFrame or Series Type of concat Method , To connect , When the connection , Will align according to the index .
- axis： Specify the connection axis , The default is 0( Up and down ).【axis=0/1】
- join： Specify connection mode , External connection by default .【join='outer'： Combine ,join='inner'： intersection 】
- keys： It can be used to distinguish different data groups . Form a hierarchical index 【 This is a little more difficult to understand 】
- join_axes： Specify the index reserved in the connection result set . Keep all by default 【 Such as ：join_axes=[df1.columns]】
- ignore_index： Ignore the index of the original connection , Create a new integer sequence index , The default is False.【ignore_index=True/False】
- sort：concat after , Whether to sort by column index ,sort=True/False
