参照(Reference) : 「データサイエンティスト協会スキル定義委員」の「データサイエンス100本ノック(構造化データ加工編)」
The Data Scientist Society Github :
Data Science 100 Knocks (Structured Data Processing) URL :
-
Note: This is an ipynb file originally created by The Data Scientist Society(データサイエンティスト協会スキル定義委員) and translated from Japanese to English by DeepL.
-
The reason I updated this file is to spread this practice, which is useful for everyone who wants to practice SQL, from beginners to advanced engineers.
-
Since this data was created for Japanese, you may face language problems when practicing. But do not worry, it will not affect much.
You can get preprocess_knock files to practice python, SQL, R from my github account
Data Science 100 Knocks (Structured Data Processing) – SQL
Data Science 100 Knocks (Structured Data Processing) – SQL part1 (Q1 to Q20)
![](https://learning-with-funacademic.com/wp-content/uploads/2023/02/Screenshot-2023-02-28-at-15.24.18-160x90.jpg)
Data Science 100 Knocks (Structured Data Processing) – SQL part2 (Q21 to Q40)
![](https://learning-with-funacademic.com/wp-content/uploads/2023/02/Screenshot-2023-02-28-at-15.24.25-160x90.jpg)
Data Science 100 Knocks (Structured Data Processing) – SQL part3 (Q41 to Q60)
![](https://learning-with-funacademic.com/wp-content/uploads/2023/02/Screenshot-2023-02-28-at-15.24.34-160x90.jpg)
Data Science 100 Knocks (Structured Data Processing) – SQL part4 (Q61 to Q80)
![](https://learning-with-funacademic.com/wp-content/uploads/2023/02/Screenshot-2023-02-28-at-15.24.45-160x90.jpg)
Data Science 100 Knocks (Structured Data Processing) – SQL part5 (Q81 to Q100)
![](https://learning-with-funacademic.com/wp-content/uploads/2023/02/Screenshot-2023-02-28-at-16.04.47-160x90.jpg)
Data Science 100 Knocks (Structured Data Processing)
![](https://learning-with-funacademic.com/wp-content/uploads/2023/02/Screenshot-2023-02-28-at-17.20.35-160x90.jpg)
Comment