Fill from the next row
Write a pandas program to replace NaN with the value from the next row. Step-by-step explanation, colour-coded code and real output.
SQA Tools Blog
Learn testing and automation, one article at a time
Free tutorials, solved practice problems and interview prep for QA and automation engineers: Python, Playwright, Selenium, SQL, Git and more.
1,677Articles
1,141Solved Python problems
7Topics
100%Free
Python practice articles
1,137 articles · page 38 of 95 · Clear filtersFill from the previous row
Write a pandas program to replace NaN with the value from the previous row. Step-by-step explanation, colour-coded code and real output.
Drop rows that are entirely missing
Write a pandas program to drop rows where all values are missing. Step-by-step explanation, colour-coded code and real output.
Drop columns with missing values
Write a pandas program to drop columns where at least one value is missing. Step-by-step explanation, colour-coded code and real output.
Drop rows with any missing value
Write a pandas program to drop rows where at least one value is missing. Step-by-step explanation, colour-coded code and real output.
Missing values per column
Write a pandas program to count the missing values in each column. Step-by-step explanation, colour-coded code and real output.
Columns with missing values
Write a pandas program to find the columns with at least one missing value. Step-by-step explanation, colour-coded code and real output.
Detect missing values
Write a pandas program to show where values are missing. Step-by-step explanation, colour-coded code and real output.
Merge with different columns
Write a pandas program to merge two DataFrames with different columns, keeping all rows. Step-by-step explanation, colour-coded code and real output.
Merge on a common column
Write a pandas program to join two DataFrames on their common column. Step-by-step explanation, colour-coded code and real output.
Join along columns
Write a pandas program to join two DataFrames side by side. Step-by-step explanation, colour-coded code and real output.
Join along rows
Write a pandas program to join two DataFrames along rows. Step-by-step explanation, colour-coded code and real output.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.