python q: i may be idiot but in my data ppl entered manual numbers to a q. some of the numbers are obviously dumb. Id like to delete all dumb numbers, so any number outside of a specified range, just wanna make NaNs. all google things i try do not work. column is float64.
Conversation
Show replies
Replying to
I was reading your tweets from 12/20. You were really open and honest about your earnings and linear progression on onlyfans. I respect that honesty. Very refreshing
1
Replying to
I didn’t know who you were. Read some old interviews. Amazing life transformation.
Replying to
Wherein she learns why 80% of data scientists' time is spent cleaning data.
35
Replying to
Assuming you're working with a pandas df, it sounds like this is what you want
2
Replying to
You'll probably need to indicate what data/query library you're using. It sounds like you're either working with something like pandas or some sort of database.
1
Replying to
Maybe this is a dumb inefficient method (I've only done first year python) but can't you use:
for i in range(len(data)):
if data[i]<min or data[i]>max:
data[i]=float("nan")
1
1
This Tweet was deleted by the Tweet author. Learn more
gives me "The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()."
1
2
Show replies