import pandas as panda
import numpy as np
def PANDAS_DONE():
read = panda.read_csv('statek.txt', sep='\t')
select = panda.DataFrame(read)
# print(select)
# print(read)
select['data'] = panda.to_datetime(select['data'])
funds = 500000
print("Fundusze", funds)
czas = (select['data'] <= '2018-12-18')
Z = (select['Z/W'] == 'Z')
W = (select['Z/W'] == 'W')
# ------------------------------------------------------------------------
#kolumna stan_finansów to .......
wyd = select['wydatki'] = select['ile ton'] * select['cena za tone w talarach']
#print(select)
#print(select['wydatki'].cumsum())
# Generujemy listę wykorzystując Python Pandas oraz jej zawartość zapisujemy do kolumny 'Result'
result = []
y = select['wydatki'][0]
if select['Z/W'][0] == 'Z':
x = funds - y
print(x)
result.insert(0, x)
elif select['Z/W'][0] == 'W':
x = funds + y
print(x)
result.insert(0,x)
#for val in select['wydatki'][1:]:
for i in range(1,len(select['wydatki'])):
val = select['wydatki'][i]
if select['Z/W'][i] == 'Z':
result.append(x - val)
else:
result.append(x + val)
select["result"] = result
#print(select)
#sel = select.loc[(select['data'] == '2018-10-08')]
#print(sel)
print(select.groupby('data').max('result').sort_values(by='result', ascending=False))
def main():
PANDAS_DONE()
if __name__ == '__main__':
main()
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}