ChatGPT Data Analysis for Beginners in 2024! (Full Guide)
Vložit
- čas přidán 6. 08. 2024
- 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
Become a Top 1% ChatGPTer:
👉🏼ChatGPT Mastery Course: hi.switchy.io/chatgpt-mastery-course
😮
You make great videos. It has helped a great deal. PS.. You are a very good looking dude if you didn't know. :)
Thanks for amazing info
Very simple to grasp and it is great you acknowledge the flexibility of analysis depending on one's particular study.
Thanks for the quick nugget on ChatGPT use cases! 👍🏻
This is very helpful. I’m helping a friend analyze and report her data to her senior staff and will be using this feature.
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.
❤thank you soo mucch for amazing insights!!
Very awesome work I hope iwill be able to keep up
Love it thanks !
Great clip thank you!
Thank you, blogger. The video was excellent. 👍
Thanks, its made my job done in short way
really helpfull for me as a beginner. Thumb up and sub 4 u.
Working on my dissertation, this video was a jewel! Thanks.
Whats your dissertation about?
@@eddym230 Telemental health implementation and training during COVID. I'm looking at worker satisfaction and if training improved worker satisfaction during that time.
How has this helped you so far? Curious, because I'll start my Dissertation in October (using Production Data)
Good approach if you have the cleaned data.
Thank you
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?
Great!
Excellent. work
Interesting 👍
Remember this is also a revolutionary learning machine. Yes, it will help with analysing loads of things but take advantage by asking it questions to further enhance your understanding. You can also ask it to make a quiz for you to ensure you've covered everything.
This is a game changer and the humans that are smart enough to leverage AI will be the ones creating the future. Be one of them 🧠
This guy is so legit. 💪🏽
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!
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?
Good video
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
True, good call
Exactly what I thought, but man is this powerful! Thanks!
interpreting / cleaning / analysis
NB the 1000th like was mine ❤
Can you do this with normalized data? 🙏🏼
Do you have Any resources for a biominformatic approach to the analysis? Metagenomic studies and such.
Bro excellent 👌
if i have to questionnaires do i blend the data collected and download it in chatgpt or do each questionnaire data by itself?
Can Chat GPT do entity resolution? One of the main issues with data is quality, consistency, and standardisation. Any thoughts?
is there a custom gpt that does these steps for you?
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?
good
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?
Right ✅️
Install your own LLM on your server, like Llama, it would actually allow you to better train it for internal use.
@@jayethompson3414 cheers will check this out. Do you recommend anything on Azure also?
But what about data safety and company's privacy ? That data are later on processed right ?
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?
Can chat gpt update excel spreadsheet with formulas. What’s the best prompt. I found sometimes it does sometimes gets lazy
Impressive that ChatGPT can do this, but the box plots are not trends, trends refer to a time dimension by definition.
great stuff, thanks,
How to analyze datasets bigger than 1GB? should we connect chatgpt to an external database? how to achieve that?
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
Excel has a data analysis feature too
Can gpt 4 access real time data?
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.
cool
Berry, berry good. Financial analysis be my purpose. OK.
% designation and authority
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
% function authority 2024
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.
Add '...to losing your ability to do anything yourself.'
But are you able to do all that by yourself?
% application 2024
Go straight to about 1:36 to avoid the waffling
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.
You need to take more statistics classes and you understand more what ChatGPT tells you which are not quite correct!
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.
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.
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…
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.
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.
@@zest01 apart from maybe the spelling of found! ;)
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.
First prepare your food, then pop it in the microwave. Wasn't that easy?
You know the amount of data , something "REAL" uses?
😂😂
Talks about cleaning data… uses a clean data set…. Pffff
this was a non value add ed video
Learn to be selective in the answers provided. ChatGPT “knowledge” stops before 2022.
It's April of 2023 now
With web browsing ability it can answer questions with more up to date information
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.
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.
@@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.
useless
4:16 What are radar charts 🗒