Filter interviews by
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
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 ...
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
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 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')
I applied via Naukri.com and was interviewed before Nov 2022. There were 2 interview rounds.
Support projects can be managed by setting clear goals, establishing communication channels, providing training, monitoring progress, and addressing issues promptly.
Set clear goals and expectations for the support project
Establish effective communication channels for team members and stakeholders
Provide necessary training and resources to support team members
Monitor progress regularly and adjust strategies as needed
Add...
I applied via Naukri.com and was interviewed before Feb 2023. There was 1 interview round.
Top trending discussions
I applied via Naukri.com and was interviewed before Jan 2022. There were 3 interview rounds.
posted on 10 Aug 2024
I applied via Campus Placement and was interviewed before Aug 2023. There were 2 interview rounds.
It was purely logical and reasoning questions
Experienced Business Intelligence Developer with a strong background in data analysis and visualization.
Over 5 years of experience in developing BI solutions
Proficient in SQL, ETL processes, and data modeling
Skilled in creating interactive dashboards using tools like Tableau and Power BI
Strong analytical and problem-solving skills
Excellent communication and teamwork abilities
Code in Python to calculate the sum of all even numbers from 1 to 10
Use a for loop to iterate through numbers from 1 to 10
Check if the number is even using the modulo operator (%)
Add the even numbers to a running total
I applied via Walk-in and was interviewed before Dec 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 6 interview rounds.
based on 4 interviews
Interview experience
based on 3 reviews
Rating in categories
Data Specialist
17
salaries
| ₹4 L/yr - ₹7.5 L/yr |
Key Account Manager
6
salaries
| ₹12 L/yr - ₹23 L/yr |
Data Scientist
4
salaries
| ₹16 L/yr - ₹22 L/yr |
Data Research Analyst
4
salaries
| ₹5 L/yr - ₹6 L/yr |
Analyst
3
salaries
| ₹5.5 L/yr - ₹9.6 L/yr |
S&P Global
Autodata
Capgemini
Accenture