Matplotlib jest to jedna z najpopularniejszych bibliotek, która służy do tworzenia wizualizacji danych w Pythonie. Matplotlib została stworzona przez Johna D. Huntera w 2003 roku jako otwartoźródłowa biblioteka umożliwiająca tworzenie statycznych, animowanych i interaktywnych wykresów w Pythonie. Biblioteka jest wydawana na licencji BSD, co oznacza, że jest darmowa i można jej używać zarówno w projektach…
How To Set The First Day of Week DATEFIRST – SET DATEFIRST = 1 sets the first day of the week to Monday. In SQL Server, the first day of the week can be set to any day from 1 (Monday) to 7 (Sunday). This setting affects the output of date-related functions like DATEPART and…
Measuring product similarity, and recommendation understanding in the realm of e-commerce, is paramount. It serves as the cornerstone for various decision-making processes, ranging from product recommendations tailored to individual preferences to detecting duplicate entries in vast datasets. At its core, product similarity encompasses the comparison of attributes, features, and user interactions, aiming to identify items…
Similarity measure in text corpus is the distance between two vectors where the vector dimensions represent the features of two objects. Similarity is the measure of how similar or how different two objects are. The measure of similarity is the degree of similarity and vice versa. Usually, it is measured in the range 0 to…
We will practice python for business analytics on customer segmentation. RFM is a popular customer segmentation technique used in business analytics and marketing. It stands for Recency, Frequency, and Monetary Value, which are three key metrics used to analyze and segment customers based on their behavior and value to the business. Here’s a breakdown of…
If we have a table Registration for a new customer registration and a table of sales called Basket, then the task to do is calculate customer retention of the newly acquired customers. It means that we should calculate the number of purchases of the newly registered customers in the month of registration = 0-th month,…
Data handling is a crucial aspect of business analysis as it involves collecting, organizing, cleaning, preprocessing, analyzing, and interpreting large volumes of data to extract meaningful insights and make informed business decisions. With the increasing availability of data in modern business environments, it is essential to have effective tools and techniques in place for handling…
Python programming is a popular and powerful language that has become a preferred choice for data analysts for several reasons. Syntax is clear and readable, making it easy for beginners to learn and understand. It reduces the barrier to entry Python for analysts who may not have extensive programming experience. Getting Started with Python programming…
Reading data from excel Excel format is popular in analysis and data science. Pandas reads the excel data well, but sometimes you would like to specify data types. How can you do that? Let’s assume your data looks like this As you can see, pandas read all data as int, despite the first column should…