1๏ธโฃ Write a function to remove outliers from a list using IQR.
import numpy as np
def remove_outliers(data):
q1 = np.percentile(data, 25)
q3 = np.percentile(data, 75)
iqr = q3 - q1
lower = q1 - 1.5 * iqr
upper = q3 + 1.5 * iqr
return [x for x in data if lower <= x <= upper]
2๏ธโฃ Convert a nested list to a flat list.
nested = [[1, 2], [3, 4],]
flat = [item for sublist in nested for item in sublist]
3๏ธโฃ Read a CSV file and count rows with nulls.
import pandas as pd
df = pd.read_csv('data.csv')
null_rows = df.isnull().any(axis=1).sum()
print("Rows with nulls:", null_rows)
4๏ธโฃ How do you handle missing data in pandas?
โฆ Drop missing rows: df.dropna()
โฆ Fill missing values: df.fillna(value)
โฆ Check missing data: df.isnull().sum()
5๏ธโฃ Explain the difference between loc[] and iloc[].
โฆ loc[]: Label-based indexing (e.g., row/column names)
Example: df.loc[0, 'Name']
โฆ iloc[]: Position-based indexing (e.g., row/column numbers)
Example: df.iloc
๐ฌ Tap โค๏ธ for more!