[ CourseWikia.com ] Udemy - Data Analysis with ChatGPT in Excel

File Name

Size

Get Bonus Downloads Here.url

181 B

~Get Your Files Here !/1. Course introduction/1. Intro to the course and quick demo of ChatGPT Advanced Data Analysis.mp4

36 MB

~Get Your Files Here !/2. Overview of ChatGPT Advanced Data Analysis/1. How ChatGPT Advanced Data Analysis will boost your productivity.mp4

28 MB

~Get Your Files Here !/2. Overview of ChatGPT Advanced Data Analysis/2. Is ChatGPT Advanced Data Analysis the killer of the data science profession.mp4

42 MB

~Get Your Files Here !/2. Overview of ChatGPT Advanced Data Analysis/3. The limitations of ChatGPT Advanced Data Analysis.mp4

48 MB

~Get Your Files Here !/3. Exploratory Data Analysis (EDA) with ChatGPT/1. Exploratory data analysis - intro.mp4

57 MB

~Get Your Files Here !/3. Exploratory Data Analysis (EDA) with ChatGPT/1.1 2.1_source.xlsx

170 kB

~Get Your Files Here !/3. Exploratory Data Analysis (EDA) with ChatGPT/2. Extracting descriptive statistics with ChatGPT.mp4

19 MB

~Get Your Files Here !/3. Exploratory Data Analysis (EDA) with ChatGPT/3. Identifying outliers.mp4

18 MB

~Get Your Files Here !/3. Exploratory Data Analysis (EDA) with ChatGPT/4. Correlation analysis Hypothesis formulation and feature ideas.mp4

19 MB

~Get Your Files Here !/3. Exploratory Data Analysis (EDA) with ChatGPT/5. Crafting a comprehensive EDA prompt.mp4

93 MB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/1. Identifying and handling erroneous data.mp4

33 MB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/1.1 3.1_output.xlsx

17 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/1.2 3.1_source.xlsx

16 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/2. Verifying data for errors.mp4

37 MB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/2.1 3.2_output.xlsx

12 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/2.2 3.2_source.xlsx

16 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/3. Eliminating duplicate rows.mp4

12 MB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/3.1 3.3_output.xlsx

8.1 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/3.2 3.3_source.xlsx

17 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/4. Addressing unit discrepancies in data.mp4

19 MB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/4.1 3.4_output.xlsx

8.9 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/4.2 3.4_source.xlsx

17 kB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/5. Dividing cell content into multiple cells.mp4

46 MB

~Get Your Files Here !/4. Preprocess data with ChatGPT - Deal with inconsistent data/5.1 3.5_source.xlsx

17 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/1. Organize messy data.mp4

51 MB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/1.1 4.1_output.xlsx

62 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/1.2 4.1_source.xlsx

84 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/2. Data mapping.mp4

23 MB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/2.1 4.2_output.xlsx

14 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/2.2 4.2_source.xlsx

9.3 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/3. Effective data classification.mp4

14 MB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/3.1 4.3_output.xlsx

6.6 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/3.2 4.3_source.xlsx

16 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/4. Order data with ChatGPT.mp4

18 MB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/4.1 4.4_output.xlsx

5.6 kB

~Get Your Files Here !/5. Preprocess data with ChatGPT - Organize messy data/4.2 4.4_source.xlsx

18 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/1. COUNTIFS, SUMIFS.mp4

25 MB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/1.1 5.1_output.xlsx

18 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/1.2 5.1_source.xlsx

17 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/2. Data lookup.mp4

26 MB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/2.1 5.2_output.xlsx

18 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/2.2 5.2_source.xlsx

17 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/3. Data ranking.mp4

24 MB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/3.1 5.3_output.xlsx

8.3 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/3.2 5.3_source.xlsx

17 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/4. Fill until non-blank values.mp4

23 MB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/4.1 5.4_output.xlsx

6.1 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/4.2 5.4_source.xlsx

14 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/5. Translating logic into Excel formulas with ChatGPT.mp4

12 MB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/5.1 5.5_output.xlsx

14 kB

~Get Your Files Here !/6. Preprocess data with ChatGPT - Working with functions/5.2 5.5_source.xlsx

14 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/1. Correcting inverted names.mp4

16 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/1.1 6.1_source.xlsx

11 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/2. Dealing with trailing and leading spaces in text data.mp4

18 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/2.1 6.2_source.xlsx

12 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/3. Standardizing letter capitalization.mp4

16 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/3.1 6.3_source.xlsx

18 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/4. Handling multi-lingual text data.mp4

36 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/4.1 6.4_source.xlsx

13 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/5. Multiple Find and Replace at the same time with ChatGPT.mp4

24 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/5.1 6.5_source.xlsx

18 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/6. Criteria-based duplicate removal.mp4

14 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/6.1 6.6_source.xlsx

14 kB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/7. Removing duplicates across multiple columns.mp4

15 MB

~Get Your Files Here !/7. Preprocess data with ChatGPT - Clean text data/7.1 6.7_source.xlsx

15 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/1. Obtain day and month from date.mp4

28 MB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/1.1 7.1_output.xlsx

19 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/1.2 7.1_source.xlsx

17 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/2. Converting hours to decimals.mp4

9.9 MB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/2.1 7.2_output.xlsx

16 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/2.2 7.2_source.xlsx

14 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/3. Obtaining age in years, months, days.mp4

9.1 MB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/3.1 7.3_output.xlsx

14 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/3.2 7.3_source.xlsx

14 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/4. Order dates chronologically.mp4

12 MB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/4.1 7.4_output.xlsx

18 kB

~Get Your Files Here !/8. Preprocess data with ChatGPT - Dates and time data/4.2 7.4_source.xlsx

392 kB

~Get Your Files Here !/9. Complete practical example/1. Intro to the exercise and preprocessing ideas from ChatGPT.mp4

40 MB

~Get Your Files Here !/9. Complete practical example/1.1 8.1 Free_Plan_Users_output.xlsx

146 kB

~Get Your Files Here !/9. Complete practical example/1.2 8.1_source.xlsx

169 kB

~Get Your Files Here !/9. Complete practical example/1.3 8.1_Transactions_output.xlsx

74 kB

~Get Your Files Here !/9. Complete practical example/2. Preprocessing the 'Free plan users' sheet (12).mp4

65 MB

~Get Your Files Here !/9. Complete practical example/3. Preprocessing the 'Free plan users' sheet (22).mp4

36 MB

~Get Your Files Here !/9. Complete practical example/4. Working on the 'Transactions' sheet.mp4

79 MB

~Get Your Files Here !/9. Complete practical example/5. Dealing with the country mapping issue.mp4

23 MB

~Get Your Files Here !/Bonus Resources.txt

386 B