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.
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
Latest articles
1,677 articles · page 83 of 140Missing 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.
Keep only words
Write a pandas program to remove the numbers from an address column and keep the words. Step-by-step explanation, colour-coded code and real output.
Extract hashtags
Write a pandas program to extract hashtag words from tweets. Step-by-step explanation, colour-coded code and real output.
Extract emails
Write a pandas program to extract email addresses from a column. Step-by-step explanation, colour-coded code and real output.
Number of digits
Write a pandas program to count the digits of each integer in a column. Step-by-step explanation, colour-coded code and real output.
Preparing for a QA interview?
Take free timed mock tests with answers and explanations.