File size: 701 Bytes
bb3e08f fbf7879 bb3e08f |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
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
|