AttributeError: 'int' object has no attribute 'keys'

Question

Below are the columns in the DataFrame of data I am iterating on,

> incident_id                            int64 date                     
> object state                           object city_or_county          
> object address                         object n_killed                
> int64 n_injured                        int64 incident_url             
> object source_url                      object
> incident_url_fields_missing            bool congressional_district    
> float64 gun_stolen                     object gun_type               
> object incident_characteristics        object latitude                
> float64 location_description           object longitude              
> float64 n_guns_involved                float64 notes                  
> object participant_age                 object participant_age_group   
> object participant_gender              object participant_name        
> object participant_relationship        object participant_status      
> object participant_type                object sources                 
> object state_house_district            float64 state_senate_district  
> float64 dtype: object

and below is the code i have written,

def count_entries(df,col_name):
    """ Return a dictionary with counts of occurrences as value for each key"""
    cols_count = {}
    col = df[col_name]
    for entry in col:
        if entry in cols_count.keys():
            cols_count[entry] += 1
        else:
            cols_count = 1
    return cols_count
result = count_entries(data, 'gun_stolen')
print (result)

cols_count = 1?

jonrsharpe
– jonrsharpe

2018-12-02 09:44:09 +00:00
Commented Dec 2, 2018 at 9:44 — jonrsharpe
– jonrsharpe, Commented Dec 2, 2018 at 9:44

Eb946207 · Accepted Answer · 2019-01-13 02:31:54Z

3

def count_entries(df,col_name):
    """ Return a dictionary with counts of occurrences as value for each key"""
    cols_count = {}
    col = df[col_name]
    for entry in col:
        if entry in cols_count.keys():
            cols_count[entry] += 1
        else:
            # you forgot the [entry] in else statement.
            cols_count[entry] = 1
    return cols_count
result = count_entries(data, 'gun_stolen')
print (result)

edited Jan 13, 2019 at 2:31

Eb946207

7788 silver badges27 bronze badges

answered Jan 13, 2019 at 2:08

D.Holmes

414 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jezrael · Accepted Answer · 2018-12-02 09:46:45Z

2

You can simplify solution with value_counts:

df = pd.DataFrame({
        'A':list('abcdef'),
         'F':list('aaabbc')
})

print (df)
   A  F
0  a  a
1  b  a
2  c  a
3  d  b
4  e  b
5  f  c

def count_entries(df,col_name):
    """ Return a dictionary with counts of occurrences as value for each key"""
    return df[col_name].value_counts().to_dict()

Or use collections.Counter:

from collections import Counter

def count_entries(df,col_name):
    """ Return a dictionary with counts of occurrences as value for each key"""
    return dict(Counter(df[col_name]))

result = count_entries(df, 'F')
print (result)
{'a': 3, 'b': 2, 'c': 1}

answered Dec 2, 2018 at 9:46

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Collectives™ on Stack Overflow

AttributeError: 'int' object has no attribute 'keys'

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related