+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: hello everyone. (/thread-30130.html)
hello everyone. - BCola683 - Oct-06-2020
Hello. I am new to python and relatively new to coding. I have experience in school only so far with C#, SQL, ASP.NET and a little JAVA.
my boss, I work help desk for CTG, wants a simple python program with the following. I'm curious if someone could point me in the right direction.
A program that he can feed an 1.xls to with agent names and other data and 2.xls with agent names and TL names. Need to be able to append 1.xls with proper TL's from 2.xls
RE: hello everyone. - jefsummers - Oct-06-2020
I would recommend using Pandas. Example code:
import pandas as pd
df1 = pd.read_excel('1.xls')
df2 = pd.read_excel('2.xls')Then write the code to combine the dataframes