Overview:
- The count() method of DataFrame class returns the number of non-NA elements present in each row or each column of a DataFrame instance.
- The nunique() method counts the number of unique values in a row or a column of DataFrame. Using dropna parameter the NA values can be ignored.
- The shape attribute returns the dimension of a DataFrame instance.
Example for count() method:
|
import pandas as pd
dataValues = [(5, 10, None), (15, 20, 25), (35, None, 40)]; dataFrame = pd.DataFrame(data = dataValues);
print("Number of elements excluding NA:"); countValues = dataFrame.count(); print(countValues); |
Output:
Note that the return type of the count() method is a series. Also the first column in the output is the index of the series. The second column in the output is the counts corresponding to the columns present in the DataFrame.
Example for nunique() method:
|
import pandas as pd
dataValues = [(5,5,5), (1,2,3), (7,0,7)]; dataFrame = pd.DataFrame(data=dataValues); uniqueCounts = dataFrame.nunique(); print("Unique count across columns:") print(uniqueCounts);
uniqueCounts = dataFrame.nunique(axis=1); print("Unique count across rows:") print(uniqueCounts); |
Output:
Example for DataFrame.shape:
|
import pandas as pd
values = [(0,0,1,0), (0,0,0,1), (1,0,1,0)] dataFrame = pd.DataFrame(data = values,columns=('a','b','c','d'));
print("DataFrame:") print(dataFrame)
print("The dimension of the DataFrame is:") print(dataFrame.shape) |
Output:
