How to Supercharge SQL with Python!

Getting started with Python and open-source MySQL

Your Guide to Jupyter Markdowns

Markdown writing skills are essential to portray your work in the Jupyter notebook to offer the reader a sufficient explanation of both the code and the concept. We will go over different ways to spice up your notebook and make it visually pleasing for your readers.

A Beginner’s Guide to Hadoop’s Fundamentals

A non-technical guide to Hadoop’s big data analytical platform together with its primary modules, including HDFS and MapReduce. A Beginner’s Guide to Hadoop’s Fundamentals

Get Started with SQL JOINs

This article helps you to get started with SQL JOINs and distinguish five JOIN types: left join, inner join, full outer join, self join and cross join. Learn how to use SQL to link tables together.

Introduction to Plotnine as the Alternative of Data Visualization Package in Python

The grammar of graphics with plotnine .Introduction to Plotnine as the Alternative of Data Visualization Package in Python

How to Find Seasonality using Python

Learn how to find seasonality using Python. Parse trend and seasonality components from a time series with Python. Parsing seasonality from time series data can often be useful in data analytics. Python can be used to separate out these trend and seasonal components. Learn how to identify and correct for seasonality in time series data with Python.

5 Skills to Become a Data Scientist

Here I am with the 5 most important skills I would want in a Data Scientist: Programming Skills; Mathematics — Statistics & Linear Algebra; Machine Learning; Communication; Data-Driven Mindset. Regardless of whether you are currently a Data Scientist or not, there is always room to be one if you have the urge to learn new skills.

How to use IF-THEN-ELSE in Python the way you work in SAS

IF-THEN-ELSE is an integrated part of the data step in SAS. We don’t have an object for a data step in Python, but can step through the data frame in a similar way and use IF-ELIF-ELSE as it is called in Python.

Analysis of Toronto Neighbourhoods using Machine Learning

A New Immigrant’s Guide to settling in the City of Toronto

How to Combine Alteryx and BigQuery

Learn how to combine Alteryx and BigQuery. Alteryx is known as a platform that combines analysis, data science and process automation. Integration with BigQuery — Google’s powerful Data Warehouse technology — can be realized very easily and used for many interesting use cases.

Python vs. R for Data Science

R and Python are state of the art in terms of programming language oriented towards data science. R is mainly used for statistical analysis while Python provides a more general approach to data science. What matters most as a beginner in Data Science is that you DO Data Science. So just go with either one of the languages and prioritize getting some projects done. That’s how you will learn the fastest.

Data Analyst vs Business Analyst. Here’s the Difference.

What is the difference between a Data Analyst and a Business Analyst? I will be outlining and discussing the distinctions of both roles as well as their respective similarities. I will also be performing a deep dive into the skills required for each role, in addition to the goals associated with that same role. Continue reading if you would like to learn more and discuss the Business Analyst vs Data Analyst positions.

An Introduction to Pandas

Key methods to understanding and utilizing Pandas. Pandas is an open-source Python Library providing high-performance data manipulation and analysis tool using its powerful data structures.

Connect to PostgreSQL Database Server Using psycopg2 with an Elegant Configuration File

Connect to PostgreSQL Database Server Using psycopg2 with an Elegant Configuration File. How to connect with PostgreSQL. To connect to the PostgreSQL, we must create a file that represents our database on PostgreSQL. Create a table. Insert data to a table. Retrieve a table. Update a table. Delete rows or a table.

Dimensionality Reduction Techniques in Machine Learning

Dimensionality Reduction Techniques in Machine Learning. What are Dimensionality Reduction Techniques? Basically, dimension reduction refers to the process of converting a set of data.

3 steps to design your visualized charts

I would like to follow this trend, using John Burn-Murdoch’s chart as a good example and providing you with 3-step tips to make better of your charts.

Join Pandas Aggregate and SQL Analytic Functions

We implement moving averages, rank items, cumulative sums with aggregate function sum, average, min, and max. In this article, we combine pandas aggregate and analytics functions to implement SQL analytic functions.

Data Science Volunteering: Ways to Help

Data Science Volunteering: Ways to Help. Contribute your expertise to a good cause through one of these opportunities.

Hot or Not: Analyzing 60 Years of Billboard Hot 100 Data

Hot or Not: Analyzing 60 Years of Billboard Hot 100 Data. I will be downloading the Hot 100 charts as structured tables and creating custom metrics to quantify these trends and more.

Data Science Is for Everyone

Data Scientist as a term sounds so intimidating, right? Like someone who invents data-related stuff to serve humanity. In this article, I will talk about what tools you can use to solve the kind of problems I am talking about and how a beginner can apply them.