-
Volume Analysis
Prediction task on Order VolumeBefore we get into analyze part, we need to do data preprocessing part first.Data Observe We are dealing with order volume of 7 different warehouses. It is obvious that those order volumes are related to time. Compa...…
-
What is cluster analysis
Intelligent customer service system (cluster analysis)What is TF-IDF TF-IDF is a weighting technique that is commonly used technique in information retrieval and data mining. There are two terms. The first one is term frequency and another on...…
-
What is time series data
Time series dataUnderstanding the dataset is really important before we start analyzing Read data When I process time series data, I first use index_coland parse_date in the process of reading the data. I convert the date column data...…
-
What is Transformer
What is TransformerThe Transformer model is a deep learning model based on the self-attention mechanism. It is specifically designed for natural language processing (NLP) tasks, excelling at sequence-to-sequence tasks such as machine translation, ...…
-
How to push a Jekyll site to GitHub and keep it updated
How to Push a Jekyll Site to GitHub and Keep It UpdatedIn today’s digital world, having a personal blog is a great way to share ideas and document your journey. GitHub Pages provides a free way to host static websites, and with Jekyll, you can eas...…
-
Step to create website
1. Clone the GitHub Repository You used git clone to clone the mz-jhz.github.io repository from GitHub. This operation created a local folder (possibly C:\Users\junha\github\mz-jhz.github.io).2. Open the Project in Atom You opened the mz-jhz.gi...…
-
577 Employee Bonus
577 Employee BonusTo find employees with a bonus less than 1000, we need to consider cases where an employee has no bonus at all.Approach Perform a LEFT JOIN: We join Employee and Bonus tables using empID: FROM Employee AS eLEFT J...…
-
570 Managers with at Least 5 Direct Reports
570 Managers with at Least 5 Direct ReportsTo determine managers who have at least 5 direct reports, we need to analyze the Employee table by grouping employees under their respective managers.Approach Use a LEFT JOIN to self-join the Employee ta...…
-
197 Rising Temperature
197 Rising TemperatureTo determine if tomorrow’s temperature is higher than today’s, we can use the special date function DATE_ADD(). The key idea is to self-join the Weather table in a way that ensures we only retain rows where both dates exist.A...…
-
1661 Average Time of Process per Machine
layout: posttitle: 1661 Average Time of Process per Machinedescription: SQL Query Explanationtag: SQL—1661 Average Time of Process per MachineUnderstanding the ProblemThis problem requires calculating the average processing time per machine, where...…
-
1581 Customer Who Visited but Did Not Make Any Transacation
1581 Customer Who Visited but Did Not Make Any Transacationlayout: posttitle: 1581 Customer Who Visited but Did Not Make Any Transactiondescription: SQL Query Explanationtag: SQL—1581 Customer Who Visited but Did Not Make Any TransactionUnderstand...…
-
1581 Customer Who Visited but Did Not Make Any Transacation
1581 Customer Who Visited but Did Not Make Any Transacationlayout: posttitle: 1581 Customer Who Visited but Did Not Make Any Transactiondescription: SQL Query Explanationtag: SQL—1581 Customer Who Visited but Did Not Make Any TransactionUnderstand...…
-
1280 Students and Examinations
1280 Students and ExaminationsTo correctly list all students and their examination records, including subjects they did not take, we need to generate all possible student-subject combinations and count the number of exams taken for each.Approach ...…
-
1068 Customer Orders
1068 Customer OrdersTo identify customers who never placed an order, we need to find records where a customer exists in the Customers table but does not have a corresponding entry in the Orders table.Approach Use a LEFT JOIN: We join Cus...…
