Python Forum

Full Version: Excel Column as List
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi Everyone,

I am new to python. My requirement is to load a particular excel column as list and then count distinct values in that list.

Kindly suggest how this can be achieved.

Regards,
Aditya
http://lmgtfy.com/?q=python+excel

Very first result leads to a package for reading excel files, complete with clear docs on how to get started: https://openpyxl.readthedocs.io/en/default/usage.html
You can also try https://automatetheboringstuff.com/chapter12/. That should have most of the Excel info you'll need.