I Analyzed My Finance With Local LLMs

Sdílet
Vložit
  • čas přidán 7. 05. 2024
  • Get $200 off CourseraPlus 👉 imp.i384100.net/nLvdN9
    GitHub repo 👉 github.com/thu-vu92/local-llm...
    🔑 TIMESTAMPS
    ================================
    0:00 - Project intro
    1:35 - Sponsor (Coursera)
    2:04 - Why using local LLMs?
    3:34 - Install Ollama
    4:14 - Run local Mistral model
    6:17 - Run local Llama2 model
    7:27 - Customize LLMs with Ollama
    9:53 - Access Llama2 with Langchain (Python)
    10:45 - Categorise bank transactions
    14:46 - Create personal finance dashboard
    17:24 - Conclusions
    👩🏻‍💻 COURSES & RESOURCES
    ================================
    📖 Google Advanced Data Analytics Certificate 👉 imp.i384100.net/anK9zZ
    📖 Google Data Analytics Certificate 👉 imp.i384100.net/15v9y6
    📖 Learn SQL Basics for Data Science Specialization 👉 imp.i384100.net/AovPnJ
    📖 Excel Skills for Business 👉 coursera.pxf.io/doPaoy
    📖 Machine Learning Specialization 👉 imp.i384100.net/RyjykN
    📖 Data Visualization with Tableau Specialization 👉imp.i384100.net/n15XWR
    📖 Deep Learning Specialization 👉 imp.i384100.net/zavBA0
    📖 Mathematics for Machine Learning and Data Science Specialization 👉 imp.i384100.net/LXK0gj
    📖 Applied Data Science with Python 👉 imp.i384100.net/gbxOqv
    🙋🏻‍♀️ LET'S CONNECT!
    ================================
    🤓 Join my Discord server: / discord
    📩 Newsletter: thu-vu.ck.page/profile
    ✍ Medium: / vuthihienthu.ueb
    🔗 All links: linktr.ee/thuvuanalytics
    As a member of the Amazon and Coursera Affiliate Programs, I earn a commission from qualifying purchases on the links above. By using the links you help support this channel at no cost for you.
    #ai #datascience #ThuVu #dataanalytics

Komentáře • 341

  • @whatifi-scenarios
    @whatifi-scenarios Před měsícem +4

    This is great. We're in the process of integrating LLMs into our "what if" scenario modelling platform and this gave me a few ideas on next steps. Sharing this video with my dev team!

  • @Codad
    @Codad Před 2 měsíci +3

    This is such a great video. Thank you for making it. I had no idea this sort of thing was possible and I'm finding all sorts of ways to take advantage of it now.

  • @kevinmanalang9182
    @kevinmanalang9182 Před 3 měsíci +2

    Hi Thu! Last year I had referenced your panel dashboard video to build my personal finance dashboard. I like seeing how you built yours. Your content is very useful. Thank you!

  • @user-ew8ld1cy4d
    @user-ew8ld1cy4d Před měsícem +19

    Are you a real human? I have NEVER seen an author on youtube cover so much incredible knowledge in such a short video. This is absolutely AMAZING!!! Thank you

  • @leonardvermeer7908
    @leonardvermeer7908 Před 2 měsíci +1

    What an amazing video! This is definitely a personal project that I've wanted to tackle and while I'm familiar with other languages, I'll definitely use your video as a guideline.

  • @hrgagan9192
    @hrgagan9192 Před 2 měsíci +1

    Wow absolutely wow, thank you for such a great project, so many ideas ringing in my head. Cheers

  • @bereniceflores81
    @bereniceflores81 Před 2 měsíci +1

    Always good to see more people bringing data skills to understand personal finance.

  • @gr8tbigtreehugger
    @gr8tbigtreehugger Před 3 měsíci +9

    This was an excellent video - many thanks for sharing!

  • @PauloLeiteBR
    @PauloLeiteBR Před 2 měsíci +1

    Excellent video, I used the concepts to enhance a project that I had already started in R and it worked fine, but so slow in my computer (like 5 min to analyse 10 registers). Now I know the concepts and I`ll keep experimenting with other LLM models. Thank you!

  • @_stition9777
    @_stition9777 Před 2 měsíci +1

    Thank you so much for making this video. Subscribed, this is exactly the content I look for

  • @SebastianSastre
    @SebastianSastre Před 2 měsíci +4

    Thank you for sharing this dear! You covered the basics and shown the path to a great first goal with your own custom on premise and well licensed LLM. Huge!

    • @Thuvu5
      @Thuvu5  Před 2 měsíci

      You are so welcome! Glad it was helpful 🙌

  • @noahchristie5267
    @noahchristie5267 Před 3 měsíci +43

    Incredible intro video for the semi technical about how chat gpt and similar models will be used in daily life to improve the mundane tasks, with a side of cautions about incorrect answers and computational limitations! Great balance, I’m already sharing it around our team 😊

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +1

      Thanks a lot for your comment and for sharing it around! Really appreciate it 🤩🙌

  • @borismeinardus
    @borismeinardus Před měsícem +1

    Love the video! The beginning sets up the project perjectly and the tutorial is very easy to follow!

  • @andrewshatnyy
    @andrewshatnyy Před 2 měsíci +1

    Wow this is fantastic video. Thank you, Thu!

  • @jteichma
    @jteichma Před měsícem +1

    Thanks for the great overview of using aa local LLM Thuy! Very useful and informative.

  • @akinwalehabib
    @akinwalehabib Před měsícem +1

    Amazing work you put in here. This is inspiring

  • @AlexandreRousselet
    @AlexandreRousselet Před 3 měsíci +2

    J'ai adoré, vidéo super clair allant droit au but et qui nous la joie d'aller découvrir le code

  • @vadud3
    @vadud3 Před 3 měsíci

    Really awesome explanation! I am going to use this. Thank you Thu!!

  • @chrisumali9841
    @chrisumali9841 Před 2 měsíci

    Thanks for the demo and info. So detailed and analytics are great. Have a great day

  • @TGr963
    @TGr963 Před 3 měsíci +1

    thank you! this is a project i'd love to try, keep up the good work 😊

  • @TheBenJiles
    @TheBenJiles Před 3 měsíci +1

    Thanks so much! It giving me inspiration for using this in a security analysis context.

  • @Turbo_Tastic
    @Turbo_Tastic Před 2 měsíci +1

    this is great.. thank you for the breakdown of all these options

  • @muhannadobeidat
    @muhannadobeidat Před 2 měsíci +2

    Thanks for the video. Nicely done and presented, educational with an interesting use case

  • @jpcf
    @jpcf Před 3 měsíci

    I was looking for THIS! Thanks!!

  • @AshishRanjan-jn7re
    @AshishRanjan-jn7re Před 3 měsíci +96

    Great video... My 2 cents: we can force LLMs to respond only in json format by stating it in system prompt, so you get consistent parsable response always (I've tried with gpt4), also you can provide list of possible expense categories to avoid grouping them together later (like 'Food & Beverage' and 'Food/Beverage')

    • @martinmoder5900
      @martinmoder5900 Před 2 měsíci

      Yeah, it is very powerful! However, is llama2 also providing this?

    • @NicolasCerveaux
      @NicolasCerveaux Před 2 měsíci

      @@martinmoder5900 llama2 and even gemma:2b does that too, but when I tried it still generated "new" categories, and the json answers would be "odd" like sometime it would modify the name of the expense.

  • @TheInternalNet
    @TheInternalNet Před 2 měsíci +1

    I learned so so much watching this. Thank you so much.

  • @anissaa1017
    @anissaa1017 Před 6 dny +1

    Thank you so much for sharing this with us!! I’ve been looking to do this for years but just thinking about the task ahead, I would give up. I will definitely analyze my own financial statements. Thanks mucho gusto!!

  • @therealpattypooh
    @therealpattypooh Před 3 měsíci

    Great video to start using LLM! Thank you for sharing!

  • @Echo11days
    @Echo11days Před 3 měsíci

    Well done I'll try and re-create this. Thank you once again

  • @luismoriguerra669
    @luismoriguerra669 Před 17 dny +1

    this is one of the best videos I watched about llms

  • @thinkingmachine7760
    @thinkingmachine7760 Před 3 měsíci +17

    Thank you so much. 🥰It is so well explained and a very cool project. I think LLMs are a powerful tool and running them locally will make it safe to share critical information with them.

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +2

      Thank you, really appreciate it! ❤

  • @bimoariosuryandaru325
    @bimoariosuryandaru325 Před 11 dny +1

    This is great! I was recently experimenting on a personal finance tracker dashboard and connect it to a chatting apps, so the user could easily input their financial activity by only typing it. On the process, i try to use chat gpt to simplify and generalise the format so we can input the data faster, never have i thought that it could be done by a local LLM. Looking forward for your next video.

  • @DorianIten
    @DorianIten Před měsícem

    Amazing.
    Thank you for sharing this, I learned so much!

  • @positivitywins8957
    @positivitywins8957 Před měsícem

    Amazing job explaining this!

  • @sanatdeveloper
    @sanatdeveloper Před měsícem

    Awesome research as always!

  • @raviv5109
    @raviv5109 Před 3 měsíci

    You are awesome! Thanks for making this video.

  • @anuraagpandey8316
    @anuraagpandey8316 Před 2 měsíci

    incredible, loved the content.

  • @nguyentrananhnguyen7900
    @nguyentrananhnguyen7900 Před 3 měsíci

    ayo, i'm just doing my first step that's logging every expenses i got since the start of this year
    i'm just thinking about doing some sort of software that help me manage my expenses and savings
    and this is exactly what i think of
    thank you for the high quality video

  • @Rafaelkenjinagao
    @Rafaelkenjinagao Před 3 měsíci +4

    Fantastic! Your videos are always good surprises at my feed.

  • @gridaranbirthuvi
    @gridaranbirthuvi Před měsícem

    Great video .. The one project which I wanted to take up during my holidays .. Learn in the same time have a view on my personal finance ..

  • @user-eo1zg2dp6g
    @user-eo1zg2dp6g Před 3 měsíci +1

    Very concise and informative video. I appreciate it.

  • @apvitor
    @apvitor Před měsícem

    You are a very good presenter, easy to follow. Nice content

  • @maddie33300
    @maddie33300 Před 3 měsíci +1

    Thanks for sharing with us, much appreciation! ❤️

    • @Thuvu5
      @Thuvu5  Před 3 měsíci

      Thank you for watching! ❤️

  • @IdeationGeek
    @IdeationGeek Před 2 měsíci +1

    I see how this is useful for being one's own accountant :) Super!

  • @qbitsday3438
    @qbitsday3438 Před 3 měsíci +1

    Love it , i am subscribing instantly , i have a lot of questions.

  • @bhusanchettri8594
    @bhusanchettri8594 Před měsícem

    Great insights and well explained!

  • @nimeshkumar8508
    @nimeshkumar8508 Před 29 dny +1

    Thankyou so much for this video. I relly like the explanation. Thanks

  • @haqk4583
    @haqk4583 Před 3 měsíci +1

    Thanks for the great intro into how to get started with local LLMs. I'll give it a go after Tết 😄

    • @Thuvu5
      @Thuvu5  Před 3 měsíci

      Happy Tet holiday! 😀🎉

  • @SteelWolf13
    @SteelWolf13 Před 2 měsíci

    Nice. Might give this a try over the weekend. Just need to figure out how to get my banks data.

  • @MaoExplorer
    @MaoExplorer Před 2 měsíci

    Great vid, great content, and easy to understand.

  • @bengriffin6157
    @bengriffin6157 Před 3 měsíci +3

    Very well explained. Looking forward to you posting the github repo.

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +2

      Thank you for watching! I've added the repo link in the description 🙌🏽

  • @stefankachaunov396
    @stefankachaunov396 Před 3 měsíci +1

    I love this video, thank you very much!!

  • @ShivamMiglani
    @ShivamMiglani Před 3 měsíci

    Thanks Thu, just heard about local LLMs from my boss today and look whose video is on the top to help me out! 😃

    • @Thuvu5
      @Thuvu5  Před 2 měsíci

      Hey Shivam! Thanks for watching! So happy to see your comment 😍🤗

  • @dasurao7736
    @dasurao7736 Před 2 měsíci +1

    Your videos are well thought out .. Keep them coming - Dont want you "retiring soon" 🙂

    • @Thuvu5
      @Thuvu5  Před 2 měsíci

      Haha thank you for this! Don’t worry, with CZcams I don’t want to retire anytime soon 😉🤗

  • @ricb4195
    @ricb4195 Před 2 měsíci +1

    I loved this and hope to try this out for myself (though my programming skills are very rusty)

  • @oneallwyn
    @oneallwyn Před 3 měsíci

    Finally the text classification video that I was searching for

  • @korntron
    @korntron Před 3 měsíci +18

    Outstanding video, especially for this beginner. Didn’t know you could run the models locally. Those ollama layers look like docker, fascinating how the context is setup. Time for me to spend some cycles on all your vids, not just the couple I’ve casually looked at. Thanks!

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +2

      Glad to hear you found the videos helpful! Thanks for stopping by 🙌🏽

    • @pw4827
      @pw4827 Před 3 měsíci

      Me too. I thought you need to have some monstrous supercomputer and spend weeks on configuring everything to run one of these models locally

  • @winhater
    @winhater Před 2 měsíci +1

    I never ever ever comment on anything, but goddamn - what a great video/tutorial. Just finished playing with the notebook and I learned a ton!

    • @Thuvu5
      @Thuvu5  Před 2 měsíci

      That’s so awesome to hear! Thank you so much for commenting ❤️🤗

  • @gmostafaali
    @gmostafaali Před 3 měsíci +2

    Your content always useful! I like the Panel lots.

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +1

      Thank you so much! So happy to hear 🤩

    • @gmostafaali
      @gmostafaali Před 3 měsíci

      @@Thuvu5 💛

  • @EricSchroeder-cc4hf
    @EricSchroeder-cc4hf Před 29 dny +1

    very good! thank you for sharing!

  • @mustafadut8430
    @mustafadut8430 Před 3 měsíci +1

    If you want to give data as many as the number of tokens of the model. You don't need to calculate and know by hand. Instead, you can do this with "chunks" in Langchain. nice explanation thank you

  • @mumishen4819
    @mumishen4819 Před 3 měsíci +1

    Great info, and thanks a lot

  • @mrbarkan
    @mrbarkan Před 11 dny +1

    This is incredible, a bit far fetched from my skills and time in hands. But surely inspiring!

  • @deniowork7084
    @deniowork7084 Před 2 měsíci

    Love this!

  • @siddharthbouddha
    @siddharthbouddha Před měsícem

    Amazing and inspiring 😊

  • @olivermorris4209
    @olivermorris4209 Před 3 měsíci +6

    Thanks Thu, great demo of Ollama, sorry your arent going to be retiring anytime soon😢
    I really like the multimodal model support in Ollama, llava is a great model to try and runs on not much RAM.

    • @Thuvu5
      @Thuvu5  Před 3 měsíci

      Thank you Oliver! I would absolutely not mind making videos until I retire though 🤣. The multimodal support is interesting, I haven't tried it out yet but will look into those models a bit more 🙌🏽.

  • @babithganesh
    @babithganesh Před 3 měsíci

    Well explained ❤

  • @lionelshaghlil1754
    @lionelshaghlil1754 Před měsícem

    Thanks, That was inspiring indeed :)

  • @RobertLJ11
    @RobertLJ11 Před 2 měsíci

    This is a great video.!I learned a lot Thank you so much! 👍🎁🎁

  • @kcm624
    @kcm624 Před 2 měsíci

    Awesome video, learned a lot of new tools and want to try this out.
    For the dashboard, wonder if using Excel would be easier? Not sure.

  • @bhavyajain3420
    @bhavyajain3420 Před 3 měsíci +1

    That's awesome. I would also use Llama to write the code for generating plotly charts/dashboards haha!

  • @anassalahel-din8934
    @anassalahel-din8934 Před 3 měsíci

    thats a awsome vid thanks 🥰

  • @aitech4future
    @aitech4future Před 3 měsíci

    I was wondering where I listened to this music. Amazon learning has this background music. Thanks for sharing :)

  • @pg2286
    @pg2286 Před měsícem +1

    pretty cool work

  • @palakgoel5656
    @palakgoel5656 Před 2 měsíci +1

    Great video like always Thu! You never fail to fascinate me with your content as you make Data Science seem so fun to experiment with! Do you happen to have experience with the Bloomberg Terminal or any project idea to do using it? Would be amazing to know what you think of it! 🥰💛

    • @Thuvu5
      @Thuvu5  Před 2 měsíci

      Thank you for such kind words! No I haven’t had the chance to try out Bloomberg Terminal. It’s perhaps worth looking into for a future video 🤔

    • @palakgoel5656
      @palakgoel5656 Před 2 měsíci

      @@Thuvu5 excited and hoping to have a look at it 💫💕

  • @etutorshop
    @etutorshop Před 7 dny +1

    OMG this is inspiring I always wanted a 3rd party view about my expenses without loosing control of my data and this video hits the nail on the head.

    • @Thuvu5
      @Thuvu5  Před 5 dny

      So glad to hear! Good luck with your project 🤗

  • @atenciop123y
    @atenciop123y Před měsícem

    Thanks again for another wonderful video. Ollama is now available on Windows as a preview. I used that preview version on the solution you shared here and it worked great! 🙂
    Can you recommend a tutorial on the panel library? Thanks in advance.

  • @Szlakier
    @Szlakier Před 3 měsíci +1

    Thank you! 🦙

  • @GeorgeZoto
    @GeorgeZoto Před 2 měsíci +1

    Excellent video and practical application, you didn't get to cover pydantic much which solves a current challenge with LLMs. As for the dashboard, maybe another framework or approach with less or no code could be be more efficient :)

  • @KennyPyatt
    @KennyPyatt Před 2 měsíci +1

    Fantastic video

  • @Jonathan-rm6kt
    @Jonathan-rm6kt Před 3 měsíci +2

    Cool project! I'd like to try it myself. One interesting idea is to have the LLM generate a memo field for each transaction (which can be controlled via prompting). Then by embedding these and doing hybrid retrieval, you can search in natural language as well as by metadata for transactions.

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +1

      That’s an interesting idea! Would love to see how well the retrieval works 🤗

  • @youthresearches
    @youthresearches Před 3 měsíci +2

    As always, high-quality content from a highly competent woman!

    • @Thuvu5
      @Thuvu5  Před 3 měsíci

      That's so kind of you, I'm trying to be ;)

  • @fatimaafifah2492
    @fatimaafifah2492 Před 3 měsíci

    love your videos

  • @shafiqahmadzai3262
    @shafiqahmadzai3262 Před 3 měsíci +1

    Great stuff 👏🏻

    • @Thuvu5
      @Thuvu5  Před 3 měsíci

      Thanks for the visit! ;)

  • @JaiShriKrishna536
    @JaiShriKrishna536 Před 3 měsíci

    Thanks for this video

  • @ayoubtaoufik6843
    @ayoubtaoufik6843 Před 2 měsíci

    Thanks for the video! It was very clear and helpful. I'm curious, why didn't you use the Langchain CSV agent? Have you tried it before? If so, did you find it to be overkill or not helpful for this case? I'm new to Langchain and LLMs, so this video was incredibly informative. Thanks again!

  • @sampatht
    @sampatht Před 3 měsíci

    Great Work.

  • @aelloro
    @aelloro Před 2 měsíci

    Thank you for a great video! Liked and subscribed! I have a small question: how do you validate the correctness of splitting into categories? I mean, how do you automate verification, that all records got correct corresponding categories, not just random 30 out of several thousand records?

  • @chaos_monster
    @chaos_monster Před 3 měsíci +1

    This is a great inroduction to Ollama

  • @LukeBarousse
    @LukeBarousse Před 3 měsíci +12

    "Although, as you can see I can't retire anytime soon" 😂😳
    Thu, this was a pretty ingenious way to label data; one of the biggest part of our time is data cleanup and this helps speed it up

    • @LukeBarousse
      @LukeBarousse Před 3 měsíci +3

      out of curiousity, why did you choose ollama? (vice something like LM studio)

    • @Thuvu5
      @Thuvu5  Před 3 měsíci +1

      Haha, yeah I thought I'd saved much more.. 😂 Definitely, I hope to explore more analysis use cases for local LLMs. I heard about LM studio but somehow I just like the setup with Ollama better. I guess they are very much the same in the backend.

    • @FaruqAtilola
      @FaruqAtilola Před 3 měsíci +3

      Trust me, clicking the video and scrolling through the comments, I was anticipating your comment to be at the very top😅

  • @PhilSmy
    @PhilSmy Před 2 měsíci +1

    Great video. Very inspiring. Also...I used to live in Amstelveen (20+ years ago!). Funny to see that name in there.

    • @Thuvu5
      @Thuvu5  Před 2 měsíci

      Oh haha, the world is small! 😀

  • @SamFigueroa
    @SamFigueroa Před 2 měsíci +1

    I've noticed that most LLM understand that you would like a CSV formatted output and you use that to get more consistent output.

  • @user-vu4or4ih8p
    @user-vu4or4ih8p Před 2 měsíci

    Great Video! Still happy with Panel? Tried Gradio?

  • @davidtindell950
    @davidtindell950 Před 3 měsíci +2

    I just read about the latest Meta LLAMA model that is supposed to be better than GPT4 for s/w dev!
    I hope that we can run it as a LOCAL LLM ! Thank You for this timely vid.
    ...

    • @Thuvu5
      @Thuvu5  Před 3 měsíci

      Ooh that’s pretty cool! 🤩 So great to hear many models are approaching GPT4 capabilities 🤯

  • @ilyayy
    @ilyayy Před 3 měsíci

    Nice showcase of that it's ok if things don't work out first try - there's another model / another try :)

  • @60pluscrazy
    @60pluscrazy Před 2 měsíci +1

    Wow 🎉🎉🎉thanks 🎉🎉🎉

  • @captainbr0st.189
    @captainbr0st.189 Před 3 měsíci +1

    I am amazed

  • @zabashhd459
    @zabashhd459 Před 3 měsíci +2

    Thia is amazing

  • @xugefu
    @xugefu Před 3 měsíci +1

    Thanks!

  • @abhisycvirat
    @abhisycvirat Před měsícem +1

    Great video Thu Vu. I have a question regarding training with our own data. You mentioned model to create a custom one, can we add sample data in the model ex some 30 50 rows of input and expected output?

    • @Thuvu5
      @Thuvu5  Před měsícem

      Hey, yes I believe you can do that in the model file