Data Analysis with Pandas, NumPy and PostgreSQL -Masterclass

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

aster the powerful Pandas, NumPy and PostgreSQL library to analyze, manipulate and visualize data.

1. Introduction

1. Introduction

2.1 Numpy_Resources.rar

2.2 oops.rar

2.3 Pandas Resources.rar

2.4 PostgreSQL Resources.rar

2.5 Python.rar

2. Resources.html

3. Hello

4. Tour

2. NumPy and its Applications

1. NumPy and its Applications

3. Basics of NumPy

1. Initializing Different Arrays

2. NumPy Datatypes

4. AccessingChanging Specific Elements, Rows, Columns, etc

1. AccessingChanging Specific Elements

5. Initializing Different Arrays (1s, 0s, full, random, etc)

1. Initializing an Array

6. Basic Mathematics (arithmetic, trigonometry, etc.)

1. Basic Mathematics

7. Linear Algebra and Statistics

1. Linear Algebra and Statistics

8. Reorganizing Arrays

1. Reorganizing Arrays

9. Load data in from a file

1. Load data in from a file

10. Advanced Indexing and Boolean Masking

1. Advanced Indexing and Boolean Masking

11. Pandas - Data Description

1. Data Description

2. Importing the data

12. Creating a DataFrame

1. Series

2. Creating a DataFrame

3. Homework

13. Data Cleaning

1. Data Cleaning

14. Dealing with Empty cells

1. Mean Median Mode

2. Empty cells

15. Dealing with wrong data

1. Wrong Data

16. Dealing with wrong data type

1. Wrong Datatype

17. Dealing with duplicate data

1. Duplicates

18. Correlation

1. Correlation Introduction

2. Correlation

19. Review

1. Review

20. PostgreSQL Introduction

1. Installation

2. SELECT STATEMENT

21. Creating a table

1. Creating a table

22. Insert data into a table

1. Insert data into a table

23. Alter data in a table

1. Alter data in a table

24. Drop a column

1. Drop a column

25. Drop a row

1. Drop a row

26. Order by command

1. Order by command

27. Limit, alias, distinct

1. Limit, alias, distinct

28. WHERE, AND, OR, IN, BETWEEN

1. WHERE, AND, OR, IN, BETWEEN

29. Aggregate and Group by command

1. Aggregate and Group by command

30. Project 1

1. Create database and drop table

2. Create table and Foreign Key

3. Insert data

4. Update using SET

5. Delete Records

6. Display Specific Columns

7. Display Specific Rows

8. ORDER BY - LIMIT

9. WHERE - NOT

10. BETWEEN

11. Equal to, Not Equal to

12. Nested Queries

13. LIKE Condition

14. DISTINCT

15. Connect Two Tables

16. JOINS

17. EXCEPT

18. Special Query

31. Instagram clone Database

1. Create Database and Users Table

2. Photos Table

3. Comment Table

4. Like Table

5. Follows Table

6. Tags Table

7. Photos Tags Table

8. Insert Data

9. Query 1

10. Query 2

11. Query 3

12. Query 4

13. Query 5

14. Query 6

15. Query 7

16. Query 8

17. Query 9

32. Python( Optional )

1. Installation - Python

2. Installation - VS Code

3. Setup and Hello World

4. Drawing a Shape

5. DataTypes

6. Variables

7. Strings

8. Numbers

9. Taking an input

10. Lists

11. List_functions

12. Tuples

13. Dictionaries

14. Functions

15. Return Statement

16. Operators

17. If Statement

18. If Statements & Comparisons

19. While Loop

20. For Loops

21. Exponent Function

22. 2D Lists & Nested Loops

23. Comments

24. Try & Except

25. Reading Files

26. Writing Files

33. Certificate

1. Certificate

139,000 تومان

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

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

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

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