I have a df
:
building | building:use |
---|---|
industrial | None |
office | None |
police | None |
house | None |
church | residential |
... | ... |
How would I replace building
with building:use
if and only if the building:use
is residential?
A new df
would be appreciated.
I created df2
as you specified wanting a new df
.
df2 = df.copy()
df_res = df2[df2['building:use'] == 'residential']
df2.loc[df_res.index, 'building'] = df_res['building:use']
For reference, your example dataset
import pandas as pd
df = pd.DataFrame(
{
"building": ["industrial", "office", "police", "house", "church"],
"building:use": [None, None, None, None, "residential"],
}
)