How can I find number of rows in a dataframe and how to find the number of rows that dont have null values

+1 vote
How can I find number of rows in a dataframe, and how to find the number of rows that dont have null values
Oct 12, 2018 in Data Analytics by Anmol
• 1,780 points
1,542 views

2 answers to this question.

0 votes

To know the number of columns in a dataframe use the function NCOL()

To omit the null value indexes out of the result use the function NCOL(na.omit(data_frame_name))

answered Oct 12, 2018 by Abhi
• 3,720 points
0 votes
Use nrow() to find number of rows and ncol() or length() to find the number of columns in a dataframe.

Try using nrow(df) - length(which(is.na(df))) to find number of rows with no nulls.
answered Aug 14, 2019 by anonymous

Related Questions In Data Analytics

0 votes
3 answers

Code snippet to find number of null values in each column in a dataframe in R

colSums(is.na(data_frame_name)) will return you number of nulls ...READ MORE

answered Jul 5, 2019 in Data Analytics by sindhu
17,682 views
+1 vote
2 answers

How to count the number of elements with the values in a vector?

Use dplyr function group_by(). > n = as.data.frame(num) > ...READ MORE

answered Aug 21, 2019 in Data Analytics by anonymous
• 33,030 points
5,026 views
0 votes
1 answer
0 votes
1 answer

How can I increase the number of axis ticks in R ?

You can try to override ggplots default ...READ MORE

answered May 30, 2018 in Data Analytics by zombie
• 3,790 points
6,746 views
0 votes
2 answers
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 7, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 4,442 views
0 votes
1 answer
0 votes
1 answer

How can I find number of columns in a dataframe

To know the number of columns in ...READ MORE

answered Oct 12, 2018 in Data Analytics by Abhi
• 3,720 points
604 views
0 votes
2 answers

How can you find total number of null values in a dataset column wise?

data['Column Name'].isnull().sum() READ MORE

answered May 7, 2020 in Data Analytics by anonymous
2,557 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP