| import pandas as pd | |
| def process_small_bts_data(file_path: str): | |
| dfs = pd.read_excel( | |
| file_path, | |
| sheet_name=["BTS"], | |
| engine="calamine", | |
| skiprows=[0], | |
| ) | |
| df_bts = dfs["BTS"] | |
| df_bts.columns = df_bts.columns.str.replace(r"[ ]", "", regex=True) | |
| df_bts["code"] = df_bts["name"].str.split("_").str[0] | |
| df_bts["code"] = ( | |
| pd.to_numeric(df_bts["code"], errors="coerce").fillna(0).astype(int) | |
| ) | |
| df_bts["ID_BTS"] = df_bts[["BSC", "BCF", "BTS"]].astype(str).apply("_".join, axis=1) | |
| df_bts["ID_MAL"] = df_bts[["BSC", "BTS"]].astype(str).apply("_".join, axis=1) | |
| df_bts = df_bts[["ID_BTS", "ID_MAL", "code", "name"]] | |
| return df_bts | |