File size: 607 Bytes
bb3e08f |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
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].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
|