| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 |
- For loops
- pie charts
- error
- multiple lines
- self parameter
- SQL
- Default X points
- continue
- Else
- Text Analytics
- train/test
- machine learning
- matplotlib.pyplot
- variables
- matplotlib
- Python
- MySQL
- line color
- AS
- iterates
- break
- data distribution
- PROJECT
- Text mining
- start exercise
- line width
- polynomial regression
- Github
- PANDAS
- __init__
- Today
- Total
목록SQL (33)
Data Science Explorer
SQL Code Analysis
Let's analyze the following code: SELECT * , ROW_NUMBER() OVER(ORDER BY RET_RATIO DESC) RNK FROM ( SELECT product_id , SUM(reordered) / COUNT(*) AS RET_RATIO FROM order_products__prior GROUP BY 1 ) A WHERE product_id IN ( SELECT product_id FROM ( SELECT product_id , SUM(reordered) AS TOTAL FROM order_products__prior GROUP BY 1 ) A WHERE TOTAL >= 50 ) ; SELECT product_id FROM ( SELECT product_id ..
SQL Code Analysis
This SQL code creates a table named dataset2 in a MySQL database. Let's break down the code step by step: CREATE TABLE `dataset2` ( `Clothing ID` int DEFAULT NULL, `Age` int DEFAULT NULL, `Title` text, `Review Text` text, `Rating` int DEFAULT NULL, `Recommended IND` int DEFAULT NULL, `Positive Feedback Count` int DEFAULT NULL, `Division Name` text, `Department Name` text, `Class Name` text ) ENG..
SQL Code Analysis
Let's analyze the following code: SELECT * FROM dataset2 SELECT 'department name' ,'clothing id' ,'Review Text' FROM dataset2 WHERE 'department name' = 'bottoms' AND 'clothing id' IN (SELECT 'clothing id' FROM stat WHERE 'department name' = 'bottoms'); ORDER BY 'clothing id' ; 1. Select All Columns from dataset2: SELECT * FROM dataset2; This part of the code selects all columns (*) from the data..