How to Generate an Analytics Report (pdf) in Python!

Поделиться
HTML-код
  • Опубликовано: 16 сен 2024

Комментарии • 187

  • @KeithGalli
    @KeithGalli  3 года назад +38

    Hope you all enjoyed this video! If you have any questions, let me know here in the comments :)
    Also for a bunch of great classes be sure to check out Skillshare! The first 1000 people to use the link will get a free trial of Skillshare Premium Membership: skl.sh/keithgalli10201

    • @metameles5846
      @metameles5846 3 года назад +1

      Thanks a lot for this great tutorial. A bonus would have to add a crosstable data for example.

    • @nikhilprem7998
      @nikhilprem7998 3 года назад

      ruclips.net/video/PZgQkJSAP2g/видео.html
      I am stuck in the imaginary number can you solve it?

    • @JaveGeddes
      @JaveGeddes 3 года назад +1

      I was hoping to find a way to access BeautifulSoup results in html

    • @utkarshaattarde5272
      @utkarshaattarde5272 3 года назад

      It's super helpful. I have a question - I'm generating a report having header, footer and in body - a table with bar graph. The problem is table continues to 2nd page and overwrite with the header(starts from top ). Please help me with this. You can answer this question on Stack overflow website :- stackoverflow.com/questions/65987187/page-continuation-below-header-in-fpdf
      Thanks in advance

    • @utkarshaattarde5272
      @utkarshaattarde5272 3 года назад +1

      Please make more videos with fpdf lib

  • @tyswenson7542
    @tyswenson7542 3 года назад +6

    Dude, you read my mind with this video... it’s scary how much I needed this.

  • @johnwig285
    @johnwig285 3 года назад +7

    Wtf i didnt know that was possible. This channel is beyond awesome!

  • @hectormotsepe1581
    @hectormotsepe1581 3 года назад +7

    Keith Galli.
    You are the best bro
    Much love from South Africa

    • @KeithGalli
      @KeithGalli  3 года назад

      Appreciate the support! 🙌

  • @bidhanbhattarai8863
    @bidhanbhattarai8863 3 года назад +31

    You come up with the most interesting tutorials Keith.

  • @mapa5000
    @mapa5000 3 года назад +1

    I like the way you look for information and handle issues during your video. Excellent job.!!!

  • @ritwaj6791
    @ritwaj6791 3 года назад +2

    Damn finally someone came up with us, I was wondering in these times how did non-technical people understand the visualizations looking at code and also that's also not much appealing showcasing to this kind of people in a presentation meeting.

  • @anthonycamarillo5806
    @anthonycamarillo5806 3 года назад +3

    Thank you RUclips algorithm for putting this on my home page when I was getting ready to do intense searching on reporting!
    Also quick suggestion: instead of having to download the libraries each time maybe you can export a virtual environment to YAML file so people will automatically have the environment and all of the dependencies

  • @JasonMinhas
    @JasonMinhas 3 года назад +5

    Hey, Keith awesome tutorial! At 42:23 to remove leading "0" you can do "%#m/%#d/%y" instead. The "#" will remove leading "0"

    • @KeithGalli
      @KeithGalli  3 года назад +4

      Great suggestion! So I was going to do this, but I believe that date format is Windows specific. On Linux & MacOS the "#" needs to be a "-", so ultimately I decided to go with a solution I was sure would work on all platforms :).

  • @amirabdoll
    @amirabdoll 3 года назад +2

    Just letting you know that you are a champion and I have so much respect and love for you. I am following your post and immensely enjoying them. Keep the great work up.

  • @xavierfournat8264
    @xavierfournat8264 3 года назад +1

    Hi Keith,
    This were the best 49:14 minutes I spent this week...
    ...OK, maybe the second best 49:14, right after the time spent yesterday building play dough dinosaurs with my 2 y.o. son after a 1 week business trip. But you were really close from 1st place, I promised :)
    More seriously, absolutly stunning tutorial! Highly valuable and extremly clearly explained.
    Thanks for that !

    • @KeithGalli
      @KeithGalli  3 года назад +1

      This comment put a big smile on my face! I appreciate the kind words. I know I could never compare to building play dough dinosaurs with your son, but I feel honored to even come close :)

  • @kanefoster8780
    @kanefoster8780 3 года назад +9

    This is absurd! I was quite literally about to search on RUclips how to design and analytic report in Python. Great minds ey.

    • @ayencoscolfield3312
      @ayencoscolfield3312 3 года назад

      Wow Great minds! meaning you like it , why is it absurd then , i dont get

    • @kanefoster8780
      @kanefoster8780 3 года назад

      @@ayencoscolfield3312 Haha I meant it was an absurd coincidence such a video would be uploaded just as I started looking for it, and we were two great minds for thinking of the same idea at the same time

    • @ayencoscolfield3312
      @ayencoscolfield3312 3 года назад

      @@kanefoster8780 ok i understand now, cheers

  • @kewalmishra7870
    @kewalmishra7870 3 года назад +3

    Really grateful for ALL the content that you are putting up in this field. You have no idea how much these videos are helping me. THANKS A LOT!

  • @davidnguyen7160
    @davidnguyen7160 3 года назад +2

    I have so many projects lined up but keep getting caught up with your projects. Keep up the great work!

  • @Oceansteve
    @Oceansteve 2 года назад

    I watched this today last year and was only starting to learn Python for Data Science. Now I am using it for paid work. TY!

  • @mrmuranga
    @mrmuranga 3 года назад +1

    Amazing....thanks. Jumping right to my first pdf plots from tomorrow..greatstuff !

  • @DodaGarcia
    @DodaGarcia Год назад +1

    Thank you for this overview! I am especially impressed by the map plotting functionality, will definitely look into that.
    As someone coming from web dev, thought I'd suggest that it might be easier to, instead of trying to wrangle the PDF layout in the code, generate the report in HTML with the help of a utility CSS library such as Tailwind and then running a separate step to convert that into PDF. That would make it easier to generate a standard layout, and as a bonus would also give you the option to make the HTML version available.

  • @raulsiqueirayt
    @raulsiqueirayt 3 года назад +3

    I've been looking for this video a long time, thanks for that, best content ever!

  • @faizalimuhammadzoda4731
    @faizalimuhammadzoda4731 3 года назад +1

    Very useful tutorial. Thanks. And greetings from Central Asia.

  • @AbhishekSharma-hy4nl
    @AbhishekSharma-hy4nl 3 года назад +3

    I love ur videos bro... because of u I'm able to qualify an data analyst exam also gave some interviews didn't get any hope get in future but anyway thanks alot..❤️❤️ love from India and also make some videos on azure and aws..

  • @larflores1
    @larflores1 3 года назад +3

    This is great! Thanks for all the hard work and effort you put into these tutorials. It really comes through how thoughtful everything is on video. Loved it!

  • @Evan_242
    @Evan_242 3 года назад +1

    Very very useful, I just get a job in Data Science and I'm sure this kind of report will be very handy :) Thanks Keith

  • @money_wins_controls
    @money_wins_controls 3 года назад +2

    You are my hero
    Not all heroes wear caps!

  • @kbstar12
    @kbstar12 3 года назад +1

    Thanks Keith! I was able to implement this into my own work this week. Good stuff keep it coming!

  • @alpheim4129
    @alpheim4129 Год назад

    Thank you so much. With your help I have automated reports on my website❤️

    • @KeithGalli
      @KeithGalli  Год назад

      Awesome! You are very welcome

  • @chrislee7704
    @chrislee7704 3 года назад

    Dude thank you!! I'd been searching for a way to generate slick report with python for some time and this has everything I need. Your video also explains the process and features far better than articles I have found.

  • @matiastorres392
    @matiastorres392 3 года назад +1

    Amazing that you Start to show us some of cloud service!! Thats its a must on this days!!! Thanks a lot

  • @NoahElRhandour
    @NoahElRhandour 3 года назад +2

    I'm learning python and your tutorials are among the best I've ever seen. thank you sooooo much and greetings from Germany x)

  • @Trazynn
    @Trazynn 3 года назад

    You deserve better than Skillshare man.

  • @dr.girthmuffin8584
    @dr.girthmuffin8584 3 года назад +1

    Weepee! what a great vid u have! just the right size for me! I hate when they try to cram too much into short vid. OUCH!
    Anyways! I do wonder though... should I use PDF for my wedding invitations or is more for legal documents?
    keep up great fun!
    -Doc

    • @KeithGalli
      @KeithGalli  3 года назад +1

      Good to hear from you again Dr. Girth Muffin! It's been a while. Yeah I definitely recommend this method for wedding invitations. You can even go as far as using an API to automatically send them, wouldn't that be neat! xoxo keith

  • @hannukoistinen5329
    @hannukoistinen5329 2 года назад

    Some statistic courses may should be taken!! Nice keyboard working anyway:)!!

  • @duonghue8388
    @duonghue8388 3 года назад +2

    Thank you for your work. It's super helpful. Hope to see more of this

  • @SoutheastSam3
    @SoutheastSam3 3 года назад

    I needed this. Don't want to scroll through a Jupyter notebook when showing analysis at work.

  • @nickt423
    @nickt423 3 года назад

    Keith, thanks for making these videos. They have really helped me!

  • @GnosisArizona
    @GnosisArizona 3 года назад

    Keith - thanks for this video. It just arrived exactly when I needed it! Big thanks!

  • @oenriqueg
    @oenriqueg 3 года назад

    Booom! 🤯🤯🤯🤯
    Thank you very much Keith!!
    I have a lot of things to learn and practice, you are amazing. 🙌🙌🙌🙌🙌🙌

  • @itbeat7899
    @itbeat7899 3 года назад

    You are awesome! I love you are going through each part of the script

  • @cash80flow
    @cash80flow 3 года назад

    I am always looking forward to your tutorials. Another great one👍👍

  • @rodrigoolanda9176
    @rodrigoolanda9176 3 года назад

    Dude, you're the best! Thanks for sharing your knowledge!

  • @TanayaAmar
    @TanayaAmar 3 года назад

    Love the topic! Thanks so much!! 🤩 And the hairstyle looks great to me - not sure why some folks have a problem lol

  • @Magnus.Ek.1
    @Magnus.Ek.1 3 года назад

    I use Ananconda and set-up an environment that I named ´covidMap´. In that env with python3.8 I installed all the dependencies. I got the report to run instantly. Next move is to see if I can get it to work with an European map. Thanks for the inspiration!

  • @abhishekgautam478
    @abhishekgautam478 3 года назад

    man your all videos are awesome. thank you.

  • @Gamma3
    @Gamma3 3 года назад +1

    Thanks! This is the best channel

    • @KeithGalli
      @KeithGalli  3 года назад +1

      appreciate the support 🙌

  • @e-normous
    @e-normous Год назад

    Thanks a lot for this very helpful tutorial. Keep up the good work!

  • @seanmackenziedataengineering
    @seanmackenziedataengineering 3 года назад

    Pretty cool combination of tech to accomplish this! The R crowd are pretty spoiled with R markdown but for those who prefer Python this is a neat way to do it.

    •  3 года назад +2

      Yep. This type of exercise is hard to do in python. R with Rmarkdown is so much easier.

    • @KeithGalli
      @KeithGalli  3 года назад +1

      Agreed! This video was pretty heavily inspired by trying to find a Python alternative to R markdown

    • @БарометрАтмосферный
      @БарометрАтмосферный 3 года назад

      @@KeithGalli , and in RMarkdown you can use code chunks with Python code too.

  • @amanpatyal2187
    @amanpatyal2187 3 года назад

    Waiting for the second one....
    . Veeeerrry informative...

  • @patrickdamour1728
    @patrickdamour1728 3 года назад

    ❤️ content is constantly improving!

  • @ritwaj6791
    @ritwaj6791 3 года назад +2

    Also could you please make a git and GitHub full tutorial video explaining things like settings to opt while installing, cloning, and uploading the first project. T

  • @TheMISBlog
    @TheMISBlog 3 года назад

    Great Video Keith, keep up the good work

  • @mprencipe
    @mprencipe 2 года назад

    It would be very nice to have a tutorial on pythontex, too! There are no decent tutorials of this subject and, since your are very skilled in teaching, you would make the difference!

  • @web3global
    @web3global 3 года назад

    Great Efforts Brother !!!
    Keep the work up!

  • @Oceansteve
    @Oceansteve 3 года назад +1

    Top class content! faultless tutorials..

  • @brentsimpson3791
    @brentsimpson3791 4 месяца назад

    Awesome video! Thanks

  • @thyagovieira6283
    @thyagovieira6283 3 года назад

    Thanks Keith!

  • @foxwelly
    @foxwelly 3 года назад

    I love you Keith!!! Your tutorials are the bees knees!!

  • @yitongsun6702
    @yitongsun6702 2 года назад

    Thank you, it's really helpful.

  • @kacperm2909
    @kacperm2909 6 месяцев назад

    Very useful for learning python ;) ThX

  • @python360
    @python360 3 года назад

    Nice video, no need to try Skillshare with people like you making vids on YT!
    I have just been doing a price tracker with Python, using CRON to get data daily from Amazon, and save to MySQL and make graphs with Matplotlib.
    Is Plotly better/going to replace Matplotlib? In your opinion?
    Will be interested to see your next video!

  • @vitoroliveiradesouza4214
    @vitoroliveiradesouza4214 2 года назад

    Hi Keith! Awesome Tutorial, thanks for sharing it!
    Just one quick question: Did you realize you were clicking the rotate button instead of the update one at 26:30?

  • @islombabaev
    @islombabaev 3 года назад

    dude you could just initialized a venv before pushing the project to git and use pip freeze > requirements.txt so as to get all the required modules which were installed so as to make your project work. THEN, you could upload the requirements.txt to git and anyone cloning your repo could simply install all the modules used using pip install -r requirements.txt. Hope this was helpful!

  • @boundless-sher
    @boundless-sher 3 года назад

    Hey Keith, can you make a video about yourself as well? Talk about things like your job, how you got into MIT, what brought to programming and stuff

    • @boundless-sher
      @boundless-sher 3 года назад

      by the way I'm from Uzbekistan , and realy like your content!

  • @williamfarrell3822
    @williamfarrell3822 3 года назад

    Great job, Keith

  • @gopichand5717
    @gopichand5717 3 года назад

    Really enjoyed your video
    Thanks for sharing 🙂

  • @wewjoj
    @wewjoj 3 года назад

    This video is awesome!

  • @Voltaire321
    @Voltaire321 3 года назад

    pipenv is really nice for handling dependencies so you don't have to manually install modules

  • @nyasingajeff1789
    @nyasingajeff1789 3 года назад

    I see You Got a new haircut, But as Usual Fresh Content.. Awesome Content

  • @drikarts4816
    @drikarts4816 2 года назад

    Thank you!

  • @user-he5mq3fv1d
    @user-he5mq3fv1d 3 года назад

    thank you keith
    (from morocco)

  • @allanmarzuki5534
    @allanmarzuki5534 3 года назад

    Awesome tutorial Keith! How about LaTeX tutorial for the next video?

  • @barikam2m891
    @barikam2m891 4 месяца назад

    You are the best thank you.

  • @easy_coding0
    @easy_coding0 3 года назад

    that is Mr i liked the way you rxplain things

  • @HardCloserTV
    @HardCloserTV 3 года назад +1

    Hello Keith ! I'm having problems importing the fpdf library
    ImportError: cannot import name 'FPDF' from partially initialized module 'fpdf' (most likely due to a circular import) help please 😪

  • @hosseinramezani1428
    @hosseinramezani1428 3 года назад

    Thank you for your work

  • @AgentJRock805
    @AgentJRock805 3 года назад

    you can use a minus sign to make single digits instead of using replace. ('%-m/%-d/%y')

  • @biohoo22
    @biohoo22 2 года назад

    "shift all of this in with tab" just triggered us Python spacists.

  • @Magmatic91
    @Magmatic91 3 года назад

    Please make a video about a real world project in Data Analytics like the one you did on Sales Analytics. Thanks.

  • @andymartinez5407
    @andymartinez5407 3 года назад

    Keith, you are a fucking rockstar man! Greetings from Argentina bro!

  • @SHABAREESH99
    @SHABAREESH99 3 года назад

    Thanks you helped me so much in python

  • @ivannordnesdahlberg6368
    @ivannordnesdahlberg6368 3 года назад

    Thanx for another great tutorial. Can you also show an example where you include some nice tables in the PDF report?

    • @KeithGalli
      @KeithGalli  3 года назад +1

      Glad you enjoyed the video! I might create some examples with tables at some point, but until I do that this answer on stack overflow might be helpful: stackoverflow.com/a/39358752

  • @yashkaran1
    @yashkaran1 6 месяцев назад

    Thanks man!!!!

  • @nickt423
    @nickt423 3 года назад

    Some of you may need to install the fpdf package with the following command:
    pip install fpdf

  • @devjesusc
    @devjesusc 3 года назад

    Awesome!!

  • @rezashams7434
    @rezashams7434 3 года назад

    Attractive as expected 👍

  • @tophattommy2
    @tophattommy2 Год назад

    Do you have a video covering how you created the maps? I recognize that you mentioned the "Create COVID-19 Map Animation..."

    • @tophattommy2
      @tophattommy2 Год назад

      But I have yet to find a written tutorial that actually works.

  • @starlabs7775
    @starlabs7775 3 года назад

    nice tutorial bro!

  • @israeldeandrade4022
    @israeldeandrade4022 Год назад

    thank you

  • @ajdevz1067
    @ajdevz1067 3 года назад

    Thanks for this python tutorials

  • @hansomary3827
    @hansomary3827 3 года назад

    Great, good job

  • @crippysteps6273
    @crippysteps6273 3 года назад

    Yes

  • @afgaco
    @afgaco 2 года назад

    GRACIAS!

  • @marcelocampos665
    @marcelocampos665 Год назад

    Nice!

  • @pedrobarros9444
    @pedrobarros9444 3 года назад

    thanks keith uber!

  • @spyxfam
    @spyxfam 3 года назад

    Love your vid :) Is it also possible to add other font family like Verdana?

  • @abhi_rgr
    @abhi_rgr 3 года назад

    Just tried it. Were you able to include a paragraph? The cell/text function are not accomplishing this for me.

  • @swm7f137
    @swm7f137 2 года назад

    can we use this package in dash plotly please advice
    and thank you so much for your hard work

  • @vasoochigava5213
    @vasoochigava5213 2 года назад

    thank you for your awesome channel, Big fan. But sincerely why do we need to do it this long in python if we have power bi? that is way easier than this isn't it?

  • @SpanishJohn
    @SpanishJohn 2 года назад

    Hey Keith...trying to get Ur tutorial further but can't manage to use custom fonts...any way you could go deeper?

  • @GOTTT
    @GOTTT Год назад

    Hey Keith,
    Amazing video! Really well explained and helped me out a lot here.
    My problem is that the pdf generation is taking forever!
    Even just 1 image. Do you know why this could be?

  • @ericbi8338
    @ericbi8338 3 года назад

    Keith, you are so cool!

  • @user-nl6vf1cg2s
    @user-nl6vf1cg2s 3 года назад

    thank you so much. :)