NLP情感分析(Sentiment Analysis):利用自然語言處理技術，分析FINVIZ新聞頭條，預測美股臉書(FB)、特斯拉(TSLA)的市場行情超前部署!

2021 每天必聽Podcasts推薦! (持續更新

分享每天都會聽的七個Podcasts!!

2020 每天必追的3個新聞網站推薦

每天看新聞的來源很多，Line打開就有line today，google新聞打開就有各家媒體平台的報導，但看來看去有沒有發現報導的內容都千篇一律，這次要介紹3個我每天都會瀏覽的新聞網站!!

透過Coronavirus (COVID-19)通俗理解中央極限定理(Central Limit Theorem)

LeetCode 167. Two Sum II — Input array is sorted

題目:

Given an array of integers that is already sorted in ascending order, find two numbers such that they add up to a specific target number.

Leetcode MySQL 181. Employees Earning More Than Their Managers

題目:

The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.

+----+-------+--------+…

Leetcode MySQL 595. Big Countries

題目:

給一個world table，用兩個條件，篩選area 跟 population。

There is a table World

+-----------------+------------+------------+--------------+---------------+
| name            | continent  | area       |…

透過自然語言分析技術(NLP)，利用電影劇情大綱文字，探勘電影之間的相似程度

透過NLP分析電影劇情大綱文字，量化電影之間的相似度

前言&目標:

Leetcode MySQL 196. Delete Duplicate Emails

題目:

DELETE 相同的Email，留下小的Id。

Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.

Leetcode MySQL 178. Rank Scores

題目:

+----+-------+
| Id | Score |
+----+-------+
| 1  | 3.50  |
| 2  | 3.65  |
| 3  | 4.00  |
| 4  | 3.85  |
| 5  | 4.00  |
| 6  | 3.65  |
+----+-------+