Getting error Nonetype in python 2.7

Question

I am getting the error:

Traceback (most recent call last):
  File "<stdin>", line 9, in <module>
AttributeError: 'NoneType' object has no attribute 'get'

Is there something wrong with the following script? I am using get() in the script because of some phone field names missing in Mongodb collections.

The sample data:

{
    "_id": ObjectID("57e99f88b948da6c3be04366"),
    "email": "[email protected]",
    "phone": [
        {
            "type": "Mobile",
            "number": "250-851-1041"
        }
    ]}

the python script :

import codecs
import csv
cursor = db.users.find ({}, {'_id':1, 'email': 1, 'phone.type':1, 'phone.number':1})
with codecs.open('applicatonmethod3.csv', 'w', encoding='utf-8') as outfile:        
        fields = ['_id', 'email', 'phone.type', 'phone.number'] 
        write = csv.DictWriter(outfile, fieldnames=fields)
        write.writeheader()    
        for x in cursor:
            x_id = x.get('_id')
            x_email = x['email']            
            y = x.get('phone')            
            z = {'_id': x_id,
                'email': x_email,
                'phone.type': y.get('type'),
                'phone.number': y.get('number')}                               
            write.writerow(z)

please someone can help me.

Run it through a debugger or print things. For starters, print(x) just inside the for loop. — Alex Hall
– Alex Hall, Commented Nov 2, 2016 at 21:22
The error means that x is None, which means cursor contains None. Figure out why that is happening. — kindall
– kindall, Commented Nov 2, 2016 at 21:33
I checked data in the collection that there are not phone field name in some rows. that is why I use get() to skip them. thanks — user7070824
– user7070824, Commented Nov 2, 2016 at 21:38

Richard Carter · Accepted Answer · 2016-11-02 23:28:26Z

1

Are you connected to the correct database, the one that contains the users collection and not just the default database?

answered Nov 2, 2016 at 23:28

Richard Carter

112 bronze badges

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

3 Comments

user7070824 Over a year ago

yes, I connected to the correct database by using pymongo.

vighanesh mandavkar Over a year ago

ubuntuforums.org/showthread.php?t=2262024 follow this link it may help you not sure,just give a try

user7070824 Over a year ago

it worked after changed y = x.get('phone') to for y in x.get('phone', {}): but I got the repeated rows. Can someone know how to fix it?

user7070824 · Accepted Answer · 2016-11-04 17:21:09Z

I worked out the problem. I just share it with you. here is the solution. thanks you for help.

import sys
reload(sys)
sys.setdefaultencoding('utf-8')
import codecs
import csv
cursor = db.users.find ({}, {'_id':1, 'phone.type':1, 'phone.number':1, 'phone.extension':1})
with codecs.open('phone.csv', 'w', encoding='utf-8') as outfile:        
        fields =['_id', 'phone.type', 'phone.number', 'phone.extension'] 
        write = csv.DictWriter(outfile, fieldnames=fields)
        write.writeheader()    
        for x in cursor:
            x_id = x['_id']                                        
            for y in x.get('phone', {}):                                                                        
                z = {'_id': x_id,                                    
                    'phone.type': y.get('type'),
                    'phone.number': y.get('number'),
                    'phone.extension': y.get('extension')}
                print z                                                                                              
                write.writerow(z) 

cursor.close()

Collectives™ on Stack Overflow

Getting error Nonetype in python 2.7

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related