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,416 Aug-21-2023, 10:53 AM
Last Post: NewBiee
  Sorting data by specific variables using argparse Bearinabox 5 1,431 Jan-01-2023, 07:44 PM
Last Post: Bearinabox
  Help with poorly formatted excel data armitron121 1 1,733 Jan-13-2022, 07:31 AM
Last Post: paul18fr
Question Sorting data with pandas TheZaind 4 2,363 Nov-22-2021, 07:33 PM
Last Post: aserian
  Exporting data frame to excel dyerlee91 0 1,637 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  [Pandas] Write data to Excel with dot decimals manonB 1 5,915 May-05-2021, 05:28 PM
Last Post: ibreeden
  Creating more than one excel File at once malvarez1976 0 1,824 Dec-15-2020, 02:04 AM
Last Post: malvarez1976
  Chunking and Sorting a large file Robotguy 1 3,599 Jul-29-2020, 12:48 AM
Last Post: Larz60+
  excel data erase d8a988 1 2,150 Apr-27-2020, 05:43 PM
Last Post: snippsat
  Python read Excel cell data validation anantpatil 0 4,178 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