INFO:root:(10298, 11) INFO:root: Marke Standort Konto_Nr Kostenstelle Absatzkanal Kostenträger Kostenträger_Ebene Konto_Nr_Händler Konto_Nr_SKR51 Marke_HBV Standort_HBV duplicated 1991 01 01 5003 41 99 70 OP-01-5003-41-99-70 01-01-5003-41-99-70 1844 R10654 True 1999 04 01 5008 40 99 70 KI-01-5008-40-99-70 04-01-5008-40-99-70 8253 2119 True 2004 01 01 5008 41 99 70 OP-01-5008-41-99-70 01-01-5008-41-99-70 1844 R10654 True 2047 01 01 5701 42 99 70 OP-01-5701-42-99-70 01-01-5701-42-99-70 1844 R10654 True 2223 01 01 5002 41 99 70 OP-01-5002-41-99-70 01-01-5002-41-99-70 1844 R10654 True 2386 01 01 5005 41 99 70 OP-01-5005-41-99-70 01-01-5005-41-99-70 1844 R10654 True 2400 04 01 5701 41 99 70 KI-01-5701-41-99-70 04-01-5701-41-99-70 8253 2119 True 2402 04 01 5701 42 99 70 KI-01-5701-42-99-70 04-01-5701-42-99-70 8253 2119 True 2405 01 01 5701 41 99 70 OP-01-5701-41-99-70 01-01-5701-41-99-70 1844 R10654 True 2418 01 01 5801 41 99 70 OP-01-5801-41-99-70 01-01-5801-41-99-70 1844 R10654 True 3756 04 01 8410 41 10 70 KI-01-8410-41-10-70 04-01-8410-41-10-70 8253 2119 True 3758 04 01 8410 41 10 70 KI-01-8410-41-15-70 04-01-8410-41-10-70 8253 2119 True 3762 01 01 8410 41 50 70 OP-01-8410-41-50-70 01-01-8410-41-50-70 1844 R10654 True 3766 01 01 8410 44 10 70 OP-01-8410-44-10-70 01-01-8410-44-10-70 1844 R10654 True 3771 01 01 8411 41 10 70 OP-01-8411-41-10-70 01-01-8411-41-10-70 1844 R10654 True 4109 04 01 8400 41 10 70 KI-01-8400-41-10-70 04-01-8400-41-10-70 8253 2119 True 4114 04 01 8401 41 10 70 KI-01-8401-41-10-70 04-01-8401-41-10-70 8253 2119 True 4317 04 01 5002 41 99 70 KI-01-5002-41-99-70 04-01-5002-41-99-70 8253 2119 True 4326 04 01 5003 41 99 70 KI-01-5003-41-99-70 04-01-5003-41-99-70 8253 2119 True 4331 04 01 5005 41 99 70 KI-01-5005-41-99-70 04-01-5005-41-99-70 8253 2119 True 4338 04 01 5008 41 99 70 KI-01-5008-41-99-70 04-01-5008-41-99-70 8253 2119 True 4339 01 01 5008 40 99 70 OP-01-5008-40-99-70 01-01-5008-40-99-70 1844 R10654 True 4364 99 01 5701 42 99 70 ZZ-01-5701-42-99-70 99-01-5701-42-99-70 0000 01_ZZ True 4366 04 01 5801 41 99 70 KI-01-5801-41-99-70 04-01-5801-41-99-70 8253 2119 True 4637 01 01 7420 42 00 72 OP-01-7420-42-00-72 01-01-7420-42-00-72 1844 R10654 True 4772 01 01 8420 42 10 70 OP-01-8420-42-10-70 01-01-8420-42-10-70 1844 R10654 True 5041 01 01 8400 41 10 70 OP-01-8400-41-10-70 01-01-8400-41-10-70 1844 R10654 True 5043 01 01 8401 41 10 70 OP-01-8401-41-10-70 01-01-8401-41-10-70 1844 R10654 True 5044 04 01 8410 41 50 70 KI-01-8410-41-50-70 04-01-8410-41-50-70 8253 2119 True 5046 04 01 8410 44 10 70 KI-01-8410-44-10-70 04-01-8410-44-10-70 8253 2119 True 5047 04 01 8410 44 10 70 KI-01-8410-44-15-70 04-01-8410-44-10-70 8253 2119 True 5049 01 01 8410 41 10 70 OP-01-8410-41-10-70 01-01-8410-41-10-70 1844 R10654 True 5053 01 01 8410 41 91 70 OP-01-8410-41-60-70 01-01-8410-41-91-70 1844 R10654 True 5058 99 01 8410 41 10 70 ZZ-01-8410-41-10-70 99-01-8410-41-10-70 0000 01_ZZ True 5062 04 01 8411 41 10 70 KI-01-8411-41-10-70 04-01-8411-41-10-70 8253 2119 True 5108 04 01 8420 42 10 70 KI-01-8420-42-10-70 04-01-8420-42-10-70 8253 2119 True 7140 01 01 5003_STK 41 99 70 OP-01-5003_STK-41-99-70 01-01-5003_STK-41-99-70 1844 R10654 True 7148 04 01 5008_STK 40 99 70 KI-01-5008_STK-40-99-70 04-01-5008_STK-40-99-70 8253 2119 True 7153 01 01 5008_STK 41 99 70 OP-01-5008_STK-41-99-70 01-01-5008_STK-41-99-70 1844 R10654 True 7196 01 01 9143 42 99 70 OP-01-5701_STK-42-99-70 01-01-9143-42-99-70 1844 R10654 True 7372 01 01 5002_STK 41 99 70 OP-01-5002_STK-41-99-70 01-01-5002_STK-41-99-70 1844 R10654 True 7535 01 01 5005_STK 41 99 70 OP-01-5005_STK-41-99-70 01-01-5005_STK-41-99-70 1844 R10654 True 7549 04 01 9143 41 99 70 KI-01-5701_STK-41-99-70 04-01-9143-41-99-70 8253 2119 True 7551 04 01 9143 42 99 70 KI-01-5701_STK-42-99-70 04-01-9143-42-99-70 8253 2119 True 7554 01 01 9143 41 99 70 OP-01-5701_STK-41-99-70 01-01-9143-41-99-70 1844 R10654 True 7567 01 01 5801_STK 41 99 70 OP-01-5801_STK-41-99-70 01-01-5801_STK-41-99-70 1844 R10654 True 8905 04 01 9144 41 10 70 KI-01-8410_STK-41-10-70 04-01-9144-41-10-70 8253 2119 True 8907 04 01 9144 41 10 70 KI-01-8410_STK-41-15-70 04-01-9144-41-10-70 8253 2119 True 8911 01 01 9144 41 50 70 OP-01-8410_STK-41-50-70 01-01-9144-41-50-70 1844 R10654 True 8915 01 01 9144 44 10 70 OP-01-8410_STK-44-10-70 01-01-9144-44-10-70 1844 R10654 True 8920 01 01 8411_STK 41 10 70 OP-01-8411_STK-41-10-70 01-01-8411_STK-41-10-70 1844 R10654 True 9258 04 01 8400_STK 41 10 70 KI-01-8400_STK-41-10-70 04-01-8400_STK-41-10-70 8253 2119 True 9263 04 01 8401_STK 41 10 70 KI-01-8401_STK-41-10-70 04-01-8401_STK-41-10-70 8253 2119 True 9466 04 01 5002_STK 41 99 70 KI-01-5002_STK-41-99-70 04-01-5002_STK-41-99-70 8253 2119 True 9475 04 01 5003_STK 41 99 70 KI-01-5003_STK-41-99-70 04-01-5003_STK-41-99-70 8253 2119 True 9480 04 01 5005_STK 41 99 70 KI-01-5005_STK-41-99-70 04-01-5005_STK-41-99-70 8253 2119 True 9487 04 01 5008_STK 41 99 70 KI-01-5008_STK-41-99-70 04-01-5008_STK-41-99-70 8253 2119 True 9488 01 01 5008_STK 40 99 70 OP-01-5008_STK-40-99-70 01-01-5008_STK-40-99-70 1844 R10654 True 9513 99 01 9143 42 99 70 ZZ-01-5701_STK-42-99-70 99-01-9143-42-99-70 0000 01_ZZ True 9515 04 01 5801_STK 41 99 70 KI-01-5801_STK-41-99-70 04-01-5801_STK-41-99-70 8253 2119 True 9786 01 01 7420_STK 42 00 72 OP-01-7420_STK-42-00-72 01-01-7420_STK-42-00-72 1844 R10654 True 9921 01 01 8420_STK 42 10 70 OP-01-8420_STK-42-10-70 01-01-8420_STK-42-10-70 1844 R10654 True 10190 01 01 8400_STK 41 10 70 OP-01-8400_STK-41-10-70 01-01-8400_STK-41-10-70 1844 R10654 True 10192 01 01 8401_STK 41 10 70 OP-01-8401_STK-41-10-70 01-01-8401_STK-41-10-70 1844 R10654 True 10193 04 01 9144 41 50 70 KI-01-8410_STK-41-50-70 04-01-9144-41-50-70 8253 2119 True 10195 04 01 9144 44 10 70 KI-01-8410_STK-44-10-70 04-01-9144-44-10-70 8253 2119 True 10196 04 01 9144 44 10 70 KI-01-8410_STK-44-15-70 04-01-9144-44-10-70 8253 2119 True 10198 01 01 9144 41 10 70 OP-01-8410_STK-41-10-70 01-01-9144-41-10-70 1844 R10654 True 10202 01 01 9144 41 91 70 OP-01-8410_STK-41-60-70 01-01-9144-41-91-70 1844 R10654 True 10207 99 01 9144 41 10 70 ZZ-01-8410_STK-41-10-70 99-01-9144-41-10-70 0000 01_ZZ True 10211 04 01 8411_STK 41 10 70 KI-01-8411_STK-41-10-70 04-01-8411_STK-41-10-70 8253 2119 True 10257 04 01 8420_STK 42 10 70 KI-01-8420_STK-42-10-70 04-01-8420_STK-42-10-70 8253 2119 True INFO:root:Gewinn/Verlustvortrag INFO:root: amount Marke Standort 00 01 3048860.28 01 01 2471114.00 04 01 47453786.87 99 01 -50747122.93 INFO:root:amount 2226638.22 dtype: float64 INFO:root:df_bookings: (1565, 8) INFO:root:df_combined: (1565, 18) INFO:root:df_pivot: (1517, 2) INFO:root:(1517, 9) INFO:root:Index(['Period01', 'CumulatedYear', 'Konto_Nr_SKR51', 'Marke', 'Standort', 'Konto_Nr', 'Kostenstelle', 'Absatzkanal', 'Kostenträger'], dtype='object', name='period') INFO:root:period Period01 CumulatedYear Konto_Nr_SKR51 Marke Standort Konto_Nr Kostenstelle Absatzkanal Kostenträger Konto_Nr_SKR51 00-01-1408-00-00-00 125098.82 125098.82 00-01-1408-00-00-00 00 01 1408 00 00 00 01-01-0320-26-00-06 -50.00 -50.00 01-01-0320-26-00-06 01 01 0320 26 00 06 01-01-0320-26-00-20 -80.00 -80.00 01-01-0320-26-00-20 01 01 0320 26 00 20 01-01-0320-26-00-22 -165.00 -165.00 01-01-0320-26-00-22 01 01 0320 26 00 22 01-01-0320-26-00-49 -160.00 -160.00 01-01-0320-26-00-49 01 01 0320 26 00 49 INFO:root:df: (1517, 9) INFO:root:period Period01 CumulatedYear Kontoart 1 168623.11 168623.11 2 -167424.40 -167424.40 3 1198.71 1198.71 INFO:root:period Period01 CumulatedYear Kontoart Konto_1 1 0 -74873.49 -74873.49 1 441639.72 441639.72 3 -198143.12 -198143.12 2 2 2446.57 2446.57 4 362463.57 362463.57 5 0.08 0.08 7 2903651.93 2903651.93 8 -3437185.26 -3437185.26 3 0 -3.00 -3.00 3 -24.00 -24.00 8 8.00 8.00 9 1217.71 1217.71 INFO:root:period Period01 CumulatedYear Konto_Nr 0210 4452.90 4452.90 0300 2028.13 2028.13 0320 -1125.00 -1125.00 0322 -59839.97 -59839.97 0322_STK -3.00 -3.00 0480 1895.18 1895.18 0640 5453.85 5453.85 0965 -13286.98 -13286.98 0970 -2100.00 -2100.00 0977 -1800.00 -1800.00 0980 9842.12 9842.12 0990 -7093.72 -7093.72 0992 -13300.00 -13300.00 1000 -634.32 -634.32 1010 -4292.21 -4292.21 1200 283524.10 283524.10 1210 1602.60 1602.60 1220 1599977.92 1599977.92 1250 507320.87 507320.87 1362 -1280.69 -1280.69 1363 39.00 39.00 1400 -321898.67 -321898.67 1401 -59936.60 -59936.60 1407 -3239.38 -3239.38 1408 -383155.96 -383155.96 1571 49.89 49.89 1572 1613.63 1613.63 1576 401980.37 401980.37 1590 -188954.31 -188954.31 1591 491.80 491.80 1592 -6665.00 -6665.00 1600 -637229.50 -637229.50 1601 4000.88 4000.88 1718 -163034.78 -163034.78 1740 579.12 579.12 1741 48289.45 48289.45 1742 8143.02 8143.02 1748 0.00 0.00 1776 -619267.22 -619267.22 1779 -1613.63 -1613.63 1789 -19971.97 -19971.97 1792 -4750.00 -4750.00 1795 -48.69 -48.69 2110 1499.72 1499.72 2111 747.50 747.50 2176 200.00 200.00 2300 -0.66 -0.66 2650 0.01 0.01 3000 -803.34 -803.34 3000_STK -11.00 -11.00 3010 -235951.39 -235951.39 3010_STK -8.00 -8.00 3100 -42130.23 -42130.23 3100_STK -1.00 -1.00 3110 16874.68 16874.68 3110_STK -3.00 -3.00 3200 43.70 43.70 3210 1312.00 1312.00 3220 -4392.00 -4392.00 3220_STK -1.00 -1.00 3300 16762.03 16762.03 3420 -2235.80 -2235.80 3800 -4208.32 -4208.32 3850 56585.55 56585.55 4100 20927.31 20927.31 4110 3400.00 3400.00 4135 5187.42 5187.42 4140 2909.25 2909.25 4145 6276.04 6276.04 4200 112363.08 112363.08 4210 2667.00 2667.00 4235 4630.00 4630.00 4240 28366.78 28366.78 4245 4848.85 4848.85 4300 26970.00 26970.00 4350 2100.00 2100.00 4360 1046.96 1046.96 4400 29355.04 29355.04 4412 262.18 262.18 4413 194.64 194.64 4414 162.21 162.21 4420 159.44 159.44 4430 406.60 406.60 4431 229.95 229.95 4440 332.88 332.88 4500 11019.22 11019.22 4501 195.00 195.00 4502 1010.37 1010.37 4503 7726.46 7726.46 4570 410.16 410.16 4588 2222.11 2222.11 4620 12000.00 12000.00 4621 1125.00 1125.00 4622 11964.25 11964.25 4623 7192.85 7192.85 4630 1300.00 1300.00 4640 1691.59 1691.59 4700 2456.88 2456.88 4710 1032.08 1032.08 4715 2189.15 2189.15 4720 1214.43 1214.43 4725 800.00 800.00 4726 571.00 571.00 4730 1814.45 1814.45 4740 696.48 696.48 4770 618.10 618.10 4775 4192.00 4192.00 4780 7460.91 7460.91 4790 11379.15 11379.15 4800 17453.83 17453.83 4805 -216.19 -216.19 4830 84.33 84.33 4845 64.33 64.33 5002 7035.54 7035.54 5003 714.94 714.94 5004 3288.00 3288.00 5005 13229.07 13229.07 5009 2579.78 2579.78 5501 2497.01 2497.01 5502 -559.41 -559.41 5701 -29291.24 -29291.24 5801 506.39 506.39 7000 1153554.90 1153554.90 7010 272984.79 272984.79 7100 1167967.23 1167967.23 7110 271640.41 271640.41 7200 1176.10 1176.10 7210 2854.00 2854.00 7220 1874.37 1874.37 7300 9069.88 9069.88 7310 95120.77 95120.77 7420 18298.00 18298.00 7510 53512.16 53512.16 7800 -14099.08 -14099.08 7850 -130301.60 -130301.60 8000 -1414177.53 -1414177.53 8001 326495.30 326495.30 8010 -282547.05 -282547.05 8011 44226.72 44226.72 8030 -11090.22 -11090.22 8100 -1284762.95 -1284762.95 8110 -332836.86 -332836.86 8111 77906.86 77906.86 8112 -77906.86 -77906.86 8200 -2276.37 -2276.37 8210 -2910.81 -2910.81 8220 -1008.40 -1008.40 8300 -20832.98 -20832.98 8301 1604.41 1604.41 8310 -184561.96 -184561.96 8311 4271.06 4271.06 8400 -7592.70 -7592.70 8401 88.20 88.20 8410 -103945.89 -103945.89 8411 4913.42 4913.42 8420 -50226.14 -50226.14 8500 -585.00 -585.00 8510 -57014.70 -57014.70 8520 -19438.38 -19438.38 8520_STK 5.00 5.00 8870 -41503.87 -41503.87 8870_STK 3.00 3.00 8916 -1472.56 -1472.56 8999 0.00 0.00 9130 160.00 160.00 9143 170.44 170.44 9144 887.27 887.27 INFO:root:(1126, 21)