Тёмный

How to Create Interactive Charts from Excel Data - Five Minute Python Scripts 

Derrick Sherrill
Подписаться 84 тыс.
Просмотров 37 тыс.
50% 1

Опубликовано:

 

11 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 40   
@kleanthisskoulikaris8053
@kleanthisskoulikaris8053 5 лет назад
As usual, you provide awesome educational content in easy to follow small-duration clips. Thank you so much Derrick!
@billelguechi5831
@billelguechi5831 4 года назад
Awesome bro great job keep going finally I've found something that make me stay at home away from the Corona Virus Cheers from Algeria North Africa
@legohistory
@legohistory 4 года назад
In Germany we say that you are a "Ehrenmann"! Thank you very much!
@jadenataylor
@jadenataylor Год назад
This video has been spicy helpful.
@jairoj.ninoperez6390
@jairoj.ninoperez6390 5 лет назад
Great video. Straight to the point. You've become my go-to source for spreadsheet -python matters. Keep it up! One question tho: You called go.scatter but the graph produced looks like a line chart. What am I missing?
@CodeWithDerrick
@CodeWithDerrick 5 лет назад
Thanks for the kind words! 😄 you can use plotly’s Scatter function for both lines and scatters (A little strange to me as well, haha) if you want a scatter all you would need is a keyword argument of mode=‘markers’ in the Scatter function
@appliedstatistics2043
@appliedstatistics2043 4 года назад
Thank you!
@winniepooh2533
@winniepooh2533 2 года назад
It was just the video I was looking for..Great.. love this video
@MohammadRezaMokhtari_Robin
@MohammadRezaMokhtari_Robin 3 года назад
Hey Derrick, thanks a lot for this wonderful video!
@jklfaav
@jklfaav 4 года назад
This video is so nice and helped me very much! Thank you! Keep doing amazing videos!
@GabrielIchiro
@GabrielIchiro 5 лет назад
very interesting and intuitive videos, keep going!
@JasonAvronSamuels
@JasonAvronSamuels 5 лет назад
Your vids are great!
@miguelramirez187
@miguelramirez187 3 года назад
Thanks man, it was really helpful
@vio-noob_6737
@vio-noob_6737 5 лет назад
Any advantages to using Seaborn instead of plotly? Or is it really just preference Also, another great video. Keep it up!
@CodeWithDerrick
@CodeWithDerrick 5 лет назад
Thanks for the kind words! Seaborn is usually my go to whenever there's already matplotlib being used elsewhere in the project. I feel like it's super easy to integrate in those cases (probably nothing more than personal bias though). Plotly does awesome in my opinion for the interactive stuff and when it comes to moving graphs online or hosting graphs on their site
@ProCoder2007
@ProCoder2007 5 лет назад
@@CodeWithDerrick Plotly is very nice. But I also like Bokeh :)
@sainagabharat79
@sainagabharat79 4 года назад
Great. Thanks a lot bro. Channel Subscribed ;)
@robertcliffort2354
@robertcliffort2354 2 года назад
great.
@k2icc
@k2icc 3 года назад
Very nice. I am assuming that if I will also be able to plot a WMA for example, as a technical indicator on the .html chart. Also, I love the idea of posting it to a website instead too. For example, I can save it on my local website folder and upload to site via FTP, or maybe this can be sent directly there. Will check on it. Nice to test with fresh downloaded data too. Thanks.
@henkbroam3747
@henkbroam3747 Год назад
Would you recommend this for super large files with almost a million data points? and not, what to use instead ?
@rosalyna_24
@rosalyna_24 2 года назад
is it possible to add that chart in the same excel file ??
@youtubewatch3981
@youtubewatch3981 2 года назад
hi bro, thanks for your video .it helps alot. if i wanna show sales, revenue, profit in the same charts. how to do it ?
@mikekaspari1357
@mikekaspari1357 2 года назад
Great video. Where can I download the excel file for practice?
@nirajmunot6451
@nirajmunot6451 3 года назад
Hey, Thanks a lot for this video. Can you please tell me how can I take data from a particular Sheet in the excel?
@jeffleigh491
@jeffleigh491 4 года назад
Dude, You never ever include the Excel files with the Tutorial
@etudesmpaveca.b.babdelghan4014
@etudesmpaveca.b.babdelghan4014 2 года назад
Hi, thanks for the video but I can't really make it work, I think there is a problem with the pandas version ********************************
@adl8595
@adl8595 5 лет назад
Nothing showed up after I ran fig.show(). Did I do something wrong? from matplotlib import pyplot as plt import pandas as pd from plotly import graph_objs as go excel_file = "Python_Practice_Chart.xlsx" df = pd.read_excel(excel_file) data = [go.Scatter(x=df['Date'], y = df["RN"])] fig = go.Figure(data) fig.show()
@CodeWithDerrick
@CodeWithDerrick 5 лет назад
Hey Adele! Do you get an error in your terminal? It might be opening to a browser window you aren’t expecting it to if there’s no error code
@trungduhuynh2154
@trungduhuynh2154 4 года назад
Hi Derrick, If I used Dash Plotly library to run demo , Could I output offline html file as your, I also did but Couldn’t, so how to share localhost for my teammate view chart? Big thanks
@aaronbell759
@aaronbell759 3 года назад
can plotly render html strings or .svg files? I need to send this to an airtable data base before a website picks it up
@djmmxd
@djmmxd 4 года назад
Great share, thanks! Is there a way to insert that html output into a ppt file, in order to create an interactive graph in a presentation? Btw, which editor are you using in the video? Thanks in advance
@CodeWithDerrick
@CodeWithDerrick 4 года назад
Thanks! The editor I'm using is Atom (atom.io). As far as working with ppt, I'm not really sure but that seems like a great use case. I believe powerpoint does allow javascript (which is all that these interactive charts are), but honestly not sure. Interested to know if it does if you get it working!
@AwB
@AwB 3 года назад
Are plotly charts mobile friendly?
@afiyaperween6810
@afiyaperween6810 2 года назад
Are you running it in Linux box
@azizee
@azizee 3 года назад
sir, do you have video how to make table from excel data and show it on browser?
@snakesnarroz
@snakesnarroz 5 лет назад
Can you show how to plot several columns - I guess an array of dataframes?
@veerab907
@veerab907 4 года назад
ImportError: cannot import name 'graph_objs' from partially initialized module 'plotly' (most likely due to a circular import can you help me to solve this error
@Ipatiouk
@Ipatiouk 5 лет назад
Thank you ! Could you help with automation ? Automatically grab data from google analytics and to write it to the cloud google sheet.
@CodeWithDerrick
@CodeWithDerrick 5 лет назад
Great Idea! I'll see what I can put together!
@Juliokongguerra
@Juliokongguerra 3 года назад
He looks like Mr. Robot
Далее