Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
hello everyone.
#1
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
Reply
#2
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
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020