Python

Search

map two csv files python

import pandas as pd
  
# reading two csv files
data1 = pd.read_csv('datasets/loan.csv')
data2 = pd.read_csv('datasets/borrower.csv')
  
# using merge function by setting how='inner'
output1 = pd.merge(data1, data2, 
                   on='LOAN_NO', 
                   how='inner')
  
# displaying result
print(output1)

Comment

PREVIOUS	NEXT

Code Example
Python :: selenium do not open browser window
Python :: matplotlib plot in second axis
Python :: pack tkinter
Python :: empty list in python
Python :: noise reduction filter images python
Python :: python datetime minus datetime
Python :: how to print in double quotes in python
Python :: find greatest number in list python
Python :: merge two netcdf files using xarray
Python :: how to use modulo in python
Python :: how to slice dataframe by timestamp
Python :: similarity imdex in python
Python :: how to remove element from nested list in python
Python :: cv2 cuda support print
Python :: python list files in directory
Python :: np.exp in python numpy
Python :: seaborn library in python
Python :: draw bounding box matplotlib
Python :: how to make a username system using python
Python :: python get name of vlue
Python :: download unsplash images python without api
Python :: python check if object is empty
Python :: python sliding window
Python :: how to make a comment in python
Python :: if statement in python
Python :: load data python
Python :: python programm zu exe
Python :: chi square test contingency table python
Python :: how to move the last column to the first column in pandas
Python :: add icon to exe file

Search

PYTHON

map two csv files python

ADD CONTENT