consolidator

1
import glob
2
import ntpath
3
import pandas as pd
4
from MyConfig import MyConfig
5

6
if __name__=="__main__":
7
    try:
8
        settings = MyConfig("consolidation.json")
9
        handlers:list = settings.get("handlers",[])
10
        shop = "prokat_z930"
11
        input_file = "D:\\work\\Укрупнение\\current\\debug_data\\[прокат][Z930].xlsx"
12
        out_pattern ="D:\\work\\Укрупнение\\current\\debug_data2\\"
13
        mapping=pd.read_excel("D:\\work\\Укрупнение\\current\\справочники4\\Маппинг производств.xlsx")
14
        df = pd.read_excel(input_file)
15
        df = df.merge(mapping,left_on="Производство",right_on="Производство",how="left")
16
        
17
        for item in handlers:
18
            dfh:pd.DataFrame = df[df["Производство2"]==item["key"]]
19
            if not dfh.empty:
20
                dfh.drop("Производство2",axis=1,inplace=True)
21
                dfh.to_excel(f"{out_pattern}{shop}_{item['module']}.xlsx",index=False)
22
                print(f"{item['key']} : {item['module']} : done")
23

24

25
    except Exception as exp:
26
        print(f"error: {exp}")