Data Science & Machine Learning
前往频道在 Telegram
Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free For collaborations: @love_data
显示更多📈 Telegram 频道 Data Science & Machine Learning 的分析概览
频道 Data Science & Machine Learning (@datasciencefun) 英语 语言赛道中的 是活跃参与者。目前社区聚集了 77 616 名订阅者,在 教育 类别中位列第 2 020,并在 印度 地区排名第 3 811 位。
📊 受众指标与增长动态
自 невідомо 创建以来,项目保持高速增长,吸引了 77 616 名订阅者。
根据 14 十一月, 2026 的最新数据,频道保持稳定运转。过去 30 天订阅人数变化为 -147,过去 24 小时变化为 -20,整体触达仍然可观。
- 认证状态: 未认证
- 互动率 (ER): 平均受众互动率为 2.41%。内容发布后 24 小时内通常能获得 0.97% 的反应,占订阅者总量。
- 帖子覆盖: 每篇帖子平均可获得 1 872 次浏览,首日通常累积 755 次浏览。
- 互动与反馈: 受众积极参与,单帖平均反应数为 2。
- 主题关注点: 内容集中在 learning, accuracy, distribution, panda, dataset 等核心主题上。
📝 描述与内容策略
作者将该频道定位为表达主观观点的平台:
“Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free
For collaborations: @love_data”
凭借高频更新(最新数据采集于 15 十一月, 2026),频道始终保持新鲜度与高覆盖。分析显示受众积极互动,使其成为 教育 类别中的关键影响点。
77 616
订阅者
-2024 小时
-947 天
-14730 天
正在加载数据
相似频道
标签云
进出提及
---
---
---
---
---
---
吸引订阅者
十一月 '2611月 '26
十一月 '26
+94
在2个频道中
十月 '26
+315
在7个频道中
Get PRO
九月 '26
+468
在12个频道中
Get PRO
八月 '26
+560
在12个频道中
Get PRO
七月 '26
+932
在17个频道中
Get PRO
六月 '26
+859
在15个频道中
Get PRO
五月 '26
+1 098
在11个频道中
Get PRO
四月 '26
+629
在16个频道中
Get PRO
三月 '26
+315
在4个频道中
Get PRO
二月 '26
+843
在12个频道中
Get PRO
一月 '26
+1 339
在18个频道中
Get PRO
十二月 '25
+1 264
在6个频道中
Get PRO
十一月 '25
+1 415
在15个频道中
Get PRO
十月 '25
+1 119
在18个频道中
Get PRO
九月 '25
+598
在24个频道中
Get PRO
八月 '25
+2 431
在24个频道中
Get PRO
七月 '25
+2 317
在36个频道中
Get PRO
六月 '25
+1 379
在41个频道中
Get PRO
五月 '25
+2 702
在49个频道中
Get PRO
四月 '25
+4 574
在35个频道中
Get PRO
三月 '25
+1 830
在36个频道中
Get PRO
二月 '25
+1 553
在36个频道中
Get PRO
一月 '25
+1 334
在55个频道中
Get PRO
十二月 '24
+1 276
在32个频道中
Get PRO
十一月 '24
+2 847
在28个频道中
Get PRO
十月 '24
+3 775
在23个频道中
Get PRO
九月 '24
+3 717
在24个频道中
Get PRO
八月 '24
+3 956
在21个频道中
Get PRO
七月 '24
+3 673
在32个频道中
Get PRO
六月 '24
+3 950
在34个频道中
Get PRO
五月 '24
+3 398
在37个频道中
Get PRO
四月 '24
+2 919
在23个频道中
Get PRO
三月 '24
+3 461
在14个频道中
Get PRO
二月 '24
+2 792
在9个频道中
Get PRO
一月 '24
+3 714
在11个频道中
Get PRO
十二月 '23
+2 830
在7个频道中
Get PRO
十一月 '23
+1 010
在12个频道中
Get PRO
十月 '23
+474
在9个频道中
Get PRO
九月 '23
+409
在0个频道中
Get PRO
八月 '23
+946
在0个频道中
Get PRO
七月 '23
+875
在0个频道中
Get PRO
六月 '23
+744
在0个频道中
Get PRO
五月 '23
+372
在0个频道中
Get PRO
四月 '23
+577
在0个频道中
Get PRO
三月 '23
+253
在0个频道中
Get PRO
二月 '23
+263
在0个频道中
Get PRO
一月 '23
+287
在0个频道中
Get PRO
十二月 '22
+303
在0个频道中
Get PRO
十一月 '22
+400
在0个频道中
Get PRO
十月 '22
+275
在0个频道中
Get PRO
九月 '22
+143
在0个频道中
Get PRO
八月 '22
+383
在0个频道中
Get PRO
七月 '22
+304
在0个频道中
Get PRO
六月 '22
+142
在0个频道中
Get PRO
五月 '22
+125
在0个频道中
Get PRO
四月 '22
+107
在0个频道中
Get PRO
三月 '22
+190
在0个频道中
Get PRO
二月 '22
+147
在0个频道中
Get PRO
一月 '22
+291
在0个频道中
Get PRO
十二月 '21
+289
在0个频道中
Get PRO
十一月 '21
+19
在0个频道中
Get PRO
十月 '21
+39
在0个频道中
Get PRO
九月 '21
+274
在0个频道中
Get PRO
八月 '21
+168
在0个频道中
Get PRO
七月 '21
+323
在0个频道中
Get PRO
六月 '21
+360
在0个频道中
Get PRO
五月 '21
+382
在0个频道中
Get PRO
四月 '21
+327
在0个频道中
Get PRO
三月 '21
+434
在0个频道中
Get PRO
二月 '21
+449
在0个频道中
Get PRO
一月 '21
+480
在0个频道中
Get PRO
十二月 '20
+1 208
在0个频道中
| 日期 | 订阅者增长 | 提及 | 频道 | |
| 15 十一月 | 0 | |||
| 14 十一月 | 0 | |||
| 13 十一月 | 0 | |||
| 12 十一月 | +3 | |||
| 11 十一月 | +2 | |||
| 10 十一月 | +1 | |||
| 09 十一月 | +6 | |||
| 08 十一月 | +9 | |||
| 07 十一月 | 0 | |||
| 06 十一月 | +9 | |||
| 05 十一月 | +7 | |||
| 04 十一月 | +19 | |||
| 03 十一月 | +1 | |||
| 02 十一月 | +31 | |||
| 01 十一月 | +6 |
频道帖子
𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗘𝘅𝗰𝗲𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 📊
🎓 Explore 4 FREE Excel Courses to upgrade your skills!
✅ Excel Formulas & Functions
✅ Pivot Tables & Charts
✅ Data Cleaning & Analysis
✅ Dashboards & Reporting
🎯 Perfect for Students, Freshers & Aspiring Data Analysts!
🔗 𝗟𝗶𝗻𝗸 👇:-
https://pdlink.in/48mO4B2
📌 SAVE & SHARE with friends who want to master Excel! 🔥
| 2 | 𝗙𝗥𝗘𝗘 𝗩𝗜𝗥𝗧𝗨𝗔𝗟 𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝗪𝗜𝗧𝗛 𝗧𝗢𝗣 𝗖𝗢𝗠𝗣𝗔𝗡𝗜𝗘𝗦! 🎓
💻 Explore FREE Virtual Internship & Job Simulation Programs from leading companies!
✅ Learn Industry-Relevant Skills
✅ Work on Practical Tasks
✅ Self-Paced Online Learning
✅ Explore Completion Certificates
✅ Strengthen Your Resume & LinkedIn Profile
🎯 Perfect for Students, Freshers & Job Seekers
🔗 𝗟𝗶𝗻𝗸 👇:-
https://pdlink.in/4t8DRlq
📲 SAVE & SHARE with friends looking for career opportunities! | 508 |
| 3 | 𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗚𝗲𝘁 𝗬𝗼𝘂𝗿 𝗗𝗿𝗲𝗮𝗺 𝗝𝗼𝗯 𝗜𝗡 𝗚𝗼𝗼𝗴𝗹𝗲🔥
Discover *4 FREE resources* to help you prepare for a career at Google!
✅ Improve Your Coding Skills
✅ Strengthen Interview Preparation
✅ Build Technical Knowledge
✅ Prepare for Top Tech Opportunities
🎓Perfect for Students, Freshers & Aspiring Software Engineers!
🔗 𝗟𝗶𝗻𝗸 👇:-
https://pdlink.in/4AwRPQy
📲 SAVE & SHARE with friends dreaming of working at Google! | 728 |
| 4 | 𝟯 𝗙𝗥𝗘𝗘 𝗛𝘂𝗯𝗦𝗽𝗼𝘁 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗦𝘁𝘂𝗱𝗲𝗻𝘁𝘀 & 𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗶𝗻 𝟮𝟬𝟮𝟲🎓
💫HubSpot Academy offers three free online certifications that match these interests.
💫Pick one free course and try it out on your next college event and the certification is free.
🔗 𝗟𝗶𝗻𝗸 :- 👇
https://pdlink.in/4iM5xaQ
📲 *Save & Share with your friends! 🔥* | 800 |
| 5 | CTE:
WITH employee_data AS (
SELECT **
FROM employees
)
SELECT **
FROM employee_data;
View:
CREATE VIEW employee_data AS
SELECT **
FROM employees;
The main difference is that a CTE is temporary within a statement, while a view has a persistent definition in the database.
🔹 9. Real-World Data Science Use Cases
CTEs are widely used in analytical SQL queries to:
• Calculate monthly revenue before comparing sales performance.
• Identify high-value customers.
• Find products with declining sales.
• Calculate department-wise employee statistics.
• Prepare clean datasets for reporting.
• Break complex business queries into smaller steps.
Example: Find customers whose total spending is greater than 50,000.
WITH customer_spending AS (
SELECT
customer_id,
SUM(amount) AS total_spending
FROM orders
GROUP BY customer_id
)
SELECT
customer_id,
total_spending
FROM customer_spending
WHERE total_spending > 50000;
This is useful for customer segmentation and identifying high-value customers.
🔹 10. Common Mistakes to Avoid
• Forgetting the WITH keyword.
• Forgetting parentheses around the CTE query.
• Missing commas between multiple CTE definitions.
• Referencing a CTE outside the SQL statement where it is defined.
• Assuming a CTE permanently stores data.
• Giving CTEs unclear names.
• Assuming CTEs always improve query performance.
Important: A CTE improves query organization and readability, but it does not automatically make a query faster. Its execution behavior depends on the database system and query optimizer.
🔹 11. SQL Interview Questions
Q1. What is a CTE in SQL?
A CTE is a temporary named result set defined using the WITH keyword and used within a single SQL statement.
Q2. Which keyword is used to create a CTE?
The WITH keyword.
Q3. Can we create multiple CTEs in one query?
Yes. Multiple CTEs can be defined in a single WITH clause, separated by commas.
Q4. What is the difference between a CTE and a view?
A CTE exists only for one SQL statement, whereas a view is a stored database object that can be reused across queries.
Q5. Do CTEs improve query performance?
Not necessarily. CTEs mainly improve readability and organization. Performance depends on the database optimizer and query structure.
🎯 Practice Questions
Try writing SQL queries for these problems:
• Create a CTE to find employees earning more than 60,000.
• Calculate department-wise average salary using a CTE.
• Find customers whose total spending exceeds 50,000.
• Create two CTEs to calculate and filter product sales.
• Use a CTE with JOIN to display customer names and their total orders.
🎯 Key Takeaways
• CTE stands for Common Table Expression.
• CTEs are created using the WITH keyword.
• They make complex SQL queries easier to understand.
• You can create multiple CTEs in one query.
• CTEs can be used with JOIN, GROUP BY, and WHERE.
• A CTE exists only within its SQL statement.
• CTEs and views are different.
• CTEs improve readability but do not guarantee better performance.
Double Tap ❤️ For More
-----
0.997056 ₽ · /balance_help | 1 086 |
| 6 | 没有文字... | 635 |
| 7 | Example of a subquery:
SELECT **
FROM employees
WHERE salary > (
SELECT AVG(salary)
FROM employees
);
Equivalent approach using a CTE:
WITH average_salary AS (
SELECT AVG(salary) AS avg_salary
FROM employees
)
SELECT **
FROM employees
WHERE salary > (
SELECT avg_salary
FROM average_salary
);
Both approaches solve the same problem.
🔹 8. CTE vs View
Another important interview concept. | 656 |
| 8 | 没有文字... | 512 |
| 9 | You can now use this result in another query.
For example, find departments with an average salary above 70,000.
WITH department_salary AS (
SELECT
department,
AVG(salary) AS average_salary
FROM employees
GROUP BY department
)
SELECT **
FROM department_salary
WHERE average_salary > 70000;
🔹 5. Using Multiple CTEs
You can create multiple CTEs within a single SQL query. This is especially useful when solving complex business problems step by step.
Suppose you want to:
• Calculate total sales by product.
• Find products generating more than 1,00,000 in sales.
WITH product_sales AS (
SELECT
product_id,
SUM(amount) AS total_sales
FROM orders
GROUP BY product_id
),
high_sales_products AS (
SELECT **
FROM product_sales
WHERE total_sales > 100000
)
SELECT **
FROM high_sales_products;
• The first CTE calculates total sales.
• The second CTE filters high-performing products.
• The final query retrieves the result.
Important: Separate multiple CTE definitions with commas.
🔹 6. CTE with JOIN
You can combine CTEs with JOIN operations.
Example: Find total sales generated by each customer.
Suppose you have:
• customers
• orders
WITH customer_sales AS (
SELECT
customer_id,
SUM(amount) AS total_sales
FROM orders
GROUP BY customer_id
)
SELECT
c.customer_name,
cs.total_sales
FROM customers c
INNER JOIN customer_sales cs
ON c.customer_id = cs.customer_id;
The CTE calculates total sales for each customer. The main query joins that result with the customers table to retrieve customer names.
🔹 7. CTE vs Subquery
This is a common SQL interview question. | 572 |
| 10 | 没有文字... | 451 |
| 11 | 🚀 Data Science Roadmap 2026
📍 Phase 3: SQL for Data Science
📖 Topic 13: Common Table Expressions (CTEs) in SQL
Today, let's learn about one of the most useful SQL concepts: Common Table Expressions (CTEs).
CTEs help us write cleaner, more readable SQL queries by breaking complex queries into smaller, manageable steps.
They are frequently used in data analysis, reporting, and SQL interviews.
🔹 1. What is a CTE in SQL?
CTE stands for Common Table Expression.
It is a temporary named result set that you define using the WITH keyword and use within a single SQL statement.
Think of it as creating a temporary result that you can reference in your main query.
Example:
Suppose you want to find employees earning more than 60,000.
Without a CTE:
SELECT employee_name, salary
FROM employees
WHERE salary > 60000;
Using a CTE:
WITH high_salary_employees AS (
SELECT employee_name, salary
FROM employees
WHERE salary > 60000
)
SELECT **
FROM high_salary_employees;
Here:
• The CTE is created using WITH.
• The inner query selects employees earning more than 60,000.
• The outer query retrieves the result from the CTE.
🔹 2. Basic Syntax of a CTE
WITH cte_name AS (
SELECT column1, column2
FROM table_name
WHERE condition
)
SELECT **
FROM cte_name;
Important parts:
• WITH starts the CTE.
• cte_name is the name you give to the temporary result.
• AS introduces the query.
• The query inside parentheses defines the CTE.
• The main query uses the CTE.
🔹 3. CTE with WHERE Condition
You can use CTEs to filter records before applying further conditions.
Example: Find employees earning more than 50,000 and display only those earning more than 70,000.
WITH employee_data AS (
SELECT employee_name, salary
FROM employees
WHERE salary > 50000
)
SELECT **
FROM employee_data
WHERE salary > 70000;
The CTE first selects employees earning above 50,000. The outer query further filters the result.
🔹 4. CTE with GROUP BY
CTEs are very useful when working with aggregate functions.
Example: Calculate the average salary for each department.
WITH department_salary AS (
SELECT
department,
AVG(salary) AS average_salary
FROM employees
GROUP BY department
)
SELECT **
FROM department_salary;
Result: | 656 |
| 12 | 🚀🔥𝗚𝗢𝗢𝗚𝗟𝗘 𝗖𝗟𝗢𝗨𝗗 – 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! ☁️📊
Learn *Data Analytics, BigQuery, Data Engineering & Looker* for FREE!
✅ Beginner-Friendly Learning
✅ Build In-Demand Tech Skills
✅ Boost Your Resume & Career Opportunities
🎯 Perfect for Students, Freshers & Job Seekers!
🔗 𝗟𝗶𝗻𝗸 :- 👇
https://pdlink.in/4AttkUb
📲 Save & Share with your friends! 🔥 | 793 |
| 13 | What is a Derived Table in SQL? | 1 106 |
| 14 | What is a Correlated Subquery? | 1 028 |
| 15 | What does EXISTS check? | 930 |
| 16 | Which operator is commonly used when a subquery returns multiple values? | 820 |
| 17 | What is a Subquery in SQL? | 759 |
| 18 | Essential Python and SQL topics for data analysts 😄👇
Python Topics:
Python Resources - @pythonanalyst
1. Data Structures
- Lists, Tuples, and Dictionaries
- NumPy Arrays for numerical data
2. Data Manipulation
- Pandas DataFrames for structured data
- Data Cleaning and Preprocessing techniques
- Data Transformation and Reshaping
3. Data Visualization
- Matplotlib for basic plotting
- Seaborn for statistical visualizations
- Plotly for interactive charts
4. Statistical Analysis
- Descriptive Statistics
- Hypothesis Testing
- Regression Analysis
5. Machine Learning
- Scikit-Learn for machine learning models
- Model Building, Training, and Evaluation
- Feature Engineering and Selection
6. Time Series Analysis
- Handling Time Series Data
- Time Series Forecasting
- Anomaly Detection
7. Python Fundamentals
- Control Flow (if statements, loops)
- Functions and Modular Code
- Exception Handling
- File
SQL Topics:
SQL Resources - @sqlanalyst
1. SQL Basics
- SQL Syntax
- SELECT Queries
- Filters
2. Data Retrieval
- Aggregation Functions (SUM, AVG, COUNT)
- GROUP BY
3. Data Filtering
- WHERE Clause
- ORDER BY
4. Data Joins
- JOIN Operations
- Subqueries
5. Advanced SQL
- Window Functions
- Indexing
- Performance Optimization
6. Database Management
- Connecting to Databases
- SQLAlchemy
7. Database Design
- Data Types
- Normalization
Remember, it's highly likely that you won't know all these concepts from the start. Data analysis is a journey where the more you learn, the more you grow. Embrace the learning process, and your skills will continually evolve and expand. Keep up the great work!
Share with credits: https://t.me/sqlspecialist
Hope it helps :) | 810 |
| 19 | 🎓 𝟰 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀
Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies
📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/45vk5ph
💫 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 :- https://pdlink.in/3SuUeuD
☁️ 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 :- :- https://pdlink.in/48kyZjt
🛡️ 𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 :- :- https://pdlink.in/4fWJVID
🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates! | 854 |
| 20 | 🚀 𝗠𝗜𝗖𝗥𝗢𝗦𝗢𝗙𝗧 + 𝗟𝗜𝗡𝗞𝗘𝗗𝗜𝗡 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! 🎓🔥
😍 Explore 5 FREE Career Learning Paths to boost your resume!
📊 Data Analytics | ☁️ Cloud Computing | 🤖 AI | 🔐 Cybersecurity | 💻 Software Development
✅ Learn In-Demand Skills
✅ Explore Certificate Opportunities
✅ Perfect for Students, Freshers & Job Seekers
🔗 𝗟𝗶𝗻𝗸 :- 👇
https://pdlink.in/4eOufX9
📲 Share with your friends! 🔥 | 1 005 |
