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

@junkokato-weinstein9356

5 ай бұрын

😮

@mrme123ee

4 ай бұрын

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

@rupalirahane2617

3 ай бұрын

Thanks for amazing info

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

Good approach if you have the cleaned data.

❤thank you soo mucch for amazing insights!!

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

Very awesome work I hope iwill be able to keep up

Great clip thank you!

Love it thanks !

Thank you, blogger. The video was excellent. 👍

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

@eddym230

Ай бұрын

Whats your dissertation about?

@FamNice7

Ай бұрын

@@eddym230 Telemental health implementation and training during COVID. I'm looking at worker satisfaction and if training improved worker satisfaction during that time.

@zapfenmeister123

21 күн бұрын

How has this helped you so far? Curious, because I'll start my Dissertation in October (using Production Data)

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

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.

This guy is so legit. 💪🏽

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!

Interesting 👍

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!

NB the 1000th like was mine ❤

Good video

interpreting / cleaning / analysis

Bro excellent 👌

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?

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

Can you do this with normalized data? 🙏🏼

Excel has a data analysis feature too

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

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

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

5 ай бұрын

True, good call

@Potemkin2000

5 ай бұрын

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

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

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

5 ай бұрын

Right ✅️

@jayethompson3414

4 ай бұрын

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

@denwo1982

4 ай бұрын

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

if i have to questionnaires do i blend the data collected and download it in chatgpt or do each questionnaire data by itself?

good

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.

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?

great stuff, thanks,

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?

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

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

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

@ai-foundations

5 ай бұрын

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

% designation and authority

Can gpt 4 access real time data?

cool

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

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

% function authority 2024

But are you able to do all that by yourself?

Go straight to about 1:36 to avoid the waffling

% application 2024

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

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.

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

4 ай бұрын

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

4 ай бұрын

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

4 ай бұрын

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

4 ай бұрын

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

@AvalanchePerformance

3 ай бұрын

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?

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.

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

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

Ай бұрын

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

Ай бұрын

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

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

@ai-foundations

5 ай бұрын

It's April of 2023 now

@LeonardLay

5 ай бұрын

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

useless

4:16 What are radar charts 🗒