'Updates excel file, Vlookup, DataFrame and Python

I'm a beginner in Python, openpyxl and pandas. Hopefully some expert can help me to figure out how to create a code to update track2.

    Track 1
ID   Values
A     JK2L
B     IIKL
C     OIP2
...

ID column may have thousand row in it.

for Track 2

Track 2
        ID   Values
        A     
        B     
        C
....

Track 1 is save in different excel file name same goes with the Track 2. Track 1 is keep on updating everyday, for track 2 to be aligned with Track 1. The Track 2 will get the data from the Track 1 to updates the file name of Track 2 using the Vlookup method.

It is possible to create a code from python to update the Track 2? What I have in mind is this code:

import pandas as pd

df1 = pd.read_excel('Track 1.xlsx', sheet_name = 'Delivery')
df2 = pd.read_excel('Track 2.xlsx', sheet_name ='Owner')
.....

Then I'm stock don't know how to write next code.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Updates excel file, Vlookup, DataFrame and Python

Sources

Related Questions