| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240 |
- 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)
|
