text_plain_output_1.png
import pandas as pd

data = pd.read_csv('/kaggle/input/bank-personal-loan/Bank_Personal_Loan.csv')
df = pd.DataFrame(data)
df

df.isnull().sum()

DF_NONE = df.loc[(df['ZIP Code'] == 92634) | (df['ZIP Code'] == 92717) | (df['ZIP Code'] == 96651) | (df['ZIP Code'] == 9307)]
DF_NONE.reset_index(drop=True, inplace=True)
DF_NONE

DF_NONE1 = df.loc[df['ZIP Code'] == 92717]
DF_NONE1['county'].fillna(value='irvine', inplace=True)
DF_NONE1['lat'].fillna(value=33.6462, inplace=True)
DF_NONE1['long'].fillna(value=-117.839, inplace=True)
DF_NONE1