Beginner’s guide to Python Pandas for Data Analysis

Beginner's guide to Python Pandas for Data Analysis

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

1 section • 50 lectures • 12h 50m total length
  • 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

Created by: Raphael Asghar Production SQL Database Administrator
Last updated 10/2020
English
English [Auto]
Direct Download Available

(2 ratings)
52 students
https://www.udemy.com/course/beginners-guide-to-python-pandas-for-data-analysis/

Download link



Friendly Websites






Related Posts

Add a Comment

Your email address will not be published. Required fields are marked *