परिचय
आइटमसेट की आवृत्ति गिनने के लिए Series.value_counts() मेथड का उपयोग करें।
चरण-दर-चरण कार्यान्वयन
1. डेटाफ्रेम बनाएं
import pandas as pd
dataFrame = pd.DataFrame({
'Car': ['BMW', 'Mercedes', 'Lamborghini', 'Audi', 'Mercedes', 'Porsche', 'Lamborghini', 'BMW'],
'Place': ['Delhi', 'Hyderabad', 'Chandigarh', 'Bangalore', 'Hyderabad', 'Mumbai', 'Mumbai', 'Pune'],
'UnitsSold': [95, 80, 80, 75, 92, 90, 95, 50]
})
2. value_counts() मेथड का उपयोग करके Car कॉलम की आवृत्ति गिनें
count1 = dataFrame['Car'].value_counts()
print("\nCount in column Car")
print(count1)
3. इसी तरह अन्य कॉलम की आवृत्ति गिनें
count2 = dataFrame['Place'].value_counts()
count3 = dataFrame['UnitsSold'].value_counts()
पूर्ण उदाहरण
import pandas as pd
dataFrame = pd.DataFrame({
'Car': ['BMW', 'Mercedes', 'Lamborghini', 'Audi', 'Mercedes', 'Porsche', 'Lamborghini', 'BMW'],
'Place': ['Delhi', 'Hyderabad', 'Chandigarh', 'Bangalore', 'Hyderabad', 'Mumbai', 'Mumbai', 'Pune'],
'UnitsSold': [95, 80, 80, 75, 92, 90, 95, 50]
})
print("Dataframe...")
print(dataFrame)
count1 = dataFrame['Car'].value_counts()
print("\nCount in column Car")
print(count1)
count2 = dataFrame['Place'].value_counts()
print("\nCount in column Place")
print(count2)
count3 = dataFrame['UnitsSold'].value_counts()
print("\nCount in column UnitsSold")
print(count3)
आउटपुट
Dataframe...
Car Place UnitsSold
0 BMW Delhi 95
1 Mercedes Hyderabad 80
2 Lamborghini Chandigarh 80
3 Audi Bangalore 75
4 Mercedes Hyderabad 92
5 Porsche Mumbai 90
6 Lamborghini Mumbai 95
7 BMW Pune 50
Count in column Car
BMW 2
Lamborghini 2
Mercedes 2
Audi 1
Porsche 1
Name: Car, dtype: int64
Count in column Place
Mumbai 2
Hyderabad 2
Chandigarh 1
Pune 1
Delhi 1
Bangalore 1
Name: Place, dtype: int64
Count in column UnitsSold
95 2
80 2
92 1
75 1
90 1
50 1
Name: UnitsSold, dtype: int64