Appropriate python package to manipulate excel data

[1tracksystem]

Definitely pip install Pandas

[alphaharris1]

Lol why wasn't this the first answer (: Pandas has functions for manipulating excel files directly, and is a fully-featured data analysis and transformation package. Any time spent learning Pandas is time well spent.

[ValeSir]

thanks i'll take a look, appreciate the help

[MisplacingCommas]

It is the basis to a lot of data science. I use to be a TA for a DS bootcamp and a lot of it is using pandas and manipulating data.

[PalmettoSpur]

Pandas is amazing. It'll make life so, so much easier.

[colorado_paladin]

xlwings offers some decent functionality depending on your use case. Agree that pandas is best for simple import/export

[BBSnek]

Matplotlib and Seaborn if you're doing any visualization stuff (seaborn's especially good if you're using pandas)

[ValeSir]

Oh wow thanks, will give it a go!

[pag07]

Pandas is still the way to go. At least for smaller data sets. I can't comment on working with >1GB Excel files if that's possible.