Unpacking NumPy and Pandas

Course

Online

£ 150 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Get to grips with the most popular Python packages that make Data Analysis possiblePython, a multi-paradigm programming language, has become the language of choice for data scientists for data analysis, visualization, and machine learning. In this video course, you will explore two of the most important Python packages used by Data Analysts. You will start off by learning how to set up the right environment for data analysis with Python. Here, you’ll learn to install the right Python distribution, as well as work with the Jupyter notebook, and set up a database. After that you will dive into Python’s NumPy package, Python’s powerful extension with advanced mathematical functions. You will learn to create NumPy arrays, as well as employ different array methods and functions. Then, you will explore Python’s Pandas extension, where you will learn to subset your data, as well as dive into data mapping using Pandas. You’ll also learn to manage your data sets by sorting and ranking them. Finally, you will learn to index and group your data for sophisticated data analysis and manipulation.About the AuthorCurtis Miller is a graduate student at the University of Utah, seeking an Master’s in Statistics (MSTAT) and a Big Data Certificate. In the past, Curtis has worked as a Math Tutor, and has a double major adding mathematics with an emphasis in statistics as a second major. Curtis has studied the gender pay gap, and presented his paper or Gender Pay Disparity in Utah, which grabbed the attention of local media outlets. He currently teaches Basic Statistics at the University of Utah. He enjoys writing and is an avid reader, and enjoys studying politics, economics, history, and psychology and sociology.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

See how to read, sort, and map various data into NumPy and Pandas
Find out how to create and slice data arrays using NumPy
Get to know how to subset your data frames using Pandas
Handle missing data in a Pandas DataFrame
Interface your Python data analysis with R’s language packages

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MySQL
  • Database
  • Database training
  • Data analysis
  • Statistics
  • Algebra
  • University
  • Install
  • Information Systems
  • IT

Course programme

Let's Do This! Setting Up a Python Data Analysis Environment 6 lectures 34:28 The Course Overview This video gives an overview of the entire course. Installing Anaconda We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer Exploring Jupyter Notebooks You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code Exploring Alternatives to Jupyter You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis Package Management with conda You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages Setting Up a Database We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers Let's Do This! Setting Up a Python Data Analysis Environment 6 lectures 34:28 The Course Overview This video gives an overview of the entire course. Installing Anaconda We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer Exploring Jupyter Notebooks You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code Exploring Alternatives to Jupyter You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis Package Management with conda You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages Setting Up a Database We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers The Course Overview This video gives an overview of the entire course. The Course Overview This video gives an overview of the entire course. The Course Overview This video gives an overview of the entire course. The Course Overview This video gives an overview of the entire course. This video gives an overview of the entire course. This video gives an overview of the entire course. Installing Anaconda We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer Installing Anaconda We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer Installing Anaconda We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer Installing Anaconda We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer We prepare to analyze data with Python by installing Anaconda • Go to the Continuum Analytics website • Download the appropriate version • Run the installer Exploring Jupyter Notebooks You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code Exploring Jupyter Notebooks You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code Exploring Jupyter Notebooks You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code Exploring Jupyter Notebooks You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code You'll learn to write literate Python code with Jupyter Notebooks • Start a Jupyter notebook • Write text and code • Run the document code Exploring Alternatives to Jupyter You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis Exploring Alternatives to Jupyter You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis Exploring Alternatives to Jupyter You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis Exploring Alternatives to Jupyter You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis You'll learn when and how to use alternative development environments to Jupyter • Understand why a Jupyter Notebook alternative is desirable • Choose an alternative development environment • Use the chosen environment for data analysis Package Management with conda You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages Package Management with conda You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages Package Management with conda You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages Package Management with conda You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages You'll learn how to manage packages and environments with conda. • Create a conda environment • Install the desired packages • Remove unwanted packages Setting Up a Database We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers Setting Up a Database We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers Setting Up a Database We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers Setting Up a Database We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers We set up a MySQL database to store the data used in data analysis • Go to Oracle's website • Download appropriate MySQL packages • Run installers It's All in the Numbers – Diving into NumPy 5 lectures 42:43 Running through NumPy Data Types You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays Creating NumPy Arrays How can we create an ndarray with our data? We see the NumPy functions for creating ndarrays. • Identify the shape, structure, and content of the desired array • Find the function to create/load this array • Apply the function to get the desired data Slicing Arrays in NumPy We need to access data in an ndarray; here, we see how subsetting is done, so we get exactly the data we need. • Identify the neededentries of an array • Develop a strategy for accessing the elements • Store or manipulate the array subset Arithmetic and Linear Algebra with Arrays How can we use ndarrays for computation? We see how arithmetic and linear algebra with NumPy arrays is done. • Create the array with the data • Perform arithmetic or linear algebra on the array • Interpret the result Employing Array Methods and Functions How can we use NumPy to perform calculations fast? With ufuncs and vectorization! • Identify the calculation needed • Identify the ndarray method or ufunc needed for the calculation • Apply the function or method to the ndarray It's All in the Numbers – Diving into NumPy. 5 lectures 42:43 Running through NumPy Data Types You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays Creating NumPy Arrays How can we create an ndarray with our data? We see the NumPy functions for creating ndarrays. • Identify the shape, structure, and content of the desired array • Find the function to create/load this array • Apply the function to get the desired data Slicing Arrays in NumPy We need to access data in an ndarray; here, we see how subsetting is done, so we get exactly the data we need. • Identify the neededentries of an array • Develop a strategy for accessing the elements • Store or manipulate the array subset Arithmetic and Linear Algebra with Arrays How can we use ndarrays for computation? We see how arithmetic and linear algebra with NumPy arrays is done. • Create the array with the data • Perform arithmetic or linear algebra on the array • Interpret the result Employing Array Methods and Functions How can we use NumPy to perform calculations fast? With ufuncs and vectorization! • Identify the calculation needed • Identify the ndarray method or ufunc needed for the calculation • Apply the function or method to the ndarray Running through NumPy Data Types You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays Running through NumPy Data Types You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays Running through NumPy Data Types You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays Running through NumPy Data Types You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays You'll learn about NumPydtypes, special values, ndarrays, and matrices. • Identify dtypes • Understand special values • Discover ndarrays Creating NumPy Arrays How can we create an ndarray with our data? We see the NumPy functions for creating ndarrays ries and DataFrames to data manipulation problems Pandas Are Fun! What Is Pandas? What is pandas? We get an overview of the pandas functionality. • Think about data management • Learn about pandas'...

Additional information

Basic knowledge of Python development

Unpacking NumPy and Pandas

£ 150 VAT inc.