Jackie Yuan's Personal Blog
Data Analysis Archives - Jacky Yuan | Digital Marketing Consultant
234
archive,category,category-data-analysis,category-234,ajax_fade,page_not_loaded,,qode-title-hidden,qode_grid_1300,qode-content-sidebar-responsive,qode-theme-ver-9.2,wpb-js-composer js-comp-ver-4.11.2.1,vc_responsive
Data Analysis, Python / 18.04.2020

Missing values are an important part of actual data analysis. In actual production, there are always a lot of missing values. How to deal with missing values is a critical and important step. I had the bad experience of messing up a project because I don't know how to deal with the missing data in my workplace. Although the manager somehow finds the other data source to fulfill the null data, I was still be blamed for the ability to perform the analysis. With my skill set increased, I...

2 Likes
Data Analysis, Python / 08.04.2020

In the dataset, if an observation is unusually larger or smaller than other data in the dataset, we call it Suspected outlier. The existence of suspected outliers will have an undue influence on subsequent calculations. It is necessary to detect suspected outliers and properly handle them. A classic method of calculating the suspected outliers in a data set is the Tukey method. The method first calculates the quartile (Q1) and the quartile (Q3) of the data set to calculate the interquartile range (IQR), which is then less thanQ1 -...

2 Likes
Data Analysis, Web Analytics / 29.05.2018

A Beginner’s Guide to Channel Attribution Modeling in Marketing (using Markov Chains, with a case study in R) Introduction In a typical ‘from think to buy’ customer journey, a customer goes through multiple touch points before zeroing in on the final product to buy. This is even more prominent in the case of e-commerce sales. It is relatively easier to track which are the different touch points the customer has encountered before making the final purchase. Source: MarTech Today As marketing moves more and more towards the consumer driven side of things,...

1 Like