ChatGPT Data Analysis for Beginners in 2024! (Full Guide)

Рет қаралды 108,254

Күн бұрын

Learn EVERYTHING on how to analyze data in ChatGPT!
👉🏼ChatGPT Mastery Course: hi.switchy.io/chatgpt-mastery...
--------------------
🛒AI Templates, Prompts and Courses for ChatGPT and Midjourney:
aifoundations.io/shop
📰Subscribe to my newsletter:
aifoundations.io
🔗Follow me on Linkedin:
/ drake-surach-823530203
🐥Follow me on twitter:
/ drake0dte
--------------------
⌚Chapters:
0:00 - Full Data Analysis Guide in ChatGPT
0:45 - The BEST ChatGPT Course
1:33 - 3 Step Data Analysis Cycle
2:19 - Access Free Datasets
3:25 - Activation and Uploading Data in ChatGPT
4:15 - Compatible File Types
4:43 - Interpreting Data with ChatGPT
5:49 - Cleaning Data with ChatGPT
8:08 - Analyzing Data with ChatGPT
12:28 - Generating Radar Charts
13:13 - Learn ChatGPT in-depth
#chatgpt

Пікірлер: 81

@ai-foundations 3 ай бұрын

Become a Top 1% ChatGPTer: 👉🏼ChatGPT Mastery Course: hi.switchy.io/chatgpt-mastery-course

@junkokato-weinstein9356 3 ай бұрын

😮

@mrme123ee 3 ай бұрын

You make great videos. It has helped a great deal. PS.. You are a very good looking dude if you didn't know. :)

@rupalirahane2617 2 ай бұрын

Thanks for amazing info

@FamNice7 3 ай бұрын

Working on my dissertation, this video was a jewel! Thanks.

@rajeshbhosale2008 3 ай бұрын

Thanks for the quick nugget on ChatGPT use cases! 👍🏻

@AmanKhajanchi 28 күн бұрын

One can also change the colors of the graphs by writing a prompt "Change the blue color in the graph to green" Extending it still further, it also accepts requests for very specific colors if you provide it with a HEX Color Code.

@Radik-lf6hq 3 ай бұрын

❤thank you soo mucch for amazing insights!!

@DavidEide-ow5yz 3 ай бұрын

Very awesome work I hope iwill be able to keep up

@growden100 16 күн бұрын

This is very helpful. I’m helping a friend analyze and report her data to her senior staff and will be using this feature.

@YT-pv8fn 3 ай бұрын

Good approach if you have the cleaned data.

@b.5815 3 ай бұрын

Great clip thank you!

@shabchique7149 3 ай бұрын

Love it thanks !

@jamesneal7762 3 ай бұрын

This guy is so legit. 💪🏽

@philipptietjen5719 Ай бұрын

Hi please revise the section on how to interpret boxplots. The dots, you pointed out at the top end of the ranges are merely outliers (outside of the box). Thanks!

@Detorock 2 ай бұрын

really helpfull for me as a beginner. Thumb up and sub 4 u.

@alberttakaruza5612 3 ай бұрын

NB the 1000th like was mine ❤

@symeonmandrinos9528 21 күн бұрын

Thank you

@emangarrison 23 күн бұрын

This is helpful. Do you have a video that shows how ChatGPT can convert spreadsheet data to a document, basically column data to sections in a report?

@fernandodiaz8231 3 ай бұрын

Thank you for the information. }i have a question. Whats is the limit of records that chatGPT can drive?. Can does it worrk with 10k records?

@macbelwoldie6201 3 ай бұрын

Can you do this with normalized data? 🙏🏼

@JeanPhilippeCunniet 3 ай бұрын

interpreting / cleaning / analysis

@jimimoris8257 2 ай бұрын

Great!

@SD-eu7ht 2 ай бұрын

Can Chat GPT do entity resolution? One of the main issues with data is quality, consistency, and standardisation. Any thoughts?

@proflead 2 ай бұрын

Interesting 👍

@estebanlucas0317 6 күн бұрын

Do you have Any resources for a biominformatic approach to the analysis? Metagenomic studies and such.

@ChrisEck24 3 ай бұрын

is there a custom gpt that does these steps for you?

@irim.8948 Ай бұрын

Impressive that ChatGPT can do this, but the box plots are not trends, trends refer to a time dimension by definition.

@user-ij3oy9um9h 3 ай бұрын

Bro excellent 👌

@BriellaEvans-if4wf 3 ай бұрын

Good video

@alex_316 3 ай бұрын

I think your interpretation of the box plot by the level was incorrect. You just looked at the outliers (dots) while the most important part of the chart for comparison is boxes

@ai-foundations 3 ай бұрын

True, good call

@Potemkin2000 3 ай бұрын

Exactly what I thought, but man is this powerful! Thanks!

@GK-qc5ry 3 ай бұрын

Excel has a data analysis feature too

@denwo1982 3 ай бұрын

How does the enterprise licence work? If we want to use Data Analysis for work purposes I don’t want OpenAI to store our company data on their servers?

@premrawat6700 3 ай бұрын

Right ✅️

@jayethompson3414 3 ай бұрын

Install your own LLM on your server, like Llama, it would actually allow you to better train it for internal use.

@denwo1982 2 ай бұрын

@@jayethompson3414 cheers will check this out. Do you recommend anything on Azure also?

@a.account8011 21 күн бұрын

Can chat gpt update excel spreadsheet with formulas. What’s the best prompt. I found sometimes it does sometimes gets lazy

@aurelioruprest3185 Ай бұрын

Ok, nice video, but what if I couldn’t upload the data file for reasons of secrecy? How can I use chatgpt to help me analyze data?

@aminben1447 3 ай бұрын

good

@MatbiangShadap 2 ай бұрын

Just bought your 300 custom persona, but I don't know what is happening with chatgpt currently, it is not reading any of my csv file. I have tried arranging the data to make it very simple. It cannot read the file, it will always say error analyzing. How do I go about this?

@jje984 3 ай бұрын

Having unduplicated 1000s of files in my life I'd be curious to see how it did the dedup. Removing duplicates from flat denormalized files can become extremely challenging.

@MultiSangtea 3 ай бұрын

Can gpt 4 access real time data?

@latlov 3 ай бұрын

How to analyze datasets bigger than 1GB? should we connect chatgpt to an external database? how to achieve that?

@ai-foundations 3 ай бұрын

I would look for a file compressor if possible, I’m not sure about connecting to external databases. You could try for manageable chunks of data as well

@chrismachabee3128 3 ай бұрын

Berry, berry good. Financial analysis be my purpose. OK.

@stephenmicaiah3170 Ай бұрын

% designation and authority

@maverick657 2 ай бұрын

great stuff, thanks,

@AIRollout 2 ай бұрын

cool

@profetik777 3 ай бұрын

Love it when everyone tells us "you are not using it the right way" if you don't use this one sub feature that they are just telling us about lol

@stephenmicaiah3170 Ай бұрын

% function authority 2024

@kidanetesfay4653 3 ай бұрын

Yoyr program is very interesting and timely important. Hoevere, as your followers ar from all around the world, try to present in loud and slow manner so as to make all your audiences underdtans.

@JohnMoran 3 ай бұрын

Add '...to losing your ability to do anything yourself.'

@paulm5441 2 ай бұрын

But are you able to do all that by yourself?

@scottd1342 2 ай бұрын

Go straight to about 1:36 to avoid the waffling

@stephenmicaiah3170 Ай бұрын

% application 2024

@andhivan 3 ай бұрын

You need to take more statistics classes and you understand more what ChatGPT tells you which are not quite correct!

@Shapeshifter1210 3 ай бұрын

Where will your data be stored? I probably wont be using this sub feature for the reason that company data will be stored on their servers.

@Hiaha 23 күн бұрын

Interesting but dangereous and was already implemented partly in other tools. First, please do not simply upload company or customer data to chatgpt. At least in the EU it can get you fired. Check before with your companies IT. Second, allthough it is nice for a quick overview, actual data analysis is way more tedious and messy. You need domain knowledge and look at specific data points to understand what is going on and how you can use that data to draw conclusion or move forward to e.g. ML. Data Analysis tools have for years had in built tools to automatically clean your data, but in reality nobody uses them for good reason.

@rayfellers 3 ай бұрын

Based on the terminalogy you use to describe the results, this video is definitely not for beginners who know nothing about the various forms of graphs and charts you mention.

@paddy1144 3 ай бұрын

Yeah this is like learning to drive by dismantling an engine! This is for beginners who know how to analyse and visualise data! Anyone who doesn’t know the basics of that shouldn’t be starting here…

@ccevideo 2 ай бұрын

The aim (imho) is to push his $375 course he wants you to buy. This is a cursory primer at best, not really for the masses or general education.

@zest01 2 ай бұрын

I dunno. I’m a marketer and i haven’t fount anything advanced here. The info looks pretty clear to me, a casual user. I reckon the real data science is much more complicated than this mere example.

@paddy1144 2 ай бұрын

@@zest01 apart from maybe the spelling of found! ;)

@AvalanchePerformance 2 ай бұрын

I didn't see anything that wasn't for beginners. He isn't analyzing data, it's a "how to use chat gpt to analyze data" video, which is very basic. And he even explains to use chat gpt to elaborate on anything that's confusing.

@markwrede8878 3 ай бұрын

First prepare your food, then pop it in the microwave. Wasn't that easy?

@picklenickil 3 ай бұрын

You know the amount of data , something "REAL" uses? 😂😂

@hadexxx 3 ай бұрын

Talks about cleaning data… uses a clean data set…. Pffff

@osomartinez 3 ай бұрын

this was a non value add ed video

@StyleViewStudio 3 ай бұрын

Learn to be selective in the answers provided. ChatGPT “knowledge” stops before 2022.

@ai-foundations 3 ай бұрын

It's April of 2023 now

@LeonardLay 3 ай бұрын

With web browsing ability it can answer questions with more up to date information

@stephenr85 8 күн бұрын

All of this content feels like it was created by GPT. Repeatedly saying things as broad as "clean your data" with no qualifiers or exceptions shows a massive lack of data experience. "Format" would be a much more appropriate term here. And telling people that they can be a data analyst by uploading a file and asking a basic question is about as ridiculous as the term "prompt engineering". Asking a question does not make someone a data analyst or engineer. Also no mention of validating results of "cleaning" or the analysis itself. Having written thousands of scripts to MUTATE data over my career, this is an incredible feature, but if you aren't/can't validate results at multiple steps, its reliability is highly suspect.

@ai-foundations 8 күн бұрын

Thanks for the feedback. This content was created by me so I’ll take the compliment hahah. I found using the word ‘clean’ in an LLM setting had the best results when reformatting the data, removing incomplete data or duplicates. Doesn’t mean it’s right or wrong, I just have to see what the LLM responds to best. I’m just a normal dude trying to show others how they can get a good understanding of their data and spreadsheets through ChatGPT. Good starting point for those who don’t have time or money to spend years in school studying data I think! Thanks again for the feedback man. You should give it a shot to validate the process yourself, it’s quite amazing.

@stephenr85 8 күн бұрын

@@ai-foundations appreciate the thoughtful response. I think the only way to really validate the resulting datasets is to run them through a code validator. To automate this, it probably needs to be done via the API. I'm currently creating some data analysis tools via the API for a work project, so I think the use case is coming shortly... A semantics suggestion - prompting AI does not make someone the thing they're prompting for. This probably really irritates anyone from a respective profession. Asking it to write you a book does not make you a writer, and asking it to write some code does not make you a programmer. Using language like "you have the power of a [data analyst, writer, coder, etc] at your fingertips" would be much more correct. But, in the same way that GPT gets A LOT of facts wrong, the integrity of those results should ALWAYS come with a caveat.