Data Dashboard App in Django || Tutorial 2020 || Adding Graphs || World Map
ฝัง
- เผยแพร่เมื่อ 12 พ.ย. 2024
- Django is a web framework in python, it makes easier to make web applications, in this video I will share the reasons to use Django and would give an overview of all the topics which I will cover over a period of time. I also shared a quick demo on how to get started and getting comfortable with Django and create a web application in no less time.
00:05 Description of the Problem statement
03:42 Datalink
05:18 Backend data manipulation in Notebook
07:36 Creating Django App
11:04 Adding Bar plot in App
16:00 Passing values to javascript code
27:47 Adding buttons for countries
30:55 HighChartz in the dashboard for world map
42:00 Adding if else statement in django
43:30 Adding line plot in dashboard
49:30 Summarizing the project
Chartjs: www.chartjs.org/
Highcharts:
www.highcharts...
jsfiddle.net/g...
Corona Dashboard
who.sprinklr.com/
Apex Charts for heatmap
apexcharts.com...
The course material is in github repo:
github.com/sha...
Please subscribe to my channel by clicking on the link: / @technologyfornoobs
and i was searching why anyone hadn't done this graph,chart implementation on django..now here it is.thanks bro. Subscribed
Glad, it was helpful!
Thank you SIr. 1st Class tutorial. Clear, detail & wide coverage
You are most welcome
thank you so much Ii have watched so many videos before and everyone was using ajax. this really helped me a lot.
Glad it helped!
Really Helpful video bro!! Thanks !! Keep helping and growing !! great work dude
Thanks, will do!
This is a truly great video with real data! Many thanks for this great work!
You're very welcome!
"Mostly javascript" and you "don't know javascript".... so glad I have friend (I don't intended to learn it since I hate it, I just asked help from my friend who know javascript for something like that lol)
True! Great you have a friend!
Nice topic please make more videos with djangodash
Great suggestion!
Yea that would be great, there kind of no resources to integrate Django and dash. There is one by pip install channel , but that doesn’t seem to be the right way
Nice. Thanks for tutorial.
You're welcome
This tutorial is gold, tks u.
thanks!
amazing video. thank you so much, it really helped me a lot. Cheers!!!
Glad it helped!
Thanks a lot! Really good and simple explanation! Very well done!
Glad it was helpful!
Can u provide this charts.js line graph link that u inspect
How to make these graphs and widgets customize able for end users...like end users can change the size of widgets according to their needs... Just wanna know..???
That's JS functionality, either you can write it or use some pre-existing library which offer this functionality, mostly are paid, the best you can look is D3.js
Osm 👌👌👌👌videos n explanation
Thank you so much 😀
Hi ..Can we use Pycharm instead of Jupyter notebook...??
You may if you are comfortable with it.
Just the way I like it! Really cool tutorial! Thanks bruh!
Glad you like it!
Very impressive, good job!!!
Thank you very much!
This is a great video. I have one question tho.I'm working on web application that analyziz data and provides graph to see in real time the progress and location of the parts in production. 2 analyse the data and provide a dashbord of the late parts. So I want to use python as a programming language and django framework. the problem that I am a beginner in this field and I would like to ask whitch dataframe should I use and how start. Need help
You can check my real time application in django and get some motivation, but I tell you its a long way to do this, as real time has its own challenges.
This was so helpfull! Thanks and keep the good work!
Glad it helped!
Thank you so much sir ,this was so helpful.i have a question that how can we get the dataset input from admin panel manually using spreadsheet.
I am not sure about your question, but data set input from admin seems like a new feature which you need to add, like download data
this is really interesting. I want to apply this in architectural design.
Go for it!
Is there a way to implement a user filter? For example, the user sees data based on his country or one of the dimension fields in the database.
yes that can be implemented using authorization and authentication feature, or maintain a table with user and filtration and use it during rendering
@@technologyfornoobs could you give examples what tools or library i can use for this purpose?
No 3rd party tool, its just the logic you need to implement its kind of a filter which you will add in your backend logic
please tell me that you have programmed this in pycharam
vscode.
Fantastic job!Subscribed.
Thanks for the sub!
Hi, Your lectures are really useful to create dashboards using plotly dash in efficient way. Just have one questions ? How we can export these dashboards either in PDF or PPT using dash?
for sure there would be some support or custom JS which can do it for you.
Great one!.. I implement as it is, but 1 question In the highchart of world map is it possible to edit, on the top right corner we are having 3 line, inside we have option to zoom, print etc, so need to edit it where it has to be done?
Not so sure, as its a 3rd party library, but may be if you know Javascript then try it out
Thank you so much! Great learning i had...i have a question Inside high chart world map, if we click on any country on the map is it possible to go to next page? Can you please help me on this , will be grateful if it's working.
That depends on the library, not sure if the one I used could be used in such case, but clicking on it doing some action would need some serious Javascript coding
@@technologyfornoobs thank you so for your reply..sir if it is possible, could you please try from your end once, it will be very very helpful. Thank you sir.
Awesome, keep it up. Subscribed!
Thanks for the sub!
can we do the same with using oracle DB life time ??
Thanks for helpful video
live**
@@jalil781 I do not have experience with oracle DB much, but even I couldn't find a way to get data from DB real time to Django rather than sending it from the websockets to DB.
@@technologyfornoobs Thanks for the prompt reply, but what I need is just if we can connect the django to the oracle DB and the reset I will handle it
So what I need is just the connection command
Thanks
Can we use this for any other dataset other than Covid19?
yes, but you have adjust the data accordingly
Excellent video sir.
I wanted to know if there was any way to create a map for India using some map chart in js.
See if this works, there would be so may, even it could be added in the chart which I used as well.
www.zingchart.com/gallery/interactive-javascript-map-of-india
Hello Sir, How to rectify the problem ""
please help me out
Could you please try cloning the repo from github and check if my app works, there must be some problem in your url may be spelling check in the websocket url.
@@technologyfornoobs after cloning the repo, I ran the project but getting the same........................... by retrying the 5-6 times continuously, then the page is being fetched. I think it is taking a lot of time to successfully fetched.
Can you please tell me how to make a stack chart here and add slicers/filters? Its quite urgent and I found this tutorial really really helpful.
If you want to add filter slicer as an independent you need to just add those as condition in your functions and fill them as a form in UI, the real problem will come when you have to adjust all the conditions in your graph function and adjusting the data on every request.
@@technologyfornoobs yes, that's what I need.. multiple slicers affecting charts.
Hi, I have data from query and converted to pandas pivot table as per my requirement. I have to plot the data from pivot table data. How can I achieve this.. Please help me or make a video on this.
Sure, added in the to do list.
@@technologyfornoobs Thank you
Technology for Noobs Hi
hey, how can i connect with you? i'm quite stuck in the filter part.. would be really helpful if we can connect once.
Email me at techfornoobs01@gmail.com
22:15 When I try to pass the values for labels and data, the graph doesn't generate. Do you know an alternative solution to this? Thanks
graphs will get render using javascript library or check about some html graphs, but still I would recommend to debug, so not loose hope here, it takes a while to get the actual error and it all seem correct. check using inspect in browser whether data are reaching to graph or not first, and then check if data is safe to be send for javascript from django. the usual mistakes name of chart, some weird datatype passed unknowingly, there are some issue with integer and decimal values, check all this first.
@@technologyfornoobs I was able to figure it out by debugging through the console. It turns out the data wasn't being sent correctly to the js file because I was importing the js file into my html code as a script tag. I tried with the html and js code both in the same file and it finally worked. Many thanks for all your videos!
Super...... thankyou sir
Welcome
Thanks for this vid bro!
yo! glad you liked it
Hi, Thank you for your valid video and continues support, I would like to create in django a drill down table where if I click on specific cell (Data) the same table will auto refresh with the drill down dataset and will reflect this data on the bar chart.
I appreciate if you can help in this
That is more of a Javascript functionality
I will give it a try.
@@technologyfornoobs Thanks for your prompt reply and I believe you can do it :)
Great video! Nice explanation. My only question is how long did it take for you to come up with all this? (Not when you made the video but when you were coding this for the first time.) Thank You.
Thinking of an example takes a lot time than writing the code.
Hi Sir..the video was very informative I have some doubts please do reply.
Can we use python libraries for creating visualisation?If so please explain that.
How to embed Power BI dashboard in django is that possible I found a code in the same using flask.
If you have found in flask then similar or same could be used in django as well.
@@technologyfornoobs But I couldn't find one in django...
I am little confused now, you need to embed Power BI or add visualization in your app? If embedding Power BI is the task, you will get help from Power BI docs.
And if you want to use a library to add visualization in Django Templates, that's not possible, that's what the video is about.
great content and video
Glad you enjoyed it
How can I add data prediction on this???
that depends on your usecase, if you can include it in your views that's great else push it in some database and show graph
My project cant import pandas into views for somereason. Can anyone help?
Is it installed?
Sir, how can i import excel file from my computer in django to make the dashboard on webpage
you can use pandas library to read excel and then use the dataframe based on your requirement.
this was awesome
Thanks!
This is a great video. Thank you for taking time to make this. I do have one question tho. What if I have a complex data analysis model that I've written in another Python file (analysis.py) that outputs result in the format of dataframe. How would I use that dataframe and integrate it with Django in order to display in my dashboard?
Either use that code inside the django, or dump your data in any database and use it in django
Well structured training. This is greatly appreciated. Can you also share on passing country and infected count to a table in html.
I will try to just do Populating table in UI using Django, will that work?
@@technologyfornoobs Absolutely. That should be helpful
The video: th-cam.com/video/fDOl5WQiKJ0/w-d-xo.html
sir, i am not able to plot my data after converting in json.Please help me
Check about the safe option, might be that reason
would you share you github link for this project
github.com/sharmasw/DjangoDashboardCorona
Hi. Good stuffs. Any video on multi-select filters in Django App. Earlier, I also enquired on the same. TIA
Will update soon.
Great video! Can you also do a video of deploying a django app on a website? I mean a live website. Thanks
Great suggestion! need to subscribe to some cloud service then. will check and update, already consumed my free subscriptions of most of the providers :).
Hi could please let me know what knowledge do you need to have to do this project. Thanks
Python, javascript basic, html, django, graphs and a little hacky brain.
It's amazing sir, Thanks a lots and please move forward and make these types of videos and I also subscribe you sir ji, please make video.......... 👍
YO!
this is great
yo! glad you liked it
oh my god did not realise you could do that with pandas O.O
yo!
You need to add 00:00 to the timeline to make it easier for viewers to follow. Now chapters not showing
Thanks will keep it in mind.
Thank you for this tutorial! amazing work.
Question - what if you are pulling data from a database instead of a csv file?
You can, you can pull data from any script execution from the database, or use model component of Django to pull data.
Thanks bro... very helpful..♥️...
How can i contact you i need some help plz🙏
Techfornoobs01@gmail.com
@@technologyfornoobs I had mailed you.. Please check your inbox.. It's urgent
bhai kaaha se laate ho etna knowledge
Kuch gdbd हो गया क्या?
bro u left ur comma on korea "korea,"
thanks!
Good..but could have been excellent if done from scratch
Scratch meaning? by not using the graph libraries?
@@technologyfornoobs no bro..just could've merged first nd this video..btw the video was good..but as I m not a data scientist..I didn't understood backend..😅