Interesting article how to use Pandas with Excel sheets

  • #1
scottdave
Science Advisor
Homework Helper
Insights Author
1,783
746

Main Question or Discussion Point

I came across this article about using Pandas in Python to read in a multi-tab spreadsheet to Python, and work with the data then write back to an Excel spreadsheet:
https://towardsdatascience.com/seve...w-i-use-python-where-excel-fails-62061f86ef9c
I have not yet tried it, but it looks pretty cool. The link was posted on a Slack channel for an online course I'm taking through edX/Georgia Tech. (Introduction to Computing for Data Analysis). It is part of their MicroMasters program in Analytics.
 
  • Like
Likes Asymptotic and QuantumQuest

Answers and Replies

  • #2
11,887
5,541
Yes, that's pretty cool. The steps are somewhat involved and you'd have to check to make sure something didn't get lost.

Also is there some limit as to how many rows can get pivoted in this way? I'm guessing the max cols of the spreadsheet program which is 16,384:

https://support.office.com/en-us/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3

Normally for the data we work with, we'd use MATLAB functions to transpose the matrix of data but I'm not sure how that would work in this case with mixed datatypes of strings and numbers.

I also wonder if you could pivot across sheets (ala 3D matrix of data) as it seems that its possible.
 
  • Like
Likes scottdave and QuantumQuest

Related Threads on Interesting article how to use Pandas with Excel sheets

Replies
9
Views
906
Replies
2
Views
3K
Replies
2
Views
2K
Replies
7
Views
1K
Replies
8
Views
43K
Replies
4
Views
848
  • Last Post
Replies
2
Views
746
Replies
20
Views
1K
Top