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