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
@aadityabhetuwal5990
4 жыл бұрын
python panda?
@Hallden_
4 жыл бұрын
You're most likely right. I didn't know about Pandas. And I wanted to save all the data to a json file in a certain way, and also the plan from the start was different then what the end product became so I kind of switched gears and stuff during the process. But you are probably right, I just didn't know any better tbh
@rusbelbermudez238
4 жыл бұрын
@@Hallden_ I did something like that, I used pandas with python, I parse xml files and get a summary in excel of every expense.
@TheIncredibleMrTrain
4 жыл бұрын
@@Hallden_ Pandas is GOD. I learned the library about two months ago and I don't know how I did anything before that. Pro tip: You can build dataframes much quicker by making a list containing dictionaries with column names as the key and the column value for the value. You can then just pd.DataFrame from that list. Waaaay better and faster than using concat and the like. For each row AKA 'i': for col in dfIn.columns: ZXsortDict.update({str(col): dfIn[col][i]}) ZXsortList.append(ZXsortDict) Then load into dataframe: dfZX = pd.DataFrame(ZXsortList, columns=['Temp Iter'.....'Mag Ref'.....'Time'])
@mokus603
4 жыл бұрын
If you use pandas for your OOP, then you should be ashamed as a programmer 😂 pandas is GREAT for data analysis, machine learning preprocessing but don't think you can be mistaken for a genius.
@fuba44
4 жыл бұрын
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..
@CleverProgrammer
4 жыл бұрын
Nice thumbnail :)
@Hallden_
4 жыл бұрын
Thank you! I'm really happy with it! :)
@toremolin9709
4 жыл бұрын
Hi @Clever Programmer! I’m currently watching your free python course and it has helped me out alot! Thank you for making something like that for free!
@jefthervieira1
3 жыл бұрын
Good. Now let's see Paul Allen's.
@jefthervieira1
3 жыл бұрын
@@titan18238 sorry, cult movie reference: kzitem.info/news/bejne/xH-Jv653bGhejY4
@garishtiger140
3 жыл бұрын
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 😅
@jerrymiller1590
4 жыл бұрын
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 KZitem 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!
@haxmusk
4 жыл бұрын
Hey, Most banks in Sweden actually provide an API to your transactions!
@Hallden_
4 жыл бұрын
Okay nice I guess I got too excited about the csv to even think about that haha I just assumed they had a closed API, but thanks for letting me know. Now I can go ahead and make this into something even better :)
@g.v.m7935
4 жыл бұрын
@@Hallden_Now I'm looking foward how you will change and improve your program. Will you make another video on the improvements?
@corneegeenen388
4 жыл бұрын
@@Hallden_ they can be a lot more difficult to get data from in comparison to downloading a simple csv dump yourself they have to be PSD2 compliant which involves hashing, encrypting, registering (PSD2) eIDAS QSEAL certificate and so on
@MrEndzo
4 жыл бұрын
Title should be: accounting with Python.
@M.G.R...
4 жыл бұрын
Yes
@flatfivsupport3919
4 жыл бұрын
replace() is built-in. import re is for regular expressions. So not needed here. Great content, keep it up!
@Hallden_
4 жыл бұрын
Okay nice, I got the feeling it wasn't entirely necessary XD
@mrqreeny
4 жыл бұрын
Actually, if I get it right what you want to do, you don't need replace at all :p this would work: Entry_split= row[1].split(" ") Acc_nr = entry_split[-1] Name= entry_split[0]
@hughryan6124
4 жыл бұрын
I’m learning to code and I downloaded Kite. It is extremely helpful, thank you!
@akhlaq87
4 жыл бұрын
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
@Hallden_
4 жыл бұрын
Thanks for the tip, anything for more readable and cleaner code! :)
@intfxdx
4 жыл бұрын
Great videos :) I used python and specifically pandas to automate a whole bunch of activities that I need to do as a prof
@user-db2du6kx7s
4 жыл бұрын
I love the fact that i can play your videos at x2.0 speed and still undestand you. :))
@hatben
4 жыл бұрын
You should probably link to the Kite homepage in the description instead of the direct download link. I don't think many people will click that knowing it's gonna immediately start a 250MB download, I know I didn't. I'm hoping that's not part of the terms of their sponsorship deal. It's just kinda bad practice, especially considering there's people out there with internet data caps, especially on mobile.
@hatben
4 жыл бұрын
I see that they have tracking on that link to know it's coming from your channel, so I assume that is the specific link they wanted you to use. You should ask them about changing that in the future cause it makes them look kinda bad, even if their product is good.
@denisssolonin1986
4 жыл бұрын
Hi! I am using your File Handling script. So good so far! You are the best python bloger.
@Micaeljm
4 жыл бұрын
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.
@g.o.6321
4 жыл бұрын
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.
@yatirsolan
2 жыл бұрын
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
@TheOnlyEpsilonAlpha
4 жыл бұрын
Video begins at 4:37. You’re welcome!
@draupnerdata
4 жыл бұрын
Yet another of your videos, showing good examples of nice code. Keep it coming!
@budiprakosa6984
4 жыл бұрын
i build my own too, i use google sheet script to fetch my current statement and plan me weekly expenses budget in json, then i consume it from react native app, btw the api is little tricky since i have to mitm to sniff traffic from my bank app
@Crazy1793
4 жыл бұрын
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.
@kalyanasundaram9021
4 жыл бұрын
all your videos inspires me a lot to develop my knowledge on programming. thank you. you are my best programming teacher
@ThouguohT
4 жыл бұрын
Lmao your intro like a Disney channel opening 😂😂😂 that’s hard!
@aslamsayyed3961
4 жыл бұрын
Nice one. One request, could you please add "comments" into your code, it becomes more easy to read the code for new beginners like me :-)
@kawsarahamed3318
4 жыл бұрын
me too. If you want u can connect me so that we can discuss things. Email me if you want "kawsarahamed624@gmail.com"
@charlesmtawalijr8417
4 жыл бұрын
Hey Kalle, Great Job on the video. I am a beginner programmer who has been following along. I'd like to request a favor, since you have removed personal details on the export csv file. Can you please make it available so we can be able to follow along with the code more smoothly.
@tejasarlimatti8420
4 жыл бұрын
You're a boon to mankind Kalle
@Hallden_
4 жыл бұрын
Haha had to google "boon" But thank you! :)
@MyPrasad12345
2 жыл бұрын
@@Hallden_ Lol
@arbazkhan8320
4 жыл бұрын
Hey kalle nice video man👍 Please try to make more videos related to python & Python automation
@Hallden_
4 жыл бұрын
Thank you! Yes I will ;)
@jonathanacuna
2 жыл бұрын
This was so incredibly helpful!!!
@curryeater259
4 жыл бұрын
Thanks for the video mate
@Hallden_
4 жыл бұрын
You're welcome! ;)
@GardPavels
4 жыл бұрын
You should check out Pandas if you´re using python to handle CSV :)
@Hallden_
4 жыл бұрын
Yeah a few people have mentioned it now so I should probably check it out properly. I have used it for something in the past, but forgot what it was
@Hallden_
4 жыл бұрын
*also thanks for the tip!
@rockfarmer2524
4 жыл бұрын
I really hope that you editied your personnummer in your transaction examples, not just your income! Stay safe!
@ProgrammingwithPeter
4 жыл бұрын
Great one, I wanted to do the same stuff a while ago, but it's like ...meh and found ledger-cli which is enough for me !
@Hallden_
4 жыл бұрын
Thank you, okay nice that's a good way to solve it too though :)
@ParanoidNotAndroid
2 жыл бұрын
Amazing video ! really helpful. 1:16 there is one frame that your photo appear randomly with your old haircut WTF.
@samsonmabeka8763
4 жыл бұрын
How about a video on game indie development using unity
@luccabaumgartner1740
4 жыл бұрын
Great Video! It really shows how you can benefit from being able to code in different aspects of life. I actually had a similar idea recently for my private finances, to keep track of my expences etc. Still waiting for my bank to make their API available to the public...
@JacksonWelch
4 жыл бұрын
This is really neat. Great content as always!
@JacksonWelch
4 жыл бұрын
I love Kite! Thanks for showing it.
@bigboiblue1925
4 жыл бұрын
Great vid! You could just do account_num[-1] . Accessing index -1 in python wraps around to the last index! Additionally, you don't need to import re ... You didn't use it! It's for regex operations... Using mypy or pylint could help you pick up on unused imports and vars :)
@daveland2653
3 жыл бұрын
Sometimes I put semi-colons at the end of my lines of code just to remember why I dropped out of university.
@shubhchaudhary6562
3 жыл бұрын
csv data management using python actually in high school cs course in India
@todorpopov8613
4 жыл бұрын
Yup kite's amazing
@almostanengineer
4 жыл бұрын
I hate skipping ad’s for great creators, but I can’t do those ‘udemy’ or ‘udemy style’ ads 😣
@nils3030
3 жыл бұрын
You should have a look into beancount.
@RizalAbulFata
4 жыл бұрын
thanks Kalle. as before, I'm really enjoy your video
@Hallden_
4 жыл бұрын
Thank you that's awesome to hear :)
@Her555Bert
4 жыл бұрын
8:35 Wouldn't it be even easier like that: account_num = row[1].split(" ")[-1] name = row[1].split(" ")[0]
@LorenzStadler
4 жыл бұрын
The name could contain spaces.
@DylanPiper
4 жыл бұрын
Johnny Lawrence has stopped bullying Daniel Larusso and is programming now? Good on him!
@frans2526
4 жыл бұрын
You may try Revolut with their API and you gain one step into a fully automated system ? (of course you will need to create and transfer you account to Revolut)
@user-pw9vl8vc4k
4 жыл бұрын
I did some automation where I aggregate data from multiple bank csv files that are loaded then combined in a Power BI report
@isaacelijah6117
3 жыл бұрын
Good day from Nigeria, Kalle. I am new to Linux (Fedora 32 x86_64) and I've been trying to integrate Kite plugin to Sublime Text, but couldn't. Are you using Linux as your environment? Which IDE are you using? and; How did you integrate the kite plugin? Great work you're doing. Keep it up.
@bestorjnr6648
4 жыл бұрын
Nice video, I would suggest if you can make a video on OOP maybe with python
@vincentpham7445
4 жыл бұрын
o my god, the plugin is so awsome.
@BavleoENG
4 жыл бұрын
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.
@pubgfuplaying4500
4 жыл бұрын
very helpful thanks bro love from pakistan
@techsource2235
3 жыл бұрын
What programming languages do you know AND use daily besides Python? I am learning Python right now as I like it a lot and wandering if being proficient in Python will suffice...Thank you.
@theheadlesschickenshow604
4 жыл бұрын
Where can I find your desktop wallpaper?
@WOUUUTT
4 жыл бұрын
What sublime theme are you using?
@HistoryforThinkers
4 жыл бұрын
“How much should I pay in taxes?” Me: *None.*
@erickballesteros4531
4 жыл бұрын
Great Video!
@BehradDavoudi
4 жыл бұрын
oooo like the intro!
@Hallden_
4 жыл бұрын
Thank you man! me too ;)
@tbm5k
4 жыл бұрын
Hey Kalle, nice project here😃
@Hallden_
4 жыл бұрын
Hey man, thank you!
@aslamsayyed3961
4 жыл бұрын
Hi Kalle, could you please share the sample CSV file?
@piotrjasielski
4 жыл бұрын
Why do you need JSON? Wouldn't a simple dictionary or an array with pandas be enough to process all that? Looks like a lot of redundant coding for me. No offense, just constructive critique.
@Hallden_
4 жыл бұрын
True! The reason for using json was just that I wanted to store it. So save previous months as well. But not necessary :)
@piotrjasielski
4 жыл бұрын
@@Hallden_ Sure thing. As a web developer you're also probably more used to that format. I personally don't know much about web development but I have an RPA/data analytics background, so I'm happy to see tutorials about automation. If you're interested in this field, you can take a look at the python library I'm developing: github.com/pjasielski/pythomation It still requires a lot of work to finish, but even so you can easily build automation bots with it - perhaps a good idea for a video. If you have any questions feel free to contact me. I'll be happy if you spread the word about how powerful python can be in the field of automation.
@Hallden_
4 жыл бұрын
@@piotrjasielski nice man, thank you! I'll take a look :)
@pilhamre9182
4 жыл бұрын
Youre videos are so entertaining to wqtch! But if you want to get more people interested in youre work, then try to add some background music even when you talk. Keep the good work up!!
@Hallden_
4 жыл бұрын
Thank you! Yes I mix it up, trying to sometimes have music for certain talking bits and some of them without :)
@SURYAAkr1998
4 жыл бұрын
I'm learning C++ at the Uni since a few weeks, could anyone recommend me some tutorials on the internet to learn and understand the language better. thanks
@tomascnunes
4 жыл бұрын
www.learncpp.com
@charan775
4 жыл бұрын
First, learn to read docs. Use C++ official docs. Instead of just reading syntax and various functions and their uses, practice algorithmic problems on hackerrank. That'll help you to learn C++ properly. And after solving about 50-70 problems you'll get comfortable with the syntax and then do some development using C++. This is a great repo for project-based learning. Use this to learn & build projects using C++ (github.com/tuvtran/project-based-learning/blob/master/README.md#cc). All the best.
@Halfek66
4 жыл бұрын
kzitem.info/news/bejne/km6ZmYGKkWKBfmU
@abdulrahimbangura448
4 жыл бұрын
In my opinion I recommend the KZitem channels "kzitem.info" and "kzitem.info/rock/8butISFwT-Wl7EV0hUK0BQ"
@abdulrahimbangura448
4 жыл бұрын
kzitem.info/news/bejne/1ax5l4t5nYhii4o
@ThePiko69
4 жыл бұрын
nice !
@thomaspaine6082
4 жыл бұрын
Can you combine the use of emmet and kite or are they different ?
@Xylophonx
4 жыл бұрын
Great Video! Quick question how difficult would it be now to add a UI with graphs and everything to this?
@KjipGamer
4 жыл бұрын
That probably depends on how complex you want to make the graphs. But essentially, it should just be a matter of layout and plugging in the numbers.
@Hallden_
4 жыл бұрын
Yeah like Kjip said depends on the complexity of the UI but not super difficult
@Dev-nt9vt
4 жыл бұрын
no park running in the beginning?
@Hallden_
4 жыл бұрын
No I decided to leave it out of this one. It's a practice that is unfit for certain video types ;)
@carlosorelhas1087
4 жыл бұрын
Hey Kalle, thanks for sharing this automation. I have some struggles to build/open my own company and if we can talk at least 10/15 min I really appreciate it. Let me know in the comments if you have some way we can talk. Regards
@Hallden_
4 жыл бұрын
Thank you man I'm glad you like it! You shouldn't talk to me about that, find someone at your local bank. I really wouldn't be able to help you :)
@rikster154
4 жыл бұрын
Vill gå en kurs med dig! :)
@waitesdennis
3 жыл бұрын
Definitely should have used Pandas for all of this, it would have been much easier for you.
@samilu99
4 жыл бұрын
Can you do a guide how you set up your Visual Studio Code with python?
@Hallden_
4 жыл бұрын
kalletech.com/extensions/
@internetproxysat
4 жыл бұрын
nice intro by the way
@augustinegyan4277
4 жыл бұрын
Please try and do videos on how to link flutter to VS Code in windows .....i dont use MacBook.....Thanks
@matt_t937
4 жыл бұрын
When you have to import the CSV file from your bank, how do you have to convert it and make it readable for Python? Do you have to do this process by hand or the file comes in a way that is accessible straight away? I didn’t quite get that part. Do you recommend using Pandas Python library for data visualization and analysis?
@sciencenerd6623
4 жыл бұрын
Matteo Ticli If you use Panda it can automatically read the csv file as long as you properly store it Jupyterlab is also good way to read it through Python
@blzahz7633
4 жыл бұрын
8:32 shows lines _import csv_ _with open('export.csv') as csv_file:_ _csv_reader = csv.reader(csv_file, delimeter=',')_ And so on..
@AmmarAlam
4 жыл бұрын
I am curious why use json, when we can do it over xlxc format too?
@vishalmishra1937
4 жыл бұрын
Hey kalley I need help .I want to build website for product affiliation using Amazon. So how to update scraped item in database with previous old data if there is any .I am clueless plz help
@guyotizaks2176
4 жыл бұрын
Hi Kalle, are you self taught?
@CarlosRodriguez-vg2ob
4 жыл бұрын
hi, looking for something that i can run and pay bills.I have a script that i wrote where i iterate through my bills and input the amount to pay and credit card to use however I dont know how to get the script to connect to the actual companies that i need to make payments to. like electric, water , cell phone ...... do they need to have an api for me to use. let me apologize ahead of time because im only a week old in python and this whole world is completely new to me
@medical.cinema
4 жыл бұрын
Nice video. How’d you do your intro?
@sagebaram5951
4 жыл бұрын
Hey Kalle, wanted to ask why are you not using Vim(with Tmux) ? You're relying quite heavily on your terminal and moving back and forth to Vs-Code sort of hinder your productivity in the long run. It's a steep learning curve (for intermediate stuff) but worth the hassle in the long run.
@Hallden_
4 жыл бұрын
Yeah I want to get into it to be honest, just haven't had the time but my goal is to move entirely to Vim in 2020 :)
@Hallden_
4 жыл бұрын
Oh also, why specifically Tmux? (I don't know much about Vim or working with it)
@sagebaram5951
4 жыл бұрын
Kalle Hallden Tmux (Terminal multiplexer) makes using a terminal a lot smoother. You can split screens and hold multiple sessions of your terminal (each screen can hold something different). Coolest part about it is you can ssh into a machine, download something and if you ever need to you can always close the terminal, reopen it any time and Tmux will hold the session for you. (Heard it drops the sessions when you boot. But it happens rarely on mbp)
@sagebaram5951
4 жыл бұрын
Forgot the main point 🤦🏻♂️. You can run a session at one side of vim (your editor) and running the code on the other, you can add more screens to it if you need to display more information
@tinocaer2861
4 жыл бұрын
I used vim for a while but since I have a Touch Bar Mac the escape key is unbearable to use heavily since there is no feedback. If I get a new Mac which has a physical escape key I will switch back to vim but for not it is much easier to code in vs code. Also, vs code has a built-in terminal so I don't know why he doesn't use that as well...
@jcros_
4 жыл бұрын
id use pandas personally for data cleaning and operations...
@roymustang3327
Жыл бұрын
Can anyone suggest me what are langs that I should in backend if I want to implement this as a website ?
@ivanseagull5192
4 жыл бұрын
very cool
@Hallden_
4 жыл бұрын
Thank you
@WaldirBorbaJunior
4 жыл бұрын
Amazing man, I really like because you're using Python.
@Hallden_
4 жыл бұрын
Thank you, glad to hear that you like it! :)
@張祐誠-t2k
3 жыл бұрын
what platform do u use to run python
@tomekdrzi6994
4 жыл бұрын
have you switched to a macbook air?
@SuperDr27
4 жыл бұрын
Hi. One side question. I noticed that you use external monitor to code. Have you experienced some issues with blurry icons on that external monitor (assuming that you updated your mac to Mojave or Catalina) which was common for both updates.
@Hallden_
4 жыл бұрын
No not yet fortunately :)
@SuperDr27
4 жыл бұрын
Kalle Hallden Thanks for info man. By the way, good content on your channel. Lots of usefull things to pick up.
@johnnyxd6065
4 жыл бұрын
And how do you download the .csv file from the bank?
@androidevolution3229
3 жыл бұрын
Hi Kalle
@rafavince
4 жыл бұрын
You are based in Europe, banks offer api connection now...
@_xzvf2557
4 жыл бұрын
FYI, in the time-lapse at 7:05 you forgot to redact what seems to be your actual transactions. and for 9:05 lst[-1] is the same as lst[len(lst)-1]
@ehabtalaat7592
4 жыл бұрын
very amazing video. would you make a video a bout how to start as a freelancer and do well .
@Hallden_
4 жыл бұрын
Thank you! Yes I am actually planning on doing a video like that early next year :)
@leonjager643
4 жыл бұрын
What MacBook do you have now?(specs) And would you recommend the new Macbook Pro 16 inch?
@Hallden_
4 жыл бұрын
I got the 2018 macbook 512SSD with i9 core and it has major over heating issues. Have no idea about the 16inch 2019 model but have seen like two videos on it and it seems a lot better. I am tempted to switch
@leonjager643
4 жыл бұрын
@@Hallden_ it looks very good to me to what Ive Seen so far...
@uvaishassan
4 жыл бұрын
Adam Driver?
@adityakhatwa8555
4 жыл бұрын
why you didn't used API by the banks.....
@vishwanath-ts
4 жыл бұрын
Do Indian banks have API?
@adityakhatwa8555
4 жыл бұрын
@@vishwanath-ts did you ever used google pay or paytm..... how do you think they link your account! Well I know your answer. "Magic" right!
@vishwanath-ts
4 жыл бұрын
@@adityakhatwa8555 but how to get the API
@adityakhatwa8555
4 жыл бұрын
@@vishwanath-ts my man it is a secure algorithm on which it works.... but you have to contact your respective bank and they will provide you with your API for developing purposes.... and yes google can be quite handy if you want to know the process.
@Hallden_
4 жыл бұрын
My bank doesn't have an open api as far as I know
@sweLogan
4 жыл бұрын
Nordea? I do this too :)
@caffeinejavacode1475
4 жыл бұрын
Why do you prefer Python to Java?
@Hallden_
4 жыл бұрын
Because it's just a little bit more modern and a little faster to type out :) I really like Java too though
@ehsannorouzi9546
4 жыл бұрын
you can do all of those calculation with excel :))
@deadbody408
4 жыл бұрын
Kite is free?
@Chris-oj4ze
4 жыл бұрын
Hey Kalle! Wouldn't it be easier to write a script in VBA?
@TheHellis
4 жыл бұрын
Highly doubt that VBA has json support. I believe VBA was last updated before json was invented :-) But sure VBA is easy to use when you have a worksheet to parse the data on.
@Chris-oj4ze
4 жыл бұрын
@@TheHellis Yes thats what i mean, if you get the data in csv anyway then you can write a VBA script =)
Пікірлер: 240