Data science/ML/AI
Data science and machine learning hub Python, SQL, stats, ML, deep learning, projects, PDFs, roadmaps and AI resources. For beginners, data scientists and ML engineers 👉 https://rebrand.ly/bigdatachannels DMCA: @disclosure_bds Contact: @mldatascientist
Show more📈 Analytical overview of Telegram channel Data science/ML/AI
Channel Data science/ML/AI (@datascience_bds) in the English language segment is an active participant. Currently, the community unites 13 905 subscribers, ranking 8 986 in the Technologies & Applications category and 29 300 in the India region.
📊 Audience metrics and dynamics
Since its creation on невідомо, the project has demonstrated rapid growth, gathering an audience of 13 905 subscribers.
According to the latest data from 25 August, 2026, the channel demonstrates stable activity. Although there has been a change in the number of participants by 109 over the last 30 days and by 1 over the last 24 hours, overall reach remains high.
- Verification status: Not verified
- Engagement rate (ER): The average audience engagement rate is 7.77%. Within the first 24 hours after publication, content typically collects 2.06% reactions from the total number of subscribers.
- Post reach: On average, each post receives 1 080 views. Within the first day, a publication typically gains 287 views.
- Reactions and interaction: The audience actively supports content: the average number of reactions per post is 4.
- Thematic interests: Content is focused on key topics such as panda, learning, row, api, ethic.
📝 Description and content policy
The author describes the resource as a platform for expressing subjective opinions:
“Data science and machine learning hub
Python, SQL, stats, ML, deep learning, projects, PDFs, roadmaps and AI resources.
For beginners, data scientists and ML engineers
👉 https://rebrand.ly/bigdatachannels
DMCA: @disclosure_bds
Contact: @mldatasci...”
Thanks to the high frequency of updates (latest data received on 26 August, 2026), the channel maintains relevance and a high level of publication reach. Analytics show that the audience actively interacts with content, making it an important point of influence in the Technologies & Applications category.
$35k, $38k, $42k, $44k, $2.5MMean (average): $531,800 Median (middle value): $42,000 The average suggests everyone is wealthy. The median tells a completely different story. 👉 Whenever your data contains extreme values (called outliers), the median often represents the data much better than the mean. That's why you'll often see median house prices and median income reported in the news.
loc and iloc
Both select data. That's why beginners mix them up.
The simplest way to remember is:
loc → labels
iloc → positions
df.loc[5]means:
Give me the row whose label is 5.On the other hand:
df.iloc[5]means:
Give me the 6th row.Those are not necessarily the same row. Especially after filtering. If your DataFrame index looks like:
0 1 4 7 9then:
df.iloc[2]returns the row at position 2. That's index label 4. This tiny distinction causes a surprising number of bugs.
* retrieves every single column.
🔹 4. Fetch Specific Columns
SELECT full_name, total_spent FROM customers;
🔹 5. WHERE Clause
Used to apply filters to your data.
SELECT * FROM customers WHERE age >= 25;
🔹 6. ORDER BY
Sort your results.
SELECT * FROM customers ORDER BY total_spent DESC;
✔️ ASC → Ascending (Lowest to Highest)
✔️ DESC → Descending (Highest to Lowest)
🔹 7. Aggregate Functions
Used for summary statistics.
Function: COUNT()
Purpose: Counts the number of rows
Function: SUM()
Purpose: Adds values together
Function: AVG()
Purpose: Finds the mean value
Function: MAX()
Purpose: Finds the highest value
Function: MIN()
Purpose: Finds the lowest value
✅ Example
SELECT AVG(total_spent) FROM customers;
🔹 8. GROUP BY
Used to categorize data into buckets.
SELECT country, SUM(total_spent) FROM customers GROUP BY country;
🔹 9. Why SQL is Critical?
✔️ #1 requested technical skill in job descriptions
✔️ Used daily by analysts, data engineers, & data scientists
✔️ Scales seamlessly with massive enterprise datasetsCat: 51% Dog: 49%Prediction B
Cat: 99.9% Dog: 0.1%Accuracy treats them exactly the same. Cross Entropy doesn't. It rewards confidence only when the model is correct. If the true class is "Cat": Prediction A gets a relatively high loss. Prediction B gets a very small loss. Now flip the prediction.
Cat: 0.1% Dog: 99.9%The loss explodes. That's because Cross Entropy isn't asking:
Did you get it right?It's asking:
How confident were you in the correct answer?That's why neural networks optimize Cross Entropy instead of accuracy. Accuracy is too coarse to guide learning.
