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
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. 👍
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
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!!
@@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! 😅
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!
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!
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!
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
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='$', )
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.
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
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" 😬
@@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
@@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()
*Thanks for watching! What's your favourite data analysis tool? Excel, SQL, Python, ... ? Comment below* ⤵
I want to learn them all
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
Python n R
SQL and Python
All sir 🙌
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. 👍
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! 👍
This is one of the best channels you tube has ever recommended me..
Thanks for watching and your kind words! :)
Its impressive and amazing. You are really rocking and thanks a ton for your efforts!!!
My pleasure! Appreciate you taking the time to watch and leave a comment. Cheers, Sven ✌️
more tutorials like this please. love it . keep it coming
Thanks for your feedback. Glad you liked it! ♥👍
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 🙏
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! 😊
Excellent thanks. The SQL-Python videos are really helpful.
Happy to hear that it was helpful; thank you for taking the time to leave a comment and for watching the video! 👍
Loved the video! Super informative and a hugely helpful resource. Excited to follow through and check out your other videos.
Dankeschön
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
This is an amazing tutorial made simple. Thank you!
This is a full development cycle! Love your videos!
Glad you liked the video and the example I picked. Thanks for watching and taking the time to leave a comment! 👍
Thanks a lot for making this available on youtube
My pleasure! Appreciate you taking the time to watch and leave a comment. :)
Thanks that's what I was looking for.
Glad it was helpful. Thanks for watching! :)
Loved it , learnt using python with sql which i need to use in my own projects
Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍 Good luck with your projects! 🍀
This is great! Thanks!
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍
¡Excelente video! es bastante trabajo pero está impresionante, continúa así, saludos desde Venezuela
Glad you liked this one too. Greetings to Venezuela! 👋
Just what I needed, thank you!!!
Happy to hear that, Florian. Thanks for watching the video! :)
Very well explained.. just wow
Thanks for the kind words! I am glad you enjoyed it. 😃👍
Very helpfull video 😊
Glad it was helpful! -Sven ✌️
I love this tutorial, I'm exciting to recreate the same steps, but with Spark Python and using Machine Learning
If You have same tutorials with Spark Python send me the link
Thanks for watching the video and your suggestion. Currently, I do not have any PySpark tutorials.
You are great 😊
Thank you so much 😀
Great tutorial. I tend to stay away from packages to generate things like pdfs and powerpoint, instead preferring to use Quarto.
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.
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
Thank you for your suggestion! I will definitely create more videos on Excel automation in the future. Thanks for watching! 👍
Thanks 😊 🎉
My pleasure! Appreciate you taking the time to watch and leave a comment. 😃😍
Lets goooooooo
First comment! BOOM!🚀
@@CodingIsFun I comment the minute I receive your notifications 😂 for better reach
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!!
@@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! 😅
@@CodingIsFun Grow with clickbaity content, expand with quality content!
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 !
Happy to hear that you liked this video too. Thanks for your video suggestion! :)
How ould you export transformed data and its corresponding visuals in the same workbook at the same time?
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!
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?
Hi. Yes, in the video I used VS Code, Jupyter Notebook and SQLite Viewer (website)
How would you export analyzed data in excel and its corresponing visuals in same exported excel workbook?
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!
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!
Loved that video. I'm just getting started with python and SQLite. What software do you use for your entity relationship model? Thanks
Thanks for watching the video, I used Luna Modeler to create my entity relationship model.
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
Ok I have a solution :D
Great to hear you fixed it! :)
I am quite new to plotly, does anyone know how to increase the padding in the 'Top Customers by Sales' chart xaxis title?
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='$',
)
It's possible open a template pdf and insert the charts there?
That sounds possible. Happy Coding! Cheers, Sven ✌️
where I can find Jupyter notebook source code
Thanks for watching. Here it is: github.com/Sven-Bo/PDF-Report-Generator-Using-Python-and-SQL
Happy Coding!
great
Thanks! :)
hello, i have doubt related to download mail attatchment in python
Hello. Ok :/
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.
Thanks for watching and your feedback!
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
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" 😬
I am using pycharm and the date option is not available in here.. Please help me
Thanks for watching. Sorry, but I am not sure what you mean. Cheers, Sven ✌️
@@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
@@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()
Gigachad
Thanks for watching the video!
Anyone else thinks that this guy face is actually a deepfake video generated by an indian guy who is the one talking??
🤫 Don't tell anybody!