Removing rows at random based on the value of a specific column

Thread Rating:

Thread Modes

Removing rows at random based on the value of a specific column

Mr_Keystrokes
Programmer named Tim

Posts: 18

Threads: 6

Joined: Sep 2017

Reputation: 0

Aug-24-2018, 11:15 AM

Got it, my mistake was not assigning it to a variable as so:

df=df.drop(df.query('salary == 0').sample(frac=.41).index)

Messages In This Thread

RE: Removing rows at random based on the value of a specific column - by Mr_Keystrokes - Aug-24-2018, 11:15 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Merging rows and adding columns based on matching index	pythonnewbie78	3	822	Dec-24-2023, 11:51 AM Last Post: Pedroski55
	Make unique id in vectorized way based on text data column with similarity scoring	ill8	0	893	Dec-12-2022, 03:22 AM Last Post: ill8
	Pandas Dataframe Filtering based on rows	mvdlm	0	1,441	Apr-02-2022, 06:39 PM Last Post: mvdlm
	New Dataframe Column Based on Several Conditions	nb1214	1	1,806	Nov-16-2021, 10:52 PM Last Post: jefsummers
	Pandas Data frame column condition check based on length of the value	aditi06	1	2,697	Jul-28-2021, 11:08 AM Last Post: jefsummers
	Setting the x-axis to a specific column in a dataframe	devansing	0	2,040	May-23-2021, 12:11 AM Last Post: devansing
	[Solved] How to refer to dataframe column name based on a list	lorensa74	1	2,269	May-17-2021, 07:02 AM Last Post: lorensa74
	Add column based on others	timste	8	4,046	Apr-03-2021, 07:39 AM Last Post: devesh_sahu
	Extracting rows based on condition on one column	Robotguy	2	2,221	Aug-07-2020, 02:27 AM Last Post: Robotguy
	Dropping Rows From A Data Frame Based On A Variable	JoeDainton123	1	2,227	Aug-03-2020, 02:05 AM Last Post: scidam

Users browsing this thread: 2 Guest(s)