Petpooja Interview Questions and Answers

count is used to count the number of cells that contain numbers, while countA is used to count the number of cells that are not empty.

• count is used with numerical values, while countA is used with any type of value

• count excludes empty cells, while countA includes empty cells

• countA can be used to count non-numeric values such as text or logical values

SumIf adds up values based on a condition, while countIF counts the number of cells that meet a condition.

• SumIf is used to add up values in a range that meet a specific condition.

• CountIF is used to count the number of cells in a range that meet a specific condition.

• Example: =SUMIF(A1:A10, ">10") would add up all values in cells A1 to A10 that are greater than 10.

• Example: =COUNTIF(B1:B10, "=Red") would count the number of cells in B1 to B10 that contain the word 'Red'.

Handle missing values in a dataFrame by imputing, dropping, or filling with specific values.

• Use dropna() method to remove rows or columns with missing values

• Use fillna() method to fill missing values with a specific value

• Use interpolate() method to fill missing values by interpolation

Use the read_csv() function in pandas to read a csv file into a DataFrame.

• Use pd.read_csv('file.csv') to read a csv file into a DataFrame

• Specify additional parameters like delimiter, header, index_col if needed

• Save the DataFrame to a variable for further data manipulation

Use the merge function in pandas to combine multiple DataFrames based on a common column.

• Use the merge function in pandas with the 'on' parameter to specify the common column to merge on.

• Specify the type of join (inner, outer, left, right) using the 'how' parameter.

• Example: df_merged = pd.merge(df1, df2, on='common_column', how='inner')