Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "how python merges multiple files by column". The editor shows you the operation process through an actual case. The method of operation is simple and fast, and it is practical. I hope that this article "how to merge multiple files by column in python" can help you solve the problem.

The specific steps are as follows:

1. First, open python and create a new python project

After the 2.python project is created, import the pandas module in the project using the import method

Import pandas as pd

After the 3.pandas module is imported, use the pd.read method to open two csv files for testing

File = pd.read_csv (uplink. CSVX, encoding='gbk')

File2 = pd.read_csv ('pimk2.csv', encoding='gbk')

4. Finally, after the csv file is opened, you can use the pd.merge () method to merge the two files in columns.

File3 = pd.merge (file, file2, how='left', left_on=u'',right_on='WELL')

This is the end of the introduction to "how python merges multiple files by column". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.