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
Ko'proq ko'rsatish📈 Telegram kanali Data science/ML/AI analitikasi
Data science/ML/AI (@datascience_bds) Ingliz til segmentidagi kanali faol ishtirokchi. Hozirda hamjamiyat 13 905 obunachidan iborat bo'lib, Texnologiyalar & Aralashmalar toifasida 8 986-o'rinni va Hindiston mintaqasida 29 300-o'rinni egallagan.
📊 Auditoriya ko‘rsatkichlari va dinamika
невідомо sanasidan buyon loyiha tez o‘sib, 13 905 obunachiga ega bo‘ldi.
25 Avgust, 2026 dagi oxirgi ma’lumotlarga ko‘ra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni 109 ga, so‘nggi 24 soatda esa 1 ga o‘zgardi va umumiy qamrov yuqori darajada qolmoqda.
- Tasdiqlash holati: Tasdiqlanmagan
- Jalb etish (ER): Auditoriya o‘rtacha 7.77% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 2.06% ini tashkil etuvchi reaksiyalarni to‘playdi.
- Post qamrovi: Har bir post o‘rtacha 1 080 marta ko‘riladi; birinchi sutkada odatda 287 ta ko‘rish yig‘iladi.
- Reaksiyalar va o‘zaro ta’sir: Auditoriya faol: har bir postga o‘rtacha 4 ta reaksiya keladi.
- Tematik yo‘nalishlar: Kontent panda, learning, row, api, ethic kabi asosiy mavzularga jamlangan.
📝 Tavsif va kontent siyosati
Muallif resursni shaxsiy fikrni ifoda etish maydoni sifatida ta’riflaydi:
“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...”
Yuqori yangilanish chastotasi (oxirgi ma’lumot 26 Avgust, 2026 da olingan) sababli kanal doimo dolzarb va katta qamrovli bo‘lib qoladi. Analitika auditoriya kontent bilan faol hamkorlik qilishini, uni Texnologiyalar & Aralashmalar toifasidagi muhim ta’sir nuqtasiga aylantirishini ko‘rsatadi.
$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.
