Mapping 되지 않는 법정동코드

#-*-coding:utf-8 -*-
from urllib.request import urlopen
from typing import final
from venv import create
import pandas as pd
import chunk
import warnings
from multiprocessing import Process
import bisect
import pandas as pd
from typing import final
from venv import create
import requests
from decimal import Decimal
import json
import shutil

map1 = pd.read_excel("C:/Users/TSM/OneDrive/바탕 화면/map.xlsx", names=['행정동코드','시도명','시군구명','읍면동명','법정동코드','동리명','생성일자','말소일자'])
map1 = map1.astype({'행정동코드':'str','시도명':'str','시군구명':'str','읍면동명':'str','법정동코드':'str','동리명':'str','생성일자':'str','말소일자':'str'})
map1 = map1[['행정동코드','시도명','시군구명','읍면동명','법정동코드','동리명']]

cnt = 0
bjd = map1['법정동코드']
ips = bjd.duplicated(keep=False)
df = pd.DataFrame(columns=['법정동코드','동리명','행정동코드','시도명','시군구명','읍면동명'])
for idx, row in map1.iterrows():
    if ips.loc[idx] == True:
        new_data = {"법정동코드":[row["법정동코드"]],"동리명":[row["동리명"]],"행정동코드":[row["행정동코드"]],"시도명":[row["시도명"]],"시군구명":[row["시군구명"]],"읍면동명":[row["읍면동명"]]}
        new_df = pd.DataFrame(new_data)
        df = pd.concat([df, new_df])
        cnt += 1
        print(cnt)

df.to_csv("C:/Users/TSM/OneDrive/바탕 화면/ips.csv", mode='a', index=False, encoding='cp949',header=False)
print(df)


# map2 = pd.read_csv("C:/Users/TSM/OneDrive/바탕 화면/nodup.csv",names=['지번주소','행정동코드','법정동코드'],dtype={'지번주소':'str','행정동코드':'str','법정동코드':'str'},encoding='cp949',low_memory=False) 
# df = map2['지번주소']
# dup = map2.duplicated()
# for idx, row in map2.iterrows():
#     if dup.loc[idx] == True:
#         print(row)

# dup = map2.duplicated(subset=['지번주소'], keep=False)
# for idx, row in map2.iterrows():
#     if dup.loc[idx] == False:
#         print(row)
    

# data = {"지번주소":["지번주소"], "행정동코드":["행정동코드"],"법정동코드":["법정동코드"]}
# df = pd.DataFrame(data)
# ppp = 0
# for idx, row in map2.iterrows():
#     if map2.at[idx, "행정동코드"] == xxx:
#         new_data = {"지번주소":[row["지번주소"]], "행정동코드":[row["행정동코드"]], "법정동코드":[row["법정동코드"]]}
#         new_df = pd.DataFrame(new_data)
#         df = pd.concat([df, new_df])
#     else:
#         continue

# df.to_csv("C:/Users/TSM/OneDrive/바탕 화면/false.csv", mode='a', index=False, encoding='cp949',header=False)
# print(df)

위의 코드로 추출