Learn how to code with pandas library
What you’ll learn
-
This course will introduce to the student how to use a Python analytical tool called Pandas. With this technology, the student will be able to import and analyze data
Requirements
-
This course is designed with the beginner in mind; as such, we introduce the fundamentals of pandas library commands to manage data, However, my course called An Absolute Beginner’s Guide to Python is a highly recommended course or a fundamental understanding of Python language.
Description
This course will introduce to the student how to use a Python analytical tool called Pandas. With this technology, the student will be able to import and analyze data from a variety of data sources, such as Excel, CSV, SQL Server, URLs, Big Data, and much more. With the aid of Juypter Notebook editor, the student will be able to interact with pandas library and learn to code. The pandas library will introduce to the student on how to import and export data, how to manage, manipulate, configure data, and how to filter, add, delete, concatenate, group data and visualize data with charts and much more.
Who this course is for:
- As this is a beginner guide to pandas library, it is designed for the student who wants to learn about how to manipulate, configure, manage, import, and export data from a variety of sources such as Excel, CSV, SQL databases, URLs, and many more resources. These students can be developers, database admins, beginning data scientists, financial analysts, Excel students, or anyone who works with data.
Course content
-
INSTALLING SQL SERVER 2019
09:21
-
NAVIGATE JUPYTER INTERFACE
14:16
-
WHAT IS PANDAS
17:45
-
QUIZ 1
07:24
-
IMPORTING AND READING DATA FROM A CSV FILE
12:06
-
PANDAS COMMON KEYWORDS FOR INFO
12:31
-
QUIZ 2
03:48
-
ILOC AND LOC FILTERING AND SLICING
21:12
-
ILOC AND LOC FILTERING AND SLICING PART 2
25:29
-
WORKING WITH INDEXES
19:10
-
QUIZ 3
13:02
-
CONDITIONAL FILTERING WITH OPERATORS
13:20
-
CONDITIONAL FILTERING WITH OPERATORS PART 2
26:24
-
PANDAS SORTING COLUMNS
22:40
-
QUIZ 4
07:27
-
PANDAS SORTING COLUMNS
30:55
-
REPLACE COLUMNS ROWS AND STRING
15:21
-
QUIZ 5
06:28
-
PANDAS STR FUNCTION
34:59
-
PANDAS REGEX
12:35
-
PANDAS REGEX PART 2
26:35
-
GROUPING DATA
27:45
-
QUIZ 6
15:32
-
LAMBDA FUNCTION
21:15
-
PIVOT TABLE
15:08
-
MISSING VALUES
34:02
-
DATES AND DATETIMES
21:11
-
IMPORT HTML URL DATA
05:21
-
QUIZ 7
09:20
-
CONNECTING TO SQL SERVER
13:24
-
JOINS EXPLAINED
09:18
-
SQL AND PANDAS JOINS
18:44
-
EXAMPLES OF SQL VS PANDAS QUERIES
06:22
-
SQL SERVER AND PANDAS COMMANDS
24:52
-
QUIZ 8
05:23
-
MAPLOT LINE GRAPHS
06:29
-
FULL MAPLOT LINE GRAPHS
25:52
-
MAPPLOT PIE CHART
13:05
-
MATPLOT BAR CHART
10:44
-
PYTHON PANDAS PROJECT PART 1
10:39
-
PYTHON PANDAS PROJECT PART 2
19:13
-
PYTHON PANDAS PROJECT PART 3
21:58
-
PYTHON PANDAS PROJECT PART 4
19:26
-
PYTHON PANDAS PROJECT PART 5
19:13
-
IMPORT ALL TABLES VIA SINGLE TSQL COMMAND
02:55
-
QUIZ 9
10:14
-
SELF LEARNING PROJECT
05:41
Download link
Friendly Websites
Related Posts
About The Author
