Data Analytics
Perfect channel to learn Data Analytics Learn SQL, Python, Alteryx, Tableau, Power BI and many more For Promotions: @coderfun @love_data
إظهار المزيد📈 نظرة تحليلية على قناة تيليجرام Data Analytics
تُعد قناة Data Analytics (@sqlspecialist) في القطاع اللغوي الإنكليزية لاعباً نشطاً. يضم المجتمع حالياً 110 228 مشتركاً، محتلاً المرتبة 1 106 في فئة التكنولوجيات والتطبيقات والمرتبة 2 181 في منطقة الهند.
📊 مؤشرات الجمهور والحراك
منذ تأسيسه في невідомо، حقق المشروع نمواً سريعاً وجمع 110 228 مشتركاً.
بحسب آخر البيانات بتاريخ 15 نوفمبر, 2026، تحافظ القناة على نشاط مستقر. خلال آخر 30 يوماً تغيّر عدد الأعضاء بمقدار -686، وفي آخر 24 ساعة بمقدار -42، مع بقاء الوصول العام مرتفعاً.
- حالة التحقق: غير موثّقة
- معدل التفاعل (ER): يبلغ متوسط تفاعل الجمهور 2.61%. وخلال أول 24 ساعة من النشر يحصد المحتوى عادةً 1.09% من ردود الفعل نسبةً إلى إجمالي المشتركين.
- وصول المنشورات: يحصل كل منشور على متوسط 2 876 مشاهدة. وخلال اليوم الأول يجمع عادةً 1 204 مشاهدة.
- التفاعلات والاستجابة: يتفاعل الجمهور بانتظام؛ متوسط التفاعلات لكل منشور يبلغ 6.
- الاهتمامات الموضوعية: يركز المحتوى على مواضيع رئيسية مثل row, sql, analytic, analyst, visualization.
📝 الوصف وسياسة المحتوى
يصف المؤلف القناة بأنها مساحة للتعبير عن الآراء الذاتية:
“Perfect channel to learn Data Analytics
Learn SQL, Python, Alteryx, Tableau, Power BI and many more
For Promotions: @coderfun @love_data”
بفضل وتيرة التحديث المرتفعة (أحدث البيانات بتاريخ 16 نوفمبر, 2026) تحافظ القناة على حداثتها ومستوى وصول مرتفع. وتُظهر التحليلات تفاعلاً نشطاً من الجمهور، ما يجعلها نقطة تأثير مهمة ضمن فئة التكنولوجيات والتطبيقات.
df.shape — Number of rows and columns.
• df.info() — Column names, data types, and non-null counts.
• df.describe() — Descriptive statistics for numerical columns by default.
• df.columns — Column names.
• df.dtypes — Data types of columns.
• df.isnull().sum() — Missing-value count in each column.
These functions help me understand the dataset before starting the analysis.
9️⃣ What is the difference between loc[] and iloc[]?
Sample Answer:
Both are used to select data from a DataFrame.
loc[] selects data using row and column labels.
iloc[] selects data using integer positions.
Example:
df.loc[0, "Salary"]
df.iloc[0, 2]
I use loc when selecting data based on labels and iloc when selecting data based on row and column positions.
One important difference is that loc includes the ending label in label-based slices, while iloc excludes the ending position.
🔟 How do you filter rows in Pandas?
Sample Answer:
I use Boolean conditions to filter records based on business requirements.
Example:
data = {
"Employee": ["Rahul", "Priya", "Amit", "Neha"],
"Salary": [40000, 60000, 55000, 75000]
}
df = pd.DataFrame(data)
high_salary = df[df["Salary"] > 50000]
print(high_salary)
This returns employees whose salary is greater than 50,000.
I can also apply multiple conditions:
df[
(df["Salary"] > 50000) &
(df["Employee"] != "Amit")
]
This is useful when filtering large datasets based on multiple business conditions.
📌 Double Tap ❤️ For Moreimport pandas as pd
data = {
"Name": ["Rahul", "Priya", "Amit"],
"Salary": [50000, 60000, 45000]
}
df = pd.DataFrame(data)
print(df)
2️⃣ What is a Series in Pandas?
Sample Answer:
A Series is a one-dimensional labeled data structure that can store values of different data types.
Example:
import pandas as pd
sales = pd.Series([1000, 2000, 3000])
print(sales)
Output:
0 1000
1 2000
2 3000
dtype: int64
A Series is useful when working with a single column of data.
3️⃣ What is a DataFrame in Pandas?
Sample Answer:
A DataFrame is a two-dimensional labeled data structure containing rows and columns.
It is similar to a table in Excel or a relational database.
Example:
data = {
"Employee": ["Rahul", "Priya", "Amit"],
"Department": ["IT", "HR", "Finance"],
"Salary": [50000, 60000, 55000]
}
df = pd.DataFrame(data)
print(df)
A DataFrame is the primary structure I use when working with tabular datasets in Pandas.
4️⃣ What is the difference between a Series and a DataFrame?
Sample Answer:
A Series is one-dimensional, whereas a DataFrame is two-dimensional.
Series:
• Contains a single labeled sequence of values.
• Similar to one column.
DataFrame:
• Contains multiple columns.
• Has row and column labels.
• Similar to a spreadsheet or database table.
Example:
df["Salary"] # Returns a Series
df[["Salary"]] # Returns a DataFrame
5️⃣ How do you read a CSV file using Pandas?
Sample Answer:
I use the read_csv() function to load CSV data into a DataFrame.
Example:
import pandas as pd
df = pd.read_csv("employees.csv")
print(df.head())
I can also specify options such as:
df = pd.read_csv(
"employees.csv",
encoding="utf-8",
na_values=["NA", "Unknown"]
)
This helps when dealing with different file formats and missing-value representations.
6️⃣ How do you read an Excel file using Pandas?
Sample Answer:
I use the read_excel() function.
Example:
df = pd.read_excel("sales.xlsx")
To read a specific worksheet:
df = pd.read_excel(
"sales.xlsx",
sheet_name="January"
)
Pandas also supports writing DataFrames to Excel using to_excel().
7️⃣ What is the difference between head() and tail()?
Sample Answer:
head() displays the first few rows of a DataFrame.
tail() displays the last few rows.
Example:
df.head()
df.tail()arr = np.array([10, 20, np.nan, 40, 50])
print(np.isnan(arr))
print(np.nanmean(arr))
Output:
[False False True False False]
30.0
np.nanmean() calculates the mean while ignoring NaN values.
I would first understand why values are missing before deciding whether to ignore, replace, or investigate them.
8️⃣ What is the difference between np.random.rand() and np.random.randint()?
Sample Answer:
Both functions generate random numbers.
• np.random.rand() generates random floating-point values between 0 and 1.
• np.random.randint() generates random integers within a specified range.
Example:
print(np.random.rand(3))
print(np.random.randint(1, 10, size=5))
The second example generates five integers from 1 up to, but not including, 10.
Random numbers are useful for simulations, sampling, and testing.
9️⃣ What is the difference between a view and a copy in NumPy?
Sample Answer:
A view shares the underlying data with the original array, while a copy creates an independent copy of the data.
Example:
arr = np.array([10, 20, 30])
view_arr = arr.view()
copy_arr = arr.copy()
view_arr[0] = 100
print(arr)
print(copy_arr)
Output:
[100 20 30]
[10 20 30]
Changes made through the view affect the original array, whereas changes to the copy do not.
Understanding this distinction helps prevent unexpected modifications during data processing.
🔟 What is the difference between np.dot() and element-wise multiplication?
Sample Answer:
Element-wise multiplication multiplies corresponding elements of two arrays.
np.dot() performs a dot product. For two one-dimensional arrays, it calculates the sum of products of corresponding elements.
Example:
a = np.array([1, 2, 3])
b = np.array([4, 5, 6])
print(a * b)
Output:
[ 4 10 18]
Using np.dot():
print(np.dot(a, b))
Output:
32
📌 Double Tap ❤️ For Moreimport numpy as np
arr = np.array([
[10, 20, 30],
[40, 50, 60]
])
print(np.sum(arr, axis=0))
print(np.sum(arr, axis=1))
Output:
[50 70 90]
[60 150]
This is useful when calculating column-wise or row-wise totals.
2️⃣ What are aggregation functions in NumPy?
Sample Answer:
Aggregation functions summarize multiple values into a single result.
Common NumPy aggregation functions include:
• np.sum() — Calculates the total.
• np.mean() — Calculates the average.
• np.median() — Calculates the median.
• np.min() — Returns the minimum.
• np.max() — Returns the maximum.
• np.std() — Calculates standard deviation.
• np.var() — Calculates variance.
Example:
sales = np.array([100, 200, 300, 400, 500])
print(np.sum(sales))
print(np.mean(sales))
print(np.max(sales))
Output:
1500
300.0
500
These functions are useful for summarizing business and numerical data.
3️⃣ What is Boolean indexing in NumPy?
Sample Answer:
Boolean indexing allows us to filter array elements based on conditions.
Example:
import numpy as np
sales = np.array([100, 250, 400, 150, 600])
result = sales[sales > 200]
print(result)
Output:
[250 400 600]
This is useful when filtering numerical data based on specific business conditions.
4️⃣ What is the difference between np.where() and Boolean indexing?
Sample Answer:
Boolean indexing directly selects elements that satisfy a condition.
np.where() can return matching indices or select values based on a condition.
Example:
arr = np.array([10, 20, 30, 40])
print(arr[arr > 20])
Output:
[30 40]
Using np.where():
result = np.where(arr > 20, "High", "Low")
print(result)
Output:
['Low' 'Low' 'High' 'High']
I use Boolean indexing for filtering and np.where() when I need conditional value selection.
5️⃣ What is the difference between np.concatenate(), np.vstack(), and np.hstack()?
Sample Answer:
These functions combine multiple arrays.
• np.concatenate() — Joins arrays along a specified existing axis.
• np.vstack() — Stacks arrays vertically.
• np.hstack() — Stacks arrays horizontally.
Example:
a = np.array([1, 2])
b = np.array([3, 4])
print(np.concatenate((a, b)))
print(np.vstack((a, b)))
print(np.hstack((a, b)))
Output:
[1 2 3 4]
[[1 2]
[3 4]]
[1 2 3 4]
These functions are useful when combining datasets or numerical arrays.
6️⃣ What is the difference between np.sort() and np.argsort()?
Sample Answer:
np.sort() returns the sorted values.
np.argsort() returns the indices that would arrange the values in sorted order.
Example:
arr = np.array([40, 10, 30, 20])
print(np.sort(arr))
print(np.argsort(arr))
Output:
[10 20 30 40]
[1 3 2 0]arr = np.array([10, 20, 30, 40, 50])
print(arr[1:4])
Output:
[20 30 40]
For a two-dimensional array:
matrix = np.array([
[1, 2, 3],
[4, 5, 6],
[7, 8, 9]
])import numpy as np
numbers = np.array([10, 20, 30, 40])
print(np.mean(numbers))
Output:
25.0
2️⃣ What is an array in NumPy?
Sample Answer:
A NumPy array is a data structure that stores elements, typically of the same data type, in one or more dimensions.
Example:
import numpy as np
arr = np.array([10, 20, 30, 40])
print(arr)
Output:
[10 20 30 40]
Unlike a standard Python list, NumPy arrays support efficient vectorized numerical operations.
3️⃣ What is the difference between a Python list and a NumPy array?
Sample Answer:
Python lists and NumPy arrays both store collections of values, but they have different characteristics.
Python List:
• Can contain different data types.
• Supports general-purpose collection operations.
• Does not directly support element-wise arithmetic.
NumPy Array:
• Usually stores elements of the same data type.
• Supports vectorized mathematical operations.
• Is generally more memory-efficient for homogeneous numerical data.
• Supports multidimensional arrays.
Example:
List:
numbers = [1, 2, 3]
print(numbers * 2)
Output:
[1, 2, 3, 1, 2, 3]
NumPy:
arr = np.array([1, 2, 3])
print(arr * 2)
Output:
[2 4 6]
4️⃣ What is the difference between a one-dimensional and two-dimensional array?
Sample Answer:
A one-dimensional array contains elements in a single sequence.
Example:
arr1 = np.array([10, 20, 30])
A two-dimensional array contains elements arranged in rows and columns.
Example:
arr2 = np.array([
[10, 20],
[30, 40]
])
A two-dimensional array is useful for representing tabular numerical data.
5️⃣ What are the important attributes of a NumPy array?
Sample Answer:
NumPy provides several attributes to understand an array's structure.
• ndim — Number of dimensions.
• shape — Size of each dimension.
• size — Total number of elements.
• dtype — Data type of elements.
• itemsize — Size of each element in bytes.
Example:
arr = np.array([[10, 20, 30], [40, 50, 60]])
print(arr.ndim)
print(arr.shape)
print(arr.size)
print(arr.dtype)
Output:
2
(2, 3)
6
int64
The exact dtype can depend on the system and how the array is created.
6️⃣ What is the difference between reshape() and resize()?
Sample Answer:
Both functions are used to change the dimensions of an array.
reshape() returns an array with a new shape without changing the original array's shape.
Example:
arr = np.array([1, 2, 3, 4, 5, 6])
new_arr = arr.reshape(2, 3)
resize() changes the shape of an array in place when using the ndarray method.
Example:
arr = np.array([1, 2, 3, 4])
arr.resize(2, 2)
print(arr)
Output:
[[1 2]
[3 4]]
The requested shape must contain a compatible number of elements for reshape().
7️⃣ How do you access elements in a NumPy array?
Sample Answer:
We can use indexing to access individual elements.
Example:
arr = np.array([10, 20, 30, 40])
print(arr[0])
print(arr[2])
Output:
10
30
For a two-dimensional array:
matrix = np.array([
[10, 20],
[30, 40]
])
print(matrix[1, 0])
Output:
30numbers = [1, 2, 2, 3, 4, 4]
unique = list(set(numbers))
If I want to preserve the original order, I can use:
unique = list(dict.fromkeys(numbers))
Output:
[1, 2, 3, 4]
For data analysis, preserving order can be important when the sequence has meaning.
8️⃣ What is the difference between shallow copy and deep copy?
Sample Answer:
A shallow copy creates a new outer object but keeps references to nested objects.
A deep copy creates a new object recursively, including its nested objects.
Example:
import copy
original = [[1, 2], [3, 4]]
shallow = copy.copy(original)
deep = copy.deepcopy(original)
If I modify a nested list inside the shallow copy, the corresponding nested list in the original can also change.
Deep copy avoids this shared nested-object behavior.
9️⃣ How do you find the frequency of each element in a list?
Sample Answer:
I can use the Counter class from the collections module.
Example:
from collections import Counter
numbers = [1, 2, 2, 3, 3, 3, 4]
frequency = Counter(numbers)
print(frequency)
Output:
Counter({3: 3, 2: 2, 1: 1, 4: 1})
This is useful for finding the frequency of categories, values, or repeated records.
🔟 How do you find the second-largest unique number in a list?
Sample Answer:
I can first remove duplicates, sort the values, and then select the second-largest number.
Example:
numbers = [10, 20, 30, 30, 40, 50]
unique_numbers = sorted(set(numbers))
second_largest = unique_numbers[-2]
print(second_largest)
Output:
40
Using set() ensures that repeated values do not affect the result.
I would also handle the case where fewer than two unique values exist before accessing the second-largest element.
📌 Double Tap ❤️ For More
-----
1.42 ₽ · /balance_helpstring[start:stop:step]
Example:
text = "Python Programming"
print(text[0:6])
print(text[::-1])
Output:
Python
gnimmargorP nohtyP
It is useful when extracting, modifying, or reversing text data.
2️⃣ What is the difference between split() and join()?
Sample Answer:
split() breaks a string into a list based on a separator.
join() combines multiple strings into a single string using a separator.
Example:
text = "Python SQL Excel"
words = text.split(" ")
print(words)
Output:
['Python', 'SQL', 'Excel']
Using join():
result = "-".join(words)
print(result)
Output:
Python-SQL-Excel
These methods are useful for text cleaning and formatting.
3️⃣ What is list comprehension in Python?
Sample Answer:
List comprehension provides a concise way to create lists using an expression and an iterable.
Example:
numbers = [1, 2, 3, 4, 5]
squares = [x**2 for x in numbers]
print(squares)
Output:
[1, 4, 9, 16, 25]
It can also include conditions:
even_numbers = [x for x in numbers if x % 2 == 0]
Output:
[2, 4]
List comprehensions are useful for simple data transformations.
4️⃣ What is a lambda function?
Sample Answer:
A lambda function is a small anonymous function written in a single expression.
Example:
square = lambda x: x * x
print(square(5))
Output:
25
Lambda functions are commonly used when a short function is needed temporarily.
For example:
employees = [
("Rahul", 50000),
("Amit", 65000),
("Priya", 60000)
]
employees.sort(key=lambda x: x[1])
This sorts employees by salary in ascending order.
5️⃣ What is the difference between map(), filter(), and reduce()?
Sample Answer:
These functions are used for processing iterable data.
map() applies a function to every element.
numbers = [1, 2, 3, 4]
result = list(map(lambda x: x * 2, numbers))
Output:
[2, 4, 6, 8]
filter() selects elements that satisfy a condition.
result = list(filter(lambda x: x > 2, numbers))
Output:
[3, 4]
reduce() repeatedly combines elements into a single result.
from functools import reduce
result = reduce(lambda x, y: x + y, numbers)
Output:
10
6️⃣ What is the difference between append() and extend()?
Sample Answer:
append() adds one element to the end of a list.
extend() adds all elements from another iterable.
Example:
a = [1, 2]
a.append([3, 4])
print(a)
Output:
[1, 2, [3, 4]]
Using extend():
b = [1, 2]
b.extend([3, 4])
print(b)
Output:
[1, 2, 3, 4]