Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Column as List
#1
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
Reply
#2
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
Reply
#3
You can also try https://automatetheboringstuff.com/chapter12/. That should have most of the Excel info you'll need.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Search Excel File with a list of values huzzug 4 1,147 Nov-03-2023, 05:35 PM
Last Post: huzzug
  trouble reading string/module from excel as a list popular_dog 0 384 Oct-04-2023, 01:07 PM
Last Post: popular_dog
  list from excel devilonline 4 1,337 Jun-22-2022, 11:00 PM
Last Post: devilonline
  How to format Excel column with comma? dee 0 1,337 Jun-13-2022, 10:11 PM
Last Post: dee
  Appending Excel column value as CSV file name sh1704 0 1,268 Feb-06-2022, 10:32 PM
Last Post: sh1704
  Not able to add extra column to the list in the python shantanu97 2 1,611 Nov-17-2021, 10:14 AM
Last Post: snippsat
  Compare two Excel sheets with Python and list diffenrences dmkfon 1 14,488 Oct-09-2021, 03:30 PM
Last Post: Larz60+
  Want to remove the text from a particular column in excel shantanu97 2 2,092 Jul-05-2021, 05:42 PM
Last Post: eddywinch82
  Copy column from one existing excel file to another file mkujawsk 0 5,486 Apr-14-2021, 06:33 PM
Last Post: mkujawsk
  Sort List of Lists by Column Nju 1 10,059 Apr-13-2021, 11:59 PM
Last Post: bowlofred

Forum Jump:

User Panel Messages

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