Data Analysis with ChatGPT in Excel

سرفصل های دوره

Master ChatGPT for data analysis. Boost your productivity at work and become a first adopter of AI-powered data analysis

1. Course introduction

1. Intro to the course and quick demo of ChatGPT Advanced Data Analysis

2. Overview of ChatGPT Advanced Data Analysis

1. How ChatGPT Advanced Data Analysis will boost your productivity

2. Is ChatGPT Advanced Data Analysis the killer of the data science profession

3. The limitations of ChatGPT Advanced Data Analysis

3. Exploratory Data Analysis (EDA) with ChatGPT

1.1 2.1 source.xlsx

1. Exploratory data analysis - intro

2. Extracting descriptive statistics with ChatGPT

3. Identifying outliers

4. Correlation analysis Hypothesis formulation and feature ideas

5. Crafting a comprehensive EDA prompt

4. Preprocess data with ChatGPT - Deal with inconsistent data

1.1 3.1 output.xlsx

1.2 3.1 source.xlsx

1. Identifying and handling erroneous data

2.1 3.2 output.xlsx

2.2 3.2 source.xlsx

2. Verifying data for errors

3.1 3.3 output.xlsx

3.2 3.3 source.xlsx

3. Eliminating duplicate rows

4.1 3.4 output.xlsx

4.2 3.4 source.xlsx

4. Addressing unit discrepancies in data

5.1 3.5 source.xlsx

5. Dividing cell content into multiple cells

5. Preprocess data with ChatGPT - Organize messy data

1.1 4.1 output.xlsx

1.2 4.1 source.xlsx

1. Organize messy data

2.1 4.2 output.xlsx

2.2 4.2 source.xlsx

2. Data mapping

3.1 4.3 output.xlsx

3.2 4.3 source.xlsx

3. Effective data classification

4.1 4.4 output.xlsx

4.2 4.4 source.xlsx

4. Order data with ChatGPT

6. Preprocess data with ChatGPT - Working with functions

1.1 5.1 output.xlsx

1.2 5.1 source.xlsx

1. COUNTIFS, SUMIFS

2.1 5.2 output.xlsx

2.2 5.2 source.xlsx

2. Data lookup

3.1 5.3 output.xlsx

3.2 5.3 source.xlsx

3. Data ranking

4.1 5.4 output.xlsx

4.2 5.4 source.xlsx

4. Fill until non-blank values

5.1 5.5 output.xlsx

5.2 5.5 source.xlsx

5. Translating logic into Excel formulas with ChatGPT

7. Preprocess data with ChatGPT - Clean text data

1.1 6.1 source.xlsx

1. Correcting inverted names

2.1 6.2 source.xlsx

2. Dealing with trailing and leading spaces in text data

3.1 6.3 source.xlsx

3. Standardizing letter capitalization

4.1 6.4 source.xlsx

4. Handling multi-lingual text data

5.1 6.5 source.xlsx

5. Multiple Find and Replace at the same time with ChatGPT

6.1 6.6 source.xlsx

6. Criteria-based duplicate removal

7.1 6.7 source.xlsx

7. Removing duplicates across multiple columns

8. Preprocess data with ChatGPT - Dates and time data

1.1 7.1 output.xlsx

1.2 7.1 source.xlsx

1. Obtain day and month from date

2.1 7.2 output.xlsx

2.2 7.2 source.xlsx

2. Converting hours to decimals

3.1 7.3 output.xlsx

3.2 7.3 source.xlsx

3. Obtaining age in years, months, days

4.1 7.4 output.xlsx

4.2 7.4 source.xlsx

4. Order dates chronologically

9. Complete practical example

1.1 8.1 Free Plan Users output.xlsx

1.2 8.1 source.xlsx

1.3 8.1 Transactions output.xlsx

1. Intro to the exercise and preprocessing ideas from ChatGPT

2. Preprocessing the Free plan users sheet (12)

3. Preprocessing the Free plan users sheet (22)

4. Working on the Transactions sheet

5. Dealing with the country mapping issue

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy