[Pandas-dev] Loop over and add new columns

[Shaozhong SHI]

Hi, I got a very strange error with such a simple loop.

Can anyone explain why?

x={u'brandId': u'BD398',
 u'brandName': u'BRAND Innomary',
 u'careHome': u'Y',
 u'constituency': u'Hastings and Rye',
u'dormancy': u'N',
 u'inspectionAreas': [],
u'inspectionDirectorate': u'Adult social care',
 u'localAuthority': u'East Sussex',
 u'locationId': u'1-1000210669',

u'mainPhoneNumber': u'01424716303',
 u'name': u'Kingswood House Nursing Home',
 u'numberOfBeds': 22,
 u'odsCode': u'VM4G6',
 u'onspdCcgCode': u'E38000235',
 u'onspdCcgName': u'NHS East Sussex CCG',
 u'onspdLatitude': 50.857239,
 u'onspdLongitude': 0.561998,
 u'organisationType': u'Location',
 u'postalAddressCounty': u'East Sussex',
 u'postalAddressLine1': u'21-23 Chapel Park Road',
 u'postalAddressTownCity': u'St Leonards On Sea',
 u'postalCode': u'TN37 6HR',
 u'providerId': u'1-877912132',
 u'region': u'South East',
 u'registrationDate': u'2013-12-12',
 u'registrationStatus': u'Registered',

u'type': u'Social Care Org',
 u'uprn': u'100062576733'}

import pandas as pd
my_df =pd.DataFrame()
for col_name in x.items():
    my_df[col_name]=x[col_name]
my_df

Much obliged.

Regards,

David
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.python.org/pipermail/pandas-dev/attachments/20201116/2df9381b/attachment.html>