Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import numpy as np
- import pandas as pd
- data = pd.read_csv('c.csv')
- print(data)
- data['A'] = data['A'].apply(lambda x: np.nan if x in range(1,10,1) else x)
- data['B'] = data['B'].apply(lambda x: np.nan if x in range(10,20,1) else x)
- data['C'] = data['C'].apply(lambda x: np.nan if x in range(20,30,1) else x)
- print(data)
- data = data.dropna()
- print(data)
- A B C
- 0 1 10 20
- 1 2 11 22
- 2 4 15 25
- 3 8 20 30
- 4 12 25 35
- 5 18 40 55
- 6 20 45 60
- A B C
- 0 NaN NaN NaN
- 1 NaN NaN NaN
- 2 NaN NaN NaN
- 3 NaN 20.0 30.0
- 4 12.0 25.0 35.0
- 5 18.0 40.0 55.0
- 6 20.0 45.0 60.0
- A B C
- 4 12.0 25.0 35.0
- 5 18.0 40.0 55.0
- 6 20.0 45.0 60.0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement