How to do data analysis using AI with ChatGPT and the Noteable plugin

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....

[@noteable_io]

We love seeing how you're using the plugin!

[@hanklo6881]

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.

[@gregelisara9153]

Thanks, Chad - welcome to KZbin. Keep at it! Found this very useful.

[@cybercrusader5164]

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!

[@npcRegard]

And there goes my Data analytics degree down the trash. LMFAOO

[@landonman3959]

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.

[@landonman3959]

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.

[@StoutProper]

@@landonman3959 that will change very soon

[@npcRegard]

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.

[@Alice8000]

lol true. At least your name not Chad ☠️ skeleton lol

[@notfarfromgone1]

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!

[@dmitri3889]

Yes! More vids please! You’re better at this format than the vast majority of KZbinrs.

[@mikehynz]

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.

[@dpratte]

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.

[@nicolasfelipe1]

this tutorial is awesome, it helps me save time exploring concepts before going into the coding part.

[@cruisysoozi]

Great video... Informative and so will presented. Makes it easy to get started with ai for data analytics

[@nuera.]

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!

[@nithishkumar4548]

Super cool, Thanks for the valuable info Chad...

[@princee9385]

Cool ❤😂🎉 you nailed it mate. Thanks for this video.

[@prakashpatti5721]

Thank-you for highlighting bike theft issue in Vancouver!

[@patrickegan8866]

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

[@dantheman8282]

Thanks for sharing! I’ll definitely be playing with this!

[@chadskeltondata]

Glad you enjoyed the video!

[@Max-uw5yw]

Great stuff, hope you keep it up!

[@jessicaryan9820]

Thank you my dude! You just saved me so much time in eda!!!

[@mansibisht557]

Some really great stuff!!! 🔥 Looking forward to more of your videos related to AI.

[@chadskeltondata]

Thanks!

[@drummermike5150]

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.

[@hawts5]

Thanks Chris, appreciate the video. Great to see how ChatGPT can be used for data analysis. Also first time I'm learning about Noteable.

[@chicagomike]

Terrific video and a great Canadian teacher. Oh Canada 🍁 it’s great thanks buddy.

[@jeffreyadams6738]

Fantastic video. Had no idea CHATGPT has plugins.

[@fropemusic2555]

definition of a chad! well explained and very helpful for my studies- thank you!

[@craigkirby5865]

Great video and content, please continue, your information is so very helpful- thanks!

[@tex346]

Thank you for contributing!

[@jonparker772]

Really valuable tutorial - thank you for sharing your knowledge

[@Dr_Shiny]

Thank you, subscribed and waiting for more

[@DjNemes1s]

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 👍🏻

[@VincentOrtegaJr]

😱 finally! Thank you! I've been looking for this daily

[@mendie4008]

Really informational, thank you

[@Margouillard36]

Great content Sir! keep up the good work

[@jesseribeiro6560]

Great content! Cheers

[@GeorgeZoto]

Great session and impressive skills from gpt4.

[@vladimirfokow6420]

Useful video!

[@stevenzammit7949]

Great video and very helpful in many ways

[@akankshas1]

Thanks for this !! Extremely helpful

[@rquintanajr]

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

[@chadskeltondata]

Thanks!

[@geoffbysshe7659]

Fantastic video. Thank you!

[@user-is2iw6gu8v]

Enjoyed that. Thank you!

[@Paparychter]

Great video Chad, coincidentally ran into this vid and realized we're both from the hood XP (surrey)

[@shukranisherard7152]

Great vid! Thank you.

[@AM-ze4hr]

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.

[@chadskeltondata]

Thanks for your feedback!

[@mmmmmmmmmm710]

​@@chadskeltondata Will this replace data analysts in the future?

[@chadskeltondata]

@@mmmmmmmmmm710 Hope not!

[@Jcakiiiii]

This is amazing!!!! It would be awesome to se how it does with spatial analysis !

[@SergeiDumnov]

Thank you, Chad!

[@dhananjaydiwanji9047]

Very impressed with the way you presented the entire concept. You must do more videos on everything related to AI and it's uses 👍🏻👏🏻

[@chadskeltondata]

Thanks!

[@StoutProper]

@@chadskeltondata yeah, this was awesome

[@rayvatsy571]

Great job Chad!

[@WildMidwest1]

Congrats on a successful freshman YT video. 🎉

[@nunyaafari2620]

Thanks a lot.. This is revealing❤.. Cheers

[@chrisupfold9292]

Excellent, thanks

[@johnjcarmody564]

Very informative

[@unstructuredEU]

Very nice.

[@CaribouDataScience]

Thanks, that was interesting.

[@danielkrupah]

I want to give a tip. You have done well bro.

[@alfredosanchezrudi8665]

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?

[@kechike123]

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!

[@ganj0rm0n]

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.

[@WINCLUBdotCA]

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.

[@101RealTalker]

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?

[@marjorieroswell]

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.

[@InspiredAnalyst]

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.

[@mjfadaee3419]

Hi Chad, now that ChatGPT allows conversation sharing, could you please share the convo link here as well?

[@user-wr2et6zh2v]

How you gave the csv file inside the chat Gpt Plus??

[@gytgpi5722]

informative video

[@keshavamugulursrinivasiyen5502]

Mind blowing

[@biniamlukas5757]

how do i export the data from csv to chatGPT ?

[@porawanwitwaranukool2419]

If I already create graph and want Chat GPT to report my graph, how can I import my graph to Chat GPT?

[@BLUE...RED....BLACK000]

can I upload an image on chatgpt plus? I am thinking of subscribing to chatgpt plus. can it interpret an image graph? help pls

[@robertreda2858]

How did you upload the excel file on ChatGpt?

[@collateral7925]

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.

[@ombrandon]

I would love to audit your college courses

[@benweisman4839]

This is big! Any updates since you posted this?

[@BLUE...RED....BLACK000]

I biught chatgpt plus and I don't have the Plug in option

[@pavelbursa9247]

Cool!

[@TechPro771]

I can't thank you enough.

[@boffinschist1098]

Great content, but everytime I try to add the plug-in to gpt I get the error "couldn't login with plug-in"

[@jonrrobinson]

Very helpful - thank you. Can this run statistical tests or analysis to generate p-values for statistical significant testing?

[@chadskeltondata]

Haven't tried that but I would imagine so.

[@AntoniWitkowski-gk4cy]

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.

[@user-zk9wk9gn9d]

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?

[@chadskeltondata]

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.

[@akbarboghani1]

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?

[@chadskeltondata]

I think Noteable has this functionality but I haven't tried it out myself.

[@user-zm1cj2rc3u]

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

[@chadskeltondata]

You may need to turn on Code Interpreter Beta in your settings.

[@djtrillathon5445]

Hey, is the notable plugin still available? I just went to the GPT plugin store, and I can't find it anywhere.

[@chadskeltondata]

Try again in a few days. I think it disappears briefly when they submit an update.

[@thitinantapuwadol464]

is our uploaded data secure?

[@edmealemtemesgen8070]

How to access ChatGPT in Ethiopia? help me, please.

[@uzeyirktk6732]

what we will be doing in future or in just upcoming months🙂

[@LNMishraAdaptive]

Hey Chad - How do I connect GPT4 to my dataset on Google drive?

[@chadskeltondata]

Not sure. Sorry.

[@couldbeacrackhead1]

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

[@chadskeltondata]

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!

[@couldbeacrackhead1]

@@chadskeltondata it’s still so exciting! I plan to play around with this soon and really appreciate you sharing this demo!

[@edc614]

Chad, I enjoy your videos. Any ideas for a replacement, now that Noteable is ceasing its operation?... Ed

[@chadskeltondata]

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.

[@anassbendrif4371]

i can't find the plugin on the store? any recommendations?

[@chadskeltondata]

I think it's just temporarily missing because they updated it. Try again in a few days.

[@joysuryadutta2306]

Can someone please tell me if it's available with the free feature of chatgpt?

[@chadskeltondata]

Nope. Only ChatGPT Plus.

[@jhillmilify]

Thanks a lot for this video! Do you know of a similar plugin that works with R and not Python?

[@chadskeltondata]

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.

[@karikoga320]

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

[@chadskeltondata]

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".

[@abassbabatunde8205]

@@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?

[@abassbabatunde8205]

Oh dear, Nevermind. I got it. Its just a matter of going to settings and enabling it. Thanks

[@gregzehring3315]

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

[@chadskeltondata]

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.

[@anderslarsson7756]

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? :-)

[@chadskeltondata]

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

Im not able to download files from noteable. Only upload is working. Did you have this issue before?

[@chadskeltondata]

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.

[@martindurisin1261]

Could this work with hypothesis testing? How about ANOVA?

[@chadskeltondata]

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.

[@HenryGhost-dx9gb]

Yes it does work

[@godgdfhackergod3836]

but it not work on freee version

[@Carltalks-30]

This has to be with chapgpt plus, right?

[@chadskeltondata]

Yes.

[@boonedocksfl2012]

Noob question. How do you get the data into GPT4 using noteable? I have GPT4 sub and an account on notable. Basics to point me in the right direction would be awesome.

[@chadskeltondata]

This might help: kzbin.info/www/bejne/jIeblamfpZuBadU