Python Forum
Grouping Data based on 30% bracket
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Grouping Data based on 30% bracket
#1
Hello All,

I am sharing use case which I am not sure falls under this forum or not , so need guidance for that. I only have basic knowledge of python.

I have scenario where we have some Vendor data along with its revenue .

Case 1-When all vendors revenue lies in 30% bracket of each other
Name Revenue
Vendor 1 100
Vendor 2 130
Vendor 4 139

Output > (V1,v2,v4)

Case 2-When all vendors revenue lies in 30% bracket of each other
Name Revenue
Vendor 1 100
Vendor 2 130
Vendor 3 5000
Vendor 4 6000
Output > 2 groups (V1,v2) , (v3,v4)

Is there any python existing library which I can use to implement this or I need to write logic where I will compare each vendor's revenue with each other and output like this.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Grouping in pandas/multi-index data frame Aleqsie 3 698 Jan-06-2024, 03:55 PM
Last Post: deanhystad
  Supervised learning, tree based model - problems splitting data Pixel 0 675 May-16-2023, 05:25 PM
Last Post: Pixel
  Make unique id in vectorized way based on text data column with similarity scoring ill8 0 898 Dec-12-2022, 03:22 AM
Last Post: ill8
  Pandas Data frame column condition check based on length of the value aditi06 1 2,707 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,238 Aug-03-2020, 02:05 AM
Last Post: scidam
  sns point plot grouping Mekala 0 1,518 Jul-24-2020, 04:06 PM
Last Post: Mekala
  Filter data based on a value from another dataframe column and create a file using lo pawanmtm 1 4,300 Jul-15-2020, 06:20 PM
Last Post: pawanmtm
  Counting and grouping Kudzo 0 1,356 Jan-27-2020, 01:30 AM
Last Post: Kudzo
  Sample based on the distribution of a feature to create more balanced data set dervast 1 1,798 Nov-15-2019, 12:25 AM
Last Post: schuler
  select data based on indice Staph 4 2,558 Jul-15-2019, 02:05 AM
Last Post: scidam

Forum Jump:

User Panel Messages

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