How to do data analysis using AI with ChatGPT and the Noteable plugin
ฝัง
- เผยแพร่เมื่อ 8 ก.ค. 2024
- In this video, I explain the basics of how you can use ChatGPT and the Noteable plugin to do data analysis and visualization using artificial intelligence.
This video from Noteable explains some of the ways to get data into Noteable to use in ChatGPT:
• Get your data into Cha...
Blog post: www.chadskelton.com/2023/05/us...
Datasets: github.com/chadskelton/data/t...
Noteable plugin setup instructions: docs.noteable.io/product-docs....
![ภาพนี้ก็ฮาเหมือนกันนะเนี้ย #2 SS8 [ พากย์นรก MEME.EXE ] | easy boy](http://i.ytimg.com/vi/RMhUgxxD49Q/mqdefault.jpg)
We love seeing how you're using the plugin!
Thanks for taking the time to record this video and share it with the public, Chad! This could significantly increase our analysis performance using ChatGPT.
This can be a game changer for data teams that don't have a lot of time to do cursory analyses of all of their data sources, especially in higher education. Excited to explore this further!
Thanks, Chad - welcome to TH-cam. Keep at it! Found this very useful.
Thank you for contributing!
How simply you convey how insane all of this is getting. I'm in this space, but I could imagine even middle school kids just understanding data analysis thanks to you and ol' chatty bot. Thank you!
this tutorial is awesome, it helps me save time exploring concepts before going into the coding part.
Yes! More vids please! You’re better at this format than the vast majority of TH-camrs.
This stuff is blowing my mind. Complete gamechanger. Keep it up, Mr. Skelton. I find this presentation helpful (among other things) in how best to get my head around how these technologies will change society. What do you need a programmer for, if plain English (or Chinese, or Dutch, or Swahili for that matter) will generate code? More and more 'code' will be natural language. And the technology is getting better and better.
Really glad I found your channel. Thanks for the education and for sharing the data to follow along. (Had trouble getting it going but it is working now :) This is amazing.
Useful video!
😱 finally! Thank you! I've been looking for this daily
Cool ❤😂🎉 you nailed it mate. Thanks for this video.
Great content! Cheers
Thank-you for highlighting bike theft issue in Vancouver!
Your tutorial helped us sort through about a huge set of data points to extract significant data for business analytics. Also, Noteable folks (shout out to Dave) were extremely responsive to a couple of questions we had. Hope you keep doing more of these demos. Thanks a lot!
Really informational, thank you
Thank you my dude! You just saved me so much time in eda!!!
Thanks for sharing! I’ll definitely be playing with this!
Glad you enjoyed the video!
Great stuff, hope you keep it up!
Super cool, Thanks for the valuable info Chad...
Thank you for this! This is some pretty exciting stuff and can't wait to see where this goes. Some may say that it will replace a lot of jobs but I believe that if a person makes problem solving their career lifestyle than this is just another tool to help in that journey.
Thank you, Chad!
Great session and impressive skills from gpt4.
I am absolutely in love with ChatGPT. I use it for work where I'm a subject matter expert to do my grunt work producing bodies of text or brainstorming etc. sometimes just to refresh my memory. Since subscribing and using 4.0 I find I get less hallucinations, too.
My only criticism (and it may be because I'm a SME) is it doesn't push back enough. I will occasionally ask it to critically analyse something which I know is wrong and it will often just go along with me instead of pushing back. Great video and like you, I'm extremely excited (and a tiny bit scared) about how this will supercharge the knowledge economy
Enjoyed that. Thank you!
Fantastic video. Thank you!
Terrific video and a great Canadian teacher. Oh Canada 🍁 it’s great thanks buddy.
Excellent, thanks
Fantastic video. Had no idea CHATGPT has plugins.
definition of a chad! well explained and very helpful for my studies- thank you!
And there goes my Data analytics degree down the trash. LMFAOO
not really. You still have a good leg up. There will be a greater need, however with fabric and co-pilot I foresee a combining of the roles such as DS,DA, DE, etc. For the foreseeable future there is a need for technical/domain oversight.
You need to give it very specific instructions. You have to give it so much information to do things. AI at this point in time is not capable of ingesting large amounts of data. It can't give context to projects with 100s of files, all kinds of systems and integrations.
@@landonman3959 that will change very soon
Data Analytics is obviously not going away. However, now that everyone with common sense is at least up to par with maybe a moderately advanced data analyst, it’s going to at least be extremely competitive. This won’t effect me too much bc I’ll still live a comfortable life but it’s def going to be 100x harder for newcomers.
lol true. At least your name not Chad ☠️ skeleton lol
Great video and very helpful in many ways
Thank you, subscribed and waiting for more
Some really great stuff!!! 🔥 Looking forward to more of your videos related to AI.
Thanks!
Great vid! Thank you.
Really valuable tutorial - thank you for sharing your knowledge
Thanks Chris, appreciate the video. Great to see how ChatGPT can be used for data analysis. Also first time I'm learning about Noteable.
Great video and content, please continue, your information is so very helpful- thanks!
Great job Chad!
Very nice.
Thanks, that was interesting.
Great content Sir! keep up the good work
Very informative
Thanks a lot.. This is revealing❤.. Cheers
Wow this is really impressive and interesting, great video! I could see this being a useful DA learning aid; E.g. Here’s a dataset, analyse and based on your findings give me some tasks, challenges, problems to solve etc. Looking forward to seeing more of your vids 👍🏻
Very useful video. I first saw you yesterday while watching a Noteable webinar with Elijah, Noel, Alessandro, and Matt (I might have missed a couple of names here). I am not a techy myself; my background is in social science research (Comm Research), and I have been working in PR doing communication measurement and insights for the past 20 years. This Noteable plug-in will surely be a game-changer for non-techy/non-math people in PR (which I would guess is more than 60%). Am looking forward to your content. Jun
Thanks!
Thank you for the very useful demo. It was clear and I was able to begin using the plugin immediately with Kaggle datasets after watching. It is hard to imagine that ChatGDP was just released in November. I just don't think many people realize just how revolutionary this is. It is important to understand the coding, mathematics and principles behind it but for someone who does and someone learning it opens up possibilities. Arthur Conan Doyle - 'Data! data! data! he cried impatiently. I can't make bricks without clay.' Now you can make buildings. Its like buying a new woodworking tool and you want to find some scrap to test it with.
Thanks for your feedback!
@@chadskeltondata Will this replace data analysts in the future?
@@mmmmmmmmmm710 Hope not!
Very impressed with the way you presented the entire concept. You must do more videos on everything related to AI and it's uses 👍🏻👏🏻
Thanks!
@@chadskeltondata yeah, this was awesome
Congrats on a successful freshman YT video. 🎉
I want to give a tip. You have done well bro.
Mind blowing
informative video
This is amazing!!!! It would be awesome to se how it does with spatial analysis !
Great video Chad, coincidentally ran into this vid and realized we're both from the hood XP (surrey)
I can't thank you enough.
Cool!
ssssssss2023 is incomplete because the year isn't over yet. (And the datetime does have the time of day, though of course it could be the time of data entry.) This was a super video. Thank you. Subscribed and I look forward to more of your content.
Great Video. I wonder if this could work if you upload some natural language data instead of a dataset. For example: Upload a txt file of some study and ask ChatGPT to read and understand the data, create dataset from it and the visualize it.
Great video, the analysis is kind of slow to process and inject the data and product simple analysis at speed, however your instructions are top notch, please keep producing more videos.
Great video, thanks for your thoughts on this Plugin! Have you tried the "Code Interpreter" plugin aswell? Seems to do a similar job analyzing and visualizing data, would be interesting to see your take on it in contrast to Noteable!
Thanks for sharing this. The boring part in the video was not at all because it was very helpfull. I tried to create an account in noteable but it seems that the plugiin now no longer exist. Could you make more videos but with others plugins availables?
I setup the same as in this video and asked chatGPT to explain the data to me like an organized crime boss. This is the response:
Alright, listen up. Here's the lowdown on this bike theft business.
First off, we got a timeline here, see? The number of bike heists ain't constant over the years. There's some years where the business is booming, and others where things are quiet. You gotta keep an eye on the trends, see? Timing is everything in this business.
Next, we got the territory. This ain't a one-district operation. The thefts are spread out, but some districts are hotter than others. You gotta know where the action is. But remember, the more action, the more heat. You don't wanna attract too much attention.
Finally, we got the schedule. This ain't a 9-to-5 job. The thefts happen all hours of the day. But there's some hours where the business is brisker. You gotta know when to strike.
Remember, this ain't no game. This is a business. And in business, knowledge is power. You gotta know the landscape, the timing, and the territory. Only then can you run a successful operation. Got it? Good. Now get out there and make me proud.
Anyone can tell me if that would be the best setup to analyze Roulette spins made by a specific table? Also I'm trying to build the perfect prompt to get GPT to tell me the next number (within 6 chips) using that info, like an algorithm would. I've seen a few built that gives the exact number, but they won't share or sell.
I would love to audit your college courses
This is big! Any updates since you posted this?
I have been searching for a way to produce a visual graph to represent cross-reference themes in a vast body of text I have, akin to a Chris Harrison did for the Bible and it's heavily crossed referenced threaded themes. Anyone know how I could possibly achieve this?
This requires more views... I think Noteable has to invest more in marketing to take this amazing tech global 😌
Thanks!
Very helpful - thank you. Can this run statistical tests or analysis to generate p-values for statistical significant testing?
Haven't tried that but I would imagine so.
Hi Chad, now that ChatGPT allows conversation sharing, could you please share the convo link here as well?
This was a very helpful video, thanks for that. Can one actually download the graphs and charts and further edit them in excel for example?
Don't think they're editable in Excel as they're produced using Python. But you can give ChatGPT further instructions to tweak the charts (ie. color, titles). May cover this in a future video.
very well explained. How big data can be handled by this plugi in? is it possible to connect to external databases for instance my postgress database which is on cloud?
I think Noteable has this functionality but I haven't tried it out myself.
Hey Chad, great video. Unfortunately I don't have the 'plugins' option in my GPT-4, I have DALL.E 3 Beta which I have learned already after buying the plus version :[ Nevertheless great content.
Good stuff! However, how did you get that "+" upload button for selecting the file. I have the Pro version and Notable plugin enabled but I cannot upload files and do not have that button as an option. Thank you for any help
You may need to turn on Code Interpreter Beta in your settings.
excelente!
How you gave the csv file inside the chat Gpt Plus??
Chad, I enjoy your videos. Any ideas for a replacement, now that Noteable is ceasing its operation?... Ed
Looks like ChatGPT has discontinued all of its plugins. But you an achieve much the same thing in the 'default view' for GPT 4 on ChatGPT Plus, which can do data analysis using Python. It just won't be able to put everything in a notebook for you.
can I upload an image on chatgpt plus? I am thinking of subscribing to chatgpt plus. can it interpret an image graph? help pls
how do i export the data from csv to chatGPT ?
How did you upload the excel file on ChatGpt?
If I already create graph and want Chat GPT to report my graph, how can I import my graph to Chat GPT?
Thanks a lot for this video! Do you know of a similar plugin that works with R and not Python?
You can do Noteable notebooks via ChatGPT using R too. I've only started experimenting with it and it doesn't seem to work as smoothly as Python. But it does exist.
Am I mistaken or was the analysis inconsistent between plot 1 and the text description? The plot showed district 1 and 4 being the highest, but the text claimed the majority occurred in district 1 and 2
Good catch! I've been noticing a few mini-hallucinations like this but will try to keep a more careful look out for these going forward. Definitely something to be careful about!
@@chadskeltondata it’s still so exciting! I plan to play around with this soon and really appreciate you sharing this demo!
Not surprising me, and i bet that it already can overcome the mistakes it made with TOT (tree of thoughts) combined with it. So no need to wait for gpt5 even!
Hey, is the notable plugin still available? I just went to the GPT plugin store, and I can't find it anywhere.
Try again in a few days. I think it disappears briefly when they submit an update.
great video. will notable share your data?
I've put all the datasets I've used in the video on my GitHub page in the descriptions page. I haven't (yet) shared my notebooks but I might do so in the future.
@@chadskeltondata I meant data you don't want shared.
@@landonman3959 I don't think so - the notebooks seem to be private until you make them public - but I don't know for sure.
Not sure if you have an answer for this, but I've been trying to use Noteable as you've described here, but I almost always eventually get an error back from ChatGPT of either Network Error or "There was an error generating a response". This happens during the processing phases of the prompt, seemingly like it's timing out or something. Not sure if this is a ChatGPT issue or a Noteable issue. I thought perhaps I was just asking too much of ChatGPT, but it seems to work fine for you
Don't have much to suggest other than giving it another try in a few days. Sometimes the plugins can go a bit haywire for a bit, in particular when they or ChatGPT are being updated.
what we will be doing in future or in just upcoming months🙂
Hey Chad - How do I connect GPT4 to my dataset on Google drive?
Not sure. Sorry.
Thanks for a great video. I have tried to upload the same data file in both .csv and excel format. It's imported from google sheets. I have set the default project and the notable plugin finds the directory and all the files in it. i have set the visibility to open and the access to "owner". I always get this response from chatGPT: "I apologize for the confusion, but it seems there's still an issue with accessing the file. The file path might not be correct or the file might not be accessible due to permissions or other reasons." I did create my own file in notable with "abc123" in it. That data could be found by chatGPT. Any tips? :-)
I get that error sometimes too and, honestly, I just keep trying. You could also try uploading the data to Github or somewhere else (or, if you're using my test data, just point ChatGPT to the files on my Github account) if it's having trouble finding the files in Noteable itself.github.com/chadskelton/data/tree/master/chatgpt
Great content, but everytime I try to add the plug-in to gpt I get the error "couldn't login with plug-in"
Thanks for this. I am getting an error message “as an artificial intelligence model, I don’t have direct access to external systems” when i try to set a default project in ChatGPT4
Make sure the Noteable plugin is activated (you need ChatGPT Plus) and then sometimes you have to literally say, "Please do this for me in Noteable".
@@chadskeltondata Please describe more, I have chatgpt plus but I cannot get to activate any pluggin in it. The option of the little thing you clicked in the video isnt showing up on my plus version. What do you think may be wrong?
Oh dear, Nevermind. I got it. Its just a matter of going to settings and enabling it. Thanks
I biught chatgpt plus and I don't have the Plug in option
Did you try to make ChatGPT to combine and analyze several CSV files at one time? If it works it should be great.
I've done this with a couple of World Bank datasets, doing a scatterplot of the relationship between two variables, and it works. Will perhaps put it on the to-do list for a future video. :)
Would be great if it's work on diff files, looking forward next video
@@chadskeltondata I've played around with this. I seem to get it to work randomly with 5 or so quite simple CSVs. However it loses focus and gives errors when there are more CSVs or the datasets are in any way more complex than a few dozen rows.
@@avgplayer The datasets I've been using have had tens of thousands of rows in some cases but usually not that many columns/fields. But I haven't tried to get it to do things using multiple CSVs. I also find ChatGPT can be quite idiosyncratic: something that worked yesterday may not work today and vice versa. Will play around with some multiple datasets. Can you give any more insight on what you were trying to do? Were the CSVs all related? Were you trying to join them together? Maybe you just need to analyze each one in sequence, even if they're related?
@@chadskeltondatathey were analytics reports from an event. first I tought chatgpt to interpret the data and fed it the Csv files via notable for it to analyze the bunch and give a summary and insights.
i can't find the plugin on the store? any recommendations?
I think it's just temporarily missing because they updated it. Try again in a few days.
Im not able to download files from noteable. Only upload is working. Did you have this issue before?
I find downloading files from Noteable a bit hinky when you try it form the main project page. For me, if I click on the file I want (like a CSV) and then click File>Download that seems to work more consistently.
@@chadskeltondata Thanks Chad.That's what I found out too.
This has to be with chapgpt plus, right?
Yes.
Could this work with hypothesis testing? How about ANOVA?
I'm not familiar enough with concepts like ANOVA to test it out. If you can send me a link to the primer on the concept I could perhaps try it out.
Yes it does work
Godddddamn I spent a WHOLE fkn day configuring and trying to get this to work. In the end GPT told me convert the files to csv and paste it in the chat 🤬🤬
is our uploaded data secure?