slidescope

What are LOD – Level of Detail Expressions in Tableau

Level of Detail (LOD) expressions in Tableau are a powerful tool for performing calculations that aggregate data at different levels of granularity. They allow you to perform calculations that are not possible with standard aggregations or calculations in Tableau. There are three types of LOD expressions in Tableau: Syntax: {FIXED [dimension1], [dimension2], … : [expression]} …

What are LOD – Level of Detail Expressions in Tableau Read More »

What are Measures and Dimensions in Tableau

In Tableau, measures and dimensions are key components that help in organizing and analyzing data. Measures are quantitative variables that can be measured and aggregated. They are usually represented by numeric data, such as sales figures, profit margins, or customer counts. Measures can be aggregated in different ways, such as sum, average, count, or percentage. …

What are Measures and Dimensions in Tableau Read More »

Handling Missing Data with fillna, dropna and interpolate in Pandas – Lesson 6

Handling missing data is an important task in data analysis and pandas provides several methods to handle missing data, including fillna, dropna, and interpolate. fillna method The fillna method is used to fill missing values in a pandas DataFrame or Series. We can specify a value or a method to fill the missing values. Here …

Handling Missing Data with fillna, dropna and interpolate in Pandas – Lesson 6 Read More »

Read and Write to Excel files in Python Pandas – Lesson 5

Pandas is a popular data analysis library in Python that provides functionality to read and write data from various file formats, including Excel. Here is an example code for reading and writing Excel files using pandas: First, we need to import the pandas library: Reading Excel files We can read an Excel file using the …

Read and Write to Excel files in Python Pandas – Lesson 5 Read More »

ANOVA Example using Python Pandas on Iris Dataset

ANOVA: We can use ANOVA to determine whether the means of three or more groups are significantly different. Here’s an example of how to perform ANOVA on the Iris dataset using Python Pandas and the ANOVA function from the scipy.stats module: Output : Reject null hypothesis: at least one group mean is different If you …

ANOVA Example using Python Pandas on Iris Dataset Read More »

What is Null Hypothesis, with Examples in Python Pandas

In statistics, the null hypothesis is a statement that there is no significant difference between a set of variables or samples. The purpose of a hypothesis test is to either reject or fail to reject the null hypothesis based on the results of the test. In other words, the null hypothesis is the default assumption …

What is Null Hypothesis, with Examples in Python Pandas Read More »

Marketing Data Analysis using Python Pandas and Plotly

ID Year_Birth Education Marital_Status Income Kidhome Teenhome Dt_Customer Recency MntWines … NumStorePurchases NumWebVisitsMonth AcceptedCmp3 AcceptedCmp4 AcceptedCmp5 AcceptedCmp1 AcceptedCmp2 Response Complain Country 0 1826 1970 Graduation Divorced 84,835.00 0 0 6/16/14 0 189 … 6 1 0 0 0 0 0 1 0 SP 1 1 1961 Graduation Single 57,091.00 0 0 6/15/14 0 464 … …

Marketing Data Analysis using Python Pandas and Plotly Read More »

Statsmodel API OLS Model Example

Here’s an example of how to load and analyze the “tips” dataset using both pandas and statsmodels libraries in Python: OLS Regression Results ============================================================================== Dep. Variable: tip R-squared: 0.457 Model: OLS Adj. R-squared: 0.454 Method: Least Squares F-statistic: 203.4 Date: Wed, 22 Feb 2023 Prob (F-statistic): 6.69e-34 Time: 22:02:24 Log-Likelihood: -350.54 No. Observations: 244 AIC: …

Statsmodel API OLS Model Example Read More »