result = self._cmysql.convert_to_mysql(*params) _mysql_connector.MySQLInterfaceError: Python type NAType cannot be converted

Python Help
1

for provider in provider_list:
# print(provider)

name=provider['Provider First Name']+" "+provider['Provider Last Name (Legal Name)']
# provider[0]
zipcode=provider['Provider Business Mailing Address Postal Code'].astype(str).str[:4]


pro_data=list(zip(provider['Provider Name Prefix Text'],name,provider['NPI'],provider['Provider Business Mailing Address Telephone Number'],
               provider['Provider Business Practice Location Address Telephone Number'],provider['Provider Business Mailing Address Fax Number'],
               provider['Provider First Name'],provider['Provider Middle Name'],provider['Provider Last Name (Legal Name)'],
               provider['Provider Credential Text'],provider['Provider First Line Business Mailing Address'],provider['Provider First Line Business Practice Location Address'],
               provider['Provider Business Mailing Address City Name'],provider['Provider Business Mailing Address State Name'],zipcode,
               provider['Provider License Number_1'],provider['Healthcare Provider Taxonomy Code_1']))
print(type(pro_data))

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='equipo',
                                         user='root',
                                         password='NewAccount@123')
    cursor = connection.cursor()
    q = """insert into m_provider_temp (title,name,npi,contactnumber,phone_home,fax,first_name,middle_name,last_name,credentials,address,address2,city,state,zipcode,
license_number,taxonomy_code)values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"""




    try:
        print(q)
        cursor.executemany(q, pro_data)
        connection.commit()
        print("‘success’")
    except (mysql.connector.Error, mysql.connector.Warning) as e:
        print(e)




except mysql.connector.Error as error:
    print("Failed to get record from MySQL table: {}".format(error))

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
2

Helps us to help you if you ask a question.
I am going to guess that you want to why NAType is on the error message?
I have not looked, but I guess that it cannot be converted to a string.

Try using str() on your NAType object to see if my guess is correct.