SQL + Python: Master Data Analysis and Create PDF Reports

[@CodingIsFun]

*Thanks for watching! What's your favourite data analysis tool? Excel, SQL, Python, ... ? Comment below* ⤵

[@jc1263]

I want to learn them all

[@-molhem7659]

Good evening, genius, I am following you from Egypt and I need your help in a very important matter for my work, I have a big event and a lot of visitors have been registered to attend this event, I have a very large number in Excel sheet, and now I have created a QR for each visitor of them to record attendance while entering the event, and because I want to take each QR from the Excel sheet and paste it into the invitation ticket automatically, Can you help me because there is no time to do it manually

[@techme6053]

Python n R

[@prashlovessamosa]

SQL and Python

[@aniketnikam6958]

All sir 🙌

[@ricardo.alves.campos]

I think it's only you who is able to make a video with so much information in a short time but to explain in an extremely clear and simple way, all my congratulations for this video. 👍

[@CodingIsFun]

Thanks for the kind words and for tuning in, Ricardo! I'm glad you found the video useful. Your support means a lot to me! 👍

[@dev_apostle]

more tutorials like this please. love it . keep it coming

[@CodingIsFun]

Thanks for your feedback. Glad you liked it! ♥👍

[@sujungpark5764]

You're making a huge impact ! You made it easy to understand and you truly care about your subscriber who really need it 😮 Thank you so much 🙏

[@CodingIsFun]

Thank you for your kind words, Sujung! I'm glad my content is helpful and easy to understand. Your support means a lot to me! 😊

[@whatis_asis]

Excellent thanks. The SQL-Python videos are really helpful.

[@CodingIsFun]

Happy to hear that it was helpful; thank you for taking the time to leave a comment and for watching the video! 👍

[@sudharsananss4511]

Its impressive and amazing. You are really rocking and thanks a ton for your efforts!!!

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️

[@jimmymahoney11]

Loved the video! Super informative and a hugely helpful resource. Excited to follow through and check out your other videos. Dankeschön

[@CodingIsFun]

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

[@relaxo3900]

Thanks a lot for making this available on youtube

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. :)

[@darkprince8259]

Loved it , learnt using python with sql which i need to use in my own projects

[@CodingIsFun]

Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍 Good luck with your projects! 🍀

[@williansuarez3988]

¡Excelente video! es bastante trabajo pero está impresionante, continúa así, saludos desde Venezuela

[@CodingIsFun]

Glad you liked this one too. Greetings to Venezuela! 👋

[@prashlovessamosa]

Thanks that's what I was looking for.

[@CodingIsFun]

Glad it was helpful. Thanks for watching! :)

[@NaveenKumar-bl1oy]

This is the video i was searching and waiting --- Writing SQL Queries in Python and -- can you pls make some videos again to Automate Excel Works of Employess do in companies -- like applying filters and to make summary according to sellers and those summary --- need to copy and then paste in new excel files as per sellers sheets

[@CodingIsFun]

Thank you for your suggestion! I will definitely create more videos on Excel automation in the future. Thanks for watching! 👍

[@hjertaker]

This is great! Thanks!

[@CodingIsFun]

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

[@miscoadre3250]

I love this tutorial, I'm exciting to recreate the same steps, but with Spark Python and using Machine Learning

[@miscoadre3250]

If You have same tutorials with Spark Python send me the link

[@CodingIsFun]

Thanks for watching the video and your suggestion. Currently, I do not have any PySpark tutorials.

[@solom465]

Great tutorial. I tend to stay away from packages to generate things like pdfs and powerpoint, instead preferring to use Quarto.

[@CodingIsFun]

Thanks for tuning in! I've actually never heard of Quarto before, but it looks pretty cool. If I've got some free time, I might just give it a try.

[@martinbottcher8206]

Hey Coding is Fun, those videos are really great and have pushed my workouput by a lot! Could you by any chance tell me which tool did you use for the ER-Model? Continue the great work!

[@poojagadve2528]

Very helpfull video 😊

[@CodingIsFun]

Glad it was helpful! -Sven ✌️

[@florianroeseler2404]

Just what I needed, thank you!!!

[@CodingIsFun]

Happy to hear that, Florian. Thanks for watching the video! :)

[@CringePajith]

You are great 😊

[@CodingIsFun]

Thank you so much 😀

[@megha_shah]

Very well explained.. just wow

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it. 😃👍

[@ordaflash]

Excellent video as usual. Is it possible to do a tutorial on a webapp that combines SQL/Pandas and Streamlit ? Thank you so much for your efforts !

[@CodingIsFun]

Happy to hear that you liked this video too. Thanks for your video suggestion! :)

[@leandrov07013]

Thanks 😊 🎉

[@CodingIsFun]

My pleasure! Appreciate you taking the time to watch and leave a comment. 😃😍

[@unusedTV]

My issue with this tutorial is that the most difficult part is actually glossed over: what does the business need to know? We can investigate whatever we want but we also need things that are actionable. So how do we decide what to look into further? Or are we just doing EDA? For example, you plot revenue per product. But what does that really mean? And if we don't account for price differences, margin, or co-sales (people buy X because they also buy Y) the insights are meaningless.

[@CodingIsFun]

Thanks for watching and your feedback!

[@davewhatever421]

Loved that video. I'm just getting started with python and SQLite. What software do you use for your entity relationship model? Thanks

[@CodingIsFun]

Thanks for watching the video, I used Luna Modeler to create my entity relationship model.

[@-molhem7659]

Good evening, genius, I am following you from Egypt and I need your help in a very important matter for my work, I have a big event and a lot of visitors have been registered to attend this event, I have a very large number in Excel sheet, and now I have created a QR for each visitor of them to record attendance while entering the event, and because I want to take each QR from the Excel sheet and paste it into the invitation ticket automatically, Can you help me because there is no time to do it manually

[@CodingIsFun]

Hey there! So, what's the format of the invitation ticket you've created? Is it in a Word doc, PDF, or something else? By the way, my name is Sven, not "genius" 😬

[@santoshadhikari9933]

How ould you export transformed data and its corresponding visuals in the same workbook at the same time?

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@santoshadhikari9933]

How would you export analyzed data in excel and its corresponing visuals in same exported excel workbook?

[@CodingIsFun]

Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!

[@daltonlimeira]

Hallo, Sven! Alles klar? What software and apps did you use? VS Code, Jupyter, Anaconda and SQLite Viewer? Do I need all of them or I can skip any?

[@CodingIsFun]

Hi. Yes, in the video I used VS Code, Jupyter Notebook and SQLite Viewer (website)

[@DataScienceCookbook]

where I can find Jupyter notebook source code

[@CodingIsFun]

Thanks for watching. Here it is: github.com/Sven-Bo/PDF-Report-Generator-Using-Python-and-SQL Happy Coding!

[@VayunEkbote]

Lets goooooooo

[@CodingIsFun]

First comment! BOOM!🚀

[@VayunEkbote]

@@CodingIsFun I comment the minute I receive your notifications 😂 for better reach

[@VayunEkbote]

Create a video on topics like "97% of python programmers don't know these tricks" Or "The only 5 pandas commands you will ever need" These always get the most views, something that the people think they will get immediate value addition from!!

[@CodingIsFun]

@@VayunEkbote I really appreciate your support - it means the world to me! 🙏 Thanks also for suggesting some video title ideas. I do my best to avoid overly clickbaity titles, but I'll definitely consider your suggestions for future videos. Thanks again! 😅

[@VayunEkbote]

@@CodingIsFun Grow with clickbaity content, expand with quality content!

[@dan.6398]

Hello, after inputting df = pd.read_sql_query(query, conn) I recive error ': no such table: sales. I double check and sales.db file is in current_dir. Do you have any advise ? Greetings

[@dan.6398]

Ok I have a solution :D

[@CodingIsFun]

Great to hear you fixed it! :)

[@Dam_FZ]

It's possible open a template pdf and insert the charts there?

[@CodingIsFun]

That sounds possible. Happy Coding! Cheers, Sven ✌️

[@anandshukla6174]

hello, i have doubt related to download mail attatchment in python

[@CodingIsFun]

Hello. Ok :/

[@963seeker]

I am quite new to plotly, does anyone know how to increase the padding in the 'Top Customers by Sales' chart xaxis title?

[@CodingIsFun]

Thanks for watching. You could add some padding to avoid the overlapping of the xaxis_title "Customer". Here is the code: fig.update_layout( title='Top Customers by Sales', xaxis_title='Customer', margin=dict(l=100, r=50, t=75, b=100), # Add padding to entire chart yaxis_title='Total Sales ($)', yaxis_tickprefix='$', )

[@JD_2]

great

[@CodingIsFun]

Thanks! :)

[@itsme9877]

I am using pycharm and the date option is not available in here.. Please help me

[@CodingIsFun]

Thanks for watching. Sorry, but I am not sure what you mean. Cheers, Sven ✌️

[@itsme9877]

@@CodingIsFun i have an attribute of data type DATE in my database and i am not able to typecast the entered value from gui into date data type, when i am inserting into the ms sql database

[@CodingIsFun]

@@itsme9877 Hard to tell from a distance without knowing your code. However, you could try converting it to a date object before inserting. from datetime import datetime date_str = "2024-03-17" # Example date string date_object = datetime.strptime(date_str, "%Y-%m-%d").date()

[@mazkaibil9108]

This is an amazing tutorial made simple. Thank you!

[@mazkaibil9108]

This is a full development cycle! Love your videos!

[@CodingIsFun]

Glad you liked the video and the example I picked. Thanks for watching and taking the time to leave a comment! 👍

[@paulodacorte]

Gigachad

[@CodingIsFun]

Thanks for watching the video!

[@rodrigolozanolucianez37]

Anyone else thinks that this guy face is actually a deepfake video generated by an indian guy who is the one talking??

[@CodingIsFun]

🤫 Don't tell anybody!

[@pardeepsingh2502]

This is one of the best channels you tube has ever recommended me..

[@CodingIsFun]

Thanks for watching and your kind words! :)