INFO:root:(5086, 11) INFO:root: Marke Standort Konto_Nr Kostenstelle ... Konto_Nr_SKR51 Marke_HBV Standort_HBV duplicated 1447 01 01 5701 42 ... 01-01-5701-42-99-70 1844 R10654 True 2173 04 01 5002 41 ... 04-01-5002-41-99-70 8253 2119 True 2188 04 01 5005 41 ... 04-01-5005-41-99-70 8253 2119 True 2441 01 01 5003 41 ... 01-01-5003-41-99-70 1844 R10654 True 2449 04 01 5008 40 ... 04-01-5008-40-99-70 8253 2119 True 2454 01 01 5008 41 ... 01-01-5008-41-99-70 1844 R10654 True 2477 04 01 5801 41 ... 04-01-5801-41-99-70 8253 2119 True 3186 01 01 8410 44 ... 01-01-8410-44-10-70 1844 R10654 True 3388 01 01 7420 42 ... 01-01-7420-42-00-72 1844 R10654 True 3706 01 01 8400 41 ... 01-01-8400-41-10-70 1844 R10654 True 3708 01 01 8401 41 ... 01-01-8401-41-10-70 1844 R10654 True 3718 01 01 8410 41 ... 01-01-8410-41-91-70 1844 R10654 True 3735 04 01 8420 42 ... 04-01-8420-42-10-70 8253 2119 True 3954 04 01 8410 41 ... 04-01-8410-41-10-70 8253 2119 True 3956 04 01 8410 41 ... 04-01-8410-41-10-70 8253 2119 True 3963 01 01 8410 41 ... 01-01-8410-41-50-70 1844 R10654 True 3968 99 01 8410 41 ... 99-01-8410-41-10-70 0000 01_ZZ True 3971 01 01 8411 41 ... 01-01-8411-41-10-70 1844 R10654 True 4291 01 01 5002 41 ... 01-01-5002-41-99-70 1844 R10654 True 4298 04 01 5003 41 ... 04-01-5003-41-99-70 8253 2119 True 4346 01 01 5005 41 ... 01-01-5005-41-99-70 1844 R10654 True 4350 04 01 5008 41 ... 04-01-5008-41-99-70 8253 2119 True 4352 01 01 5008 40 ... 01-01-5008-40-99-70 1844 R10654 True 4359 04 01 5701 41 ... 04-01-5701-41-99-70 8253 2119 True 4361 04 01 5701 42 ... 04-01-5701-42-99-70 8253 2119 True 4364 01 01 5701 41 ... 01-01-5701-41-99-70 1844 R10654 True 4370 99 01 5701 42 ... 99-01-5701-42-99-70 0000 01_ZZ True 4377 01 01 5801 41 ... 01-01-5801-41-99-70 1844 R10654 True 4965 04 01 8400 41 ... 04-01-8400-41-10-70 8253 2119 True 4970 04 01 8401 41 ... 04-01-8401-41-10-70 8253 2119 True 4973 04 01 8410 41 ... 04-01-8410-41-50-70 8253 2119 True 4975 04 01 8410 44 ... 04-01-8410-44-10-70 8253 2119 True 4976 04 01 8410 44 ... 04-01-8410-44-10-70 8253 2119 True 4979 01 01 8410 41 ... 01-01-8410-41-10-70 1844 R10654 True 4988 04 01 8411 41 ... 04-01-8411-41-10-70 8253 2119 True 4994 01 01 8420 42 ... 01-01-8420-42-10-70 1844 R10654 True [36 rows x 12 columns] 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: (1484, 9) INFO:root:df_combined: (1484, 19) INFO:root:df_pivot: (1442, 2) INFO:root:(1442, 8) INFO:root:Index(['Period01', 'CumulatedYear', 'Marke', 'Standort', 'Konto_Nr', 'Kostenstelle', 'Absatzkanal', 'Kostenträger'], dtype='object', name='period') INFO:root:period Period01 CumulatedYear 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 01-01-0320-26-00-06 -50.00 -50.00 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-22 -165.00 -165.00 01 01 0320 26 00 22 01-01-0320-26-00-49 -160.00 -160.00 01 01 0320 26 00 49 INFO:root:df: (1442, 8) INFO:root:period Period01 CumulatedYear Kontoart 1 168623.11 168623.11 2 -168623.11 -168623.11 INFO:root:period Period01 CumulatedYear Konto_1 0 -74873.49 -74873.49 1 441639.72 441639.72 2 2446.57 2446.57 3 -198143.12 -198143.12 4 362463.57 362463.57 5 0.08 0.08 7 2903651.93 2903651.93 8 -3437185.26 -3437185.26 t -0.00 0.00 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 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 1360 0.00 0.00 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 3010 -235951.39 -235951.39 3100 -42130.23 -42130.23 3110 16874.68 16874.68 3200 43.70 43.70 3210 1312.00 1312.00 3220 -4392.00 -4392.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 8870 -41503.87 -41503.87 8916 -1472.56 -1472.56 8999 0.00 0.00 tedY -0.00 0.00 INFO:root:(1096, 22)