how to make changes to a existing column based on multiple conditions in python csv
91
April 02, 2022, at 1:30 PM
So I am working on data processing and I want to make changes to a column called "temp_coil" based on the condition in other columns.
This is the one I made and it is giving me error.
df.temp_coil[df.outdoor_temperature < 20 & df.cooling_state == 1 & df.temp_coil == 0] = 4500
I want the answer to be 4500 if outdoor_temperature column is less than 20, cooling_state column is 1 and temp_coil column itself is 0. All the conditions need to be met.
The error it is giving me is type and value error when I run it. If this is already answered please let me know, I couldn't find an example that matched my problem.
Answer 1
You must use parentheses so that the truth table is unambiguous. For your example, the correct code would be:
df.temp_coil[(df.outdoor_temperature < 20) & (df.cooling_state == 1) & (df.temp_coil == 0)] = 4500
Or:
df.temp_coil[df.outdoor_temperature.lt(20) & df.cooling_state.eq(1) & df.temp_coil.eq(0)] = 4500
-
12:40
-
05:30
-
05:10
-
9:40
-
4:50
-
11:30
How to prevent a token created with OAuth 2.0 from expiring?
-
08:00
-
05:10
-
6:30
POPULAR ONLINE
- search for elements in a list 110477 visits
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 105056 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98144 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 95619 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 91863 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 61304 visits
- Adding methods to es6 child class 22012 visits
