Excel file zhang sheet import more, want to have more than one sheet merged into one, and only keep are repeated in each sheet data, how to do?

CodePudding user response:

Use updata can connect data, then use duplicated duplicated data
Dupe dupe=data. Duplicated [' column ']
[dupe dupe dupe dupe dupe dupe of===True)
Data. The iloc [dupe dupe. Index] is to stay, then connect to the next table, lookup

CodePudding user response:

https://blog.csdn.net/weixin_43064185/article/details/90232426

According to the connection data

CodePudding user response:

https://www.cnblogs.com/super999/p/11757158.html

I have a dataframe connection is to use the append this way

CodePudding user response:

Append an example, such as two DF:
A B C A B C
0 1 1 1 2 2 2
1 2 3 4 1 1 1
2 2 2 2 5 6 7

The above two tables after the merger, in order to get the DF:
A B C
0 1 1 1
1 2 2 2

Is the two tables are some data retention, no data to delete, how to implement?