Skip to content

Instantly share code, notes, and snippets.

View kdrkdrkdr's full-sized avatar
🚩
Elnino

Sleeping KDR kdrkdrkdr

🚩
Elnino
View GitHub Profile
@kdrkdrkdr
kdrkdrkdr / codeparse.py
Created September 1, 2025 08:24
환경 체커톤 대회 엑셀 파싱
import pandas as pd
import warnings
warnings.filterwarnings('ignore')
df = pd.ExcelFile("UTF82024 국민환경의식 설문조사_원자료.xlsx", engine='openpyxl')
src = df.parse('원자료')
cb = df.parse('코드북')
# 임농업 데이터만
data = src[src['F2'] == 1]