Finance Automation with Python

#Finance #Automation #Python
Finance Automation with Python

It is by far my favourite plugin for vs code, awesome productivity tool for developers!

"Clean Code Friday"

Follow me on:

--------------------------------------------------------------------------------------------------------
GEAR:

Songs:
Rays - Ikson
Ghost - Ikson

[FlatLine]

Lol, but you can use Pandas. You can read csv table directly to Pandas dataframe, calculate everything you need and plot some graphics too without any json convertion. It seems like a really bad tooling choice for that kind automation

[fuba]

Great video, very informative. Just for future reference, this you can get the last element from a list by listname[-1], instead of the "len(list name) - 1" stuff..

[garishtiger]

It’s really nice to see your process and that even though you have a lot of experience you still constantly reference documentation and help wikis. Makes me feel like less of an imposter 😅

[flatfivsupport]

replace() is built-in. import re is for regular expressions. So not needed here. Great content, keep it up!

[Micaeljm]

At 9:40, there's a much simpler way of parsing the type and account number string, with unpacking:

>>> row = 'Insert 123-456'
>>> type, account = row.split(" ")
>>> type
'Insert'
>>> account
'123-456'

And accessing a list's last element can be done with `mylist[-1]`, no need to actually calculate the last position using `len(mylist) - 1`.
Many others already suggested Pandas, which would also make things incredibly simpler. It can automatically parse the dates, has simple methods for importing CSV and also exporting JSON, and a whole lot more.

[jerrymiller]

Kalle, I really love your videos. I come from Norway. I study business, and decided that it would be nice for my future career to learn Python. It is so fun! And luckily I stumbled across your Youtube channel! I can see on the way you make your videos and your presentation skills that you are going to go far! I especially love your intro! It is really cool! Keep going!

[akhlaq]

did exactly the same thing last year for my account with pandas and this was my first introduction to python :-) I would also recommend it here which results to a better readable code

[haxmusk]

Hey,

Most banks in Sweden actually provide an API to your transactions!

[denisssolonin]

Hi! I am using your File Handling script. So good so far! You are the best python bloger.

[dbdukxs]

I love the fact that i can play your videos at x2.0 speed and still undestand you. :))

[hughryan]

I’m learning to code and I downloaded Kite. It is extremely helpful, thank you!

[yatirsolan]

It’s been two years so I’m sure you already know that. For any case you don’t note that the replace is not part of the re module, but a string class method:) you can the same (and more) as replace with the method re.sub(….). Cool video, cool hairdo

[draupnerdata]

Yet another of your videos, showing good examples of nice code. Keep it coming!

[Crazy]

Edit: it was already said lol, sorry. But great way to see your thought process still love the video

I know I'm 9 months late, and mostly likely this is already said, but with panda's you could have parse and use your data super super easily.

The idea of the panda module is made exactly for this reason. And you could choose to layout your data in (almost) anyway you like.

[MrEndzo]

Title should be: accounting with Python.

[g.o.]

Dude, I love your vidz.
And... I believe you really need to breakdown your thinking/project idea in a small sketch or schematic before you start coding. In this way people can actually follow you while you are coding it. If you don't wanna do that because you are not really clear before starting coding, that's fine we all do that, but create a summary sketch or draw a summary map of what you did at the end of the project so people do understand what they just looked at. Also after speeding through the script you could comment each line to explain what you did.

[ThouguohT]

Lmao your intro like a Disney channel opening 😂😂😂 that’s hard!

[kalyanasundaram]

all your videos inspires me a lot to develop my knowledge on programming. thank you. you are my best programming teacher

[BavleoENG]

Jätte duktigt och intressant, det med att ha startat eget firma, speciellt när man bor I Sverige så behöver man kunna vissa saker, hade varit så grymt om du visade hur det är att ha enskild firma och skatta osv.

[tejasarlimatti]

You're a boon to mankind Kalle <3