Ask Question
Ask a Question
Ask Question Login
Gen AI
All Gen AIGen AIAgentic AI
AI & Machine Learning
All AI & Machine LearningAI Master TrainingData ScienceData EngineeringPython Master TrainingMachine Learning Master TrainingDeep Learning TableauData Science Certification Training using RData Visualization
Cloud Computing
All Cloud ComputingAWSAWS SysOpsAWS DeveloperMicrosoft Azure Solution ArchitectVMware
Salesforce Cloud
All Salesforce CloudSalesforceSalesforce AdminSalesforce DeveloperSalesforce App BuilderSalesforce LightningSalesforce Service Cloud
Cyber Security
All Cyber Security GRC & Risk ManagementCyber SecurityCompTIA security+CISSPCEH - Master
QA Testing
All QA TestingAI in Automation TestingQASelenium Testing Manual Testing Training & CertificationAutomation Testing TrainingPerformance TestingQTP/UFTAppium Certification Training
Business Analyst
All Business AnalystBusiness AnalystPMPSix SigmaScrum Master
Data Management
All Data ManagementSQL (Power BI)MS SQL ServerMSBISQL DBA Training TableauData AnalyticsOracle DBAHadoop
DevOps Master
All DevOps MasterDevOps
Data Science
All Data ScienceData ScienceData Science Certification Training using RDeep LearningData Visualization
Business Intelligence
All Business Intelligence TableauMSBITableau Admin
Digital Marketing
All Digital MarketingDigital MarketingSMO
Programming
All ProgrammingJava.NETPython Master TrainingiOS Android App DevelopmentRPA BlockchainFull Stack Developer
Self-learning
All Self-learning Cybersecurity Self LearningAWS Self-LearningSQL Server Self-LearningBusiness Analyst Self-LearningQA Self-LearningSalesforce Self-LearningTableau Self-LearningData Science Self-LearningiOS Self learningDevOps Self-Learning
Corporate Training
  1. Community
  2. Devops
  3. Question
Devops

How to select rows with NaN in particular column?

Asked by Emma Lewis May 10, 2021 1.2K views 1 answer
Share

About this question

Given this dataframe, how to select only those rows that have "Col2" equal to NaN?
In [56]: df = pd.DataFrame([range(3), [0, np.NaN, 0], [0, 0, np.NaN], range(3), range(3)], columns=["Col1", "Col2", "Col3"])
In [57]: df
Out[57]: 
   0   1   2
0  0   1   2
1  0 NaN   0
2  0   0 NaN
3  0   1   2
4  0   1   2
The result should be this one:
Out[57]: 
   0   1   2
1  0 NaN   0

Your answer

1 Answer

More Devops discussions

How to rename Docker images without rebuilding them 3 answers · 117.0K views rejected non fast forward-Git push rejected “non-fast-forward” 3 answers · 100.8K views The following untracked working tree files would be overwritten by merge, but I don't care 3 answers · 52.9K views Unable to resolve this error javac is not recognized as an internal or external command 5 answers · 32.0K views Git push: fatal: 'origin' does not appear to be a git repository - fatal Could not read from remote repository. 1 answer · 31.2K views What is the difference between pull and clone in git? 2 answers · 26.3K views

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Popular Tutorials

Most-read guides across JanBask

  1. What is Model Evaluation and Selection in Data Mining? Data Science 12.7K reads
  2. Basic Statistical Descriptions of Data in Data Mining Data Science 12.6K reads
  3. What is Multidimensional and Mutltilevel Association Rule in Data Mining? Data Science 12.2K reads
  4. Rule-Based Classification in Data Mining Data Science 12.1K reads
  5. What is Constraint-Based Frequent Pattern Mining? Data Science 12.0K reads
  6. What is Data Discretization? Data Science 11.9K reads
Browse all tutorials →

Latest DevOps Blogs

Guides, tips and career advice on DevOps from JanBask experts.

DevOps How to Become a DevOps Engineers: Learning Path, Critical skills & More Looking for answer to how to become a DevOps engineer in 2025? Here is the detailed article about DevOps career path, DevOps… Mar 11, 2025 · 659.5K reads Read more → DevOps Top 50+ Jenkins Interview Questions And Answers For 2025 Here are the Top 50 Jenkins interview questions frequently asked in top MNCs which will help you land an ideal job! These… Mar 5, 2025 · 481.5K reads Read more → DevOps Best 37 DevOps Tools To Learn And Master In 2025: Docker, Git & More Want to know what are Devops tools and their uses? Or looking for the best DevOps list for automation, monitoring, & development?… Feb 20, 2025 · 9.3K reads Read more → DevOps DevOps Engineer Job Description: Roles and Responsibilities [2025 Updated] Discover the essential roles and responsibilities of a DevOps Engineer by exploring the detailed DevOps job description, and… Jan 7, 2025 · 451.2K reads Read more →
View all DevOps blogs →