Data Preparation with pandas
In this tutorial, you will learn why it is important to pre-process data and how to do it in pandas.python
Argument Parsing in Python
In this tutorial, learn how to parse one or more arguments from the command-line or terminal using the getopt, sys, and argparse modules.data analysis
How to Add, Subtract, Divide and Multiply in Spreadsheets
Learn how to apply operations like add, subtract, divide, multiply, and a lot more in Google Spreadsheets with the help of an actual dataset.data manipulation
+1Conditional Formatting in Spreadsheets
Learn how to utilize conditional formatting with one or multiple conditions and how to color cells by custom criteria with the help of a dataset.sql
Materialized Views in PostgreSQL
Learn how to store the results of a query with the help of materialized views in PostgreSQL.Leveraging the best of both Python and R
Learn how to use Python and R in conjunction with each other to utilize the best of both in a single data science project.must read
data visualization
Graphs in Spreadsheets
In this tutorial, you'll learn how to create visualizations to display data and gain more meaningful insights with spreadsheets.sql
Cleaning Data in SQL
In this tutorial, you'll learn techniques on how to clean messy data in SQL, a must-have skill for any data scientist.r programming
+1SQLite in R
In this tutorial, you will learn about using SQLite, an extremely light-weight relational database management system (RDBMS) in R.Data Visualization with Power BI
Learn how to analyze and display data using Power BI and make better, more data-driven decisions.sql
Aggregate Functions in SQL
Learn how to use aggregate functions for summarizing results and gaining useful insights about data in SQL.python
+1Introduction to Factor Analysis in Python
In this tutorial, you'll learn the basics of factor analysis and how to implement it in python.data manipulation
Pivot Tables in Spreadsheets
Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.Video: Answering Real-World Questions with SQL Queries
In this video tutorial, you'll break down real-world questions to construct complex queries using CASE statements, subqueries, and common table expressions.sql
+2