Python Forum
Data Sorting and filtering(From an Excel File)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data Sorting and filtering(From an Excel File)
#1
Dear Friends

Assalamualiqum.....Brother....Hopping for your better health and safety....

I have an excel sheet prepared by my friend....He has done Sorting and Filtering using some formulae and functions.

The Input Table is sorted and filtered and data is arranged in output format....Please find the excel sheet in the attachment...

I am new to python...and want to do the same thing in python...i.e.

1.Saving excel input table as data frame in python.
2.Sorting and filtering as per output table in pyton.
3.exporting that output table back to excel sheet.

so please can anyone aid me in this regards...

Yours Sincerely

Attached Files

.xlsx   table sort filter and data extraction rev 1.xlsx (Size: 57.52 KB / Downloads: 1)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Filtering Data Frame, with another value NewBiee 9 1,509 Aug-21-2023, 10:53 AM
Last Post: NewBiee
  Sorting data by specific variables using argparse Bearinabox 5 1,473 Jan-01-2023, 07:44 PM
Last Post: Bearinabox
  Help with poorly formatted excel data armitron121 1 1,759 Jan-13-2022, 07:31 AM
Last Post: paul18fr
Question Sorting data with pandas TheZaind 4 2,399 Nov-22-2021, 07:33 PM
Last Post: aserian
  Exporting data frame to excel dyerlee91 0 1,659 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  [Pandas] Write data to Excel with dot decimals manonB 1 5,971 May-05-2021, 05:28 PM
Last Post: ibreeden
  Creating more than one excel File at once malvarez1976 0 1,847 Dec-15-2020, 02:04 AM
Last Post: malvarez1976
  Chunking and Sorting a large file Robotguy 1 3,631 Jul-29-2020, 12:48 AM
Last Post: Larz60+
  excel data erase d8a988 1 2,167 Apr-27-2020, 05:43 PM
Last Post: snippsat
  Python read Excel cell data validation anantpatil 0 4,206 Jan-31-2020, 04:57 PM
Last Post: anantpatil

Forum Jump:

User Panel Messages

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