[IPython-dev] ValueError: arrays must all be same length

E. Madison Bray erik.m.bray at gmail.com
Fri Oct 2 12:44:31 EDT 2020


Hello,

This (mostly defunct) mailing list is for discussing use and
development of IPython; it is not for help with general programming
questions.

The error you're getting is because DataFrame.from_dict [1] doesn't
somehow convert any arbitrary structure of nested dictionaries to a
DataFrame.  It expects a dict mapping column names to homogeneously
sized lists/arrays forming the data for those columns.

If you need more follow-up help try stackoverflow.com

[1] https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.from_dict.html

On Fri, Oct 2, 2020 at 2:17 PM davidgshi at yahoo.co.uk
<davidgshi at yahoo.co.uk> wrote:
>
> Hello,
>
> I got a json response from an API and tried to use pandas to put data into a dataframe.
>
> However, I kept getting this ValueError: arrays must all be same length.
>
> Can anyone help?
>
> The following is the json text.  Regards, Shao
>
> {
>   "locationId": "1-1004508435",
>   "providerId": "1-101641521",
>   "organisationType": "Location",
>   "type": "Social Care Org",
>   "name": "Meadow Rose Nursing Home",
>   "brandId": "BD510",
>   "brandName": "BRAND MACC Care",
>   "onspdCcgCode": "E38000220",
>   "onspdCcgName": "NHS Birmingham and Solihull CCG",
>   "odsCode": "VM4G9",
>   "uprn": "100070537642",
>   "registrationStatus": "Registered",
>   "registrationDate": "2013-12-16",
>   "dormancy": "N",
>   "numberOfBeds": 56,
>   "postalAddressLine1": "96 The Roundabout",
>   "postalAddressTownCity": "Birmingham",
>   "postalAddressCounty": "West Midlands",
>   "region": "West Midlands",
>   "postalCode": "B31 2TX",
>   "onspdLatitude": 52.399843,
>   "onspdLongitude": -1.989241,
>   "careHome": "Y",
>   "inspectionDirectorate": "Adult social care",
>   "mainPhoneNumber": "01214769808",
>   "constituency": "Birmingham, Northfield",
>   "localAuthority": "Birmingham",
>   "lastInspection": {
>     "date": "2020-06-24"
>   },
>   "lastReport": {
>     "publicationDate": "2020-10-01"
>   },
>   "relationships": [
>
>   ],
>   "locationTypes": [
>
>   ],
>   "regulatedActivities": [
>     {
>       "name": "Accommodation for persons who require nursing or personal care",
>       "code": "RA2",
>       "contacts": [
>         {
>           "personTitle": "Mr",
>           "personGivenName": "Steven",
>           "personFamilyName": "Kazembe",
>           "personRoles": [
>             "Registered Manager"
>           ]
>         }
>       ]
>     },
>     {
>       "name": "Treatment of disease, disorder or injury",
>       "code": "RA5",
>       "contacts": [
>         {
>           "personTitle": "Mr",
>           "personGivenName": "Steven",
>           "personFamilyName": "Kazembe",
>           "personRoles": [
>             "Registered Manager"
>           ]
>         }
>       ]
>     }
>   ],
>   "gacServiceTypes": [
>     {
>       "name": "Nursing homes",
>       "description": "Care home service with nursing"
>     }
>   ],
>   "inspectionCategories": [
>     {
>       "code": "S1",
>       "primary": "true",
>       "name": "Residential social care"
>     }
>   ],
>   "specialisms": [
>     {
>       "name": "Caring for adults over 65 yrs"
>     },
>     {
>       "name": "Caring for adults under 65 yrs"
>     },
>     {
>       "name": "Dementia"
>     },
>     {
>       "name": "Physical disabilities"
>     }
>   ],
>   "inspectionAreas": [
>
>   ],
>   "currentRatings": {
>     "overall": {
>       "rating": "Requires improvement",
>       "reportDate": "2020-10-01",
>       "reportLinkId": "1157c975-c2f1-423e-a2b4- 66901779e014",
>       "useOfResources": {
>
>       },
>       "keyQuestionRatings": [
>         {
>           "name": "Safe",
>           "rating": "Requires improvement",
>           "reportDate": "2020-10-01",
>           "reportLinkId": "1157c975-c2f1-423e-a2b4- 66901779e014"
>         },
>         {
>           "name": "Well-led",
>           "rating": "Requires improvement",
>           "reportDate": "2020-10-01",
>           "reportLinkId": "1157c975-c2f1-423e-a2b4- 66901779e014"
>         },
>         {
>           "name": "Caring",
>           "rating": "Good",
>           "reportDate": "2019-10-04",
>           "reportLinkId": "63ff05ec-4d31-406e-83de- 49a271cfdc43"
>         },
>         {
>           "name": "Responsive",
>           "rating": "Good",
>           "reportDate": "2019-10-04",
>           "reportLinkId": "63ff05ec-4d31-406e-83de- 49a271cfdc43"
>         },
>         {
>           "name": "Effective",
>           "rating": "Requires improvement",
>           "reportDate": "2019-10-04",
>           "reportLinkId": "63ff05ec-4d31-406e-83de- 49a271cfdc43"
>         }
>       ]
>     },
>     "reportDate": "2020-10-01"
>   },
>   "historicRatings": [
>     {
>       "reportLinkId": "63ff05ec-4d31-406e-83de- 49a271cfdc43",
>       "reportDate": "2019-10-04",
>       "overall": {
>         "rating": "Requires improvement",
>         "keyQuestionRatings": [
>           {
>             "name": "Safe",
>             "rating": "Requires improvement"
>           },
>           {
>             "name": "Well-led",
>             "rating": "Requires improvement"
>           }
>         ]
>       }
>     },
>     {
>       "reportLinkId": "4f20da40-89a4-4c45-a7f9- bfd52b48f286",
>       "reportDate": "2017-09-08",
>       "overall": {
>         "rating": "Good",
>         "keyQuestionRatings": [
>           {
>             "name": "Safe",
>             "rating": "Good"
>           },
>           {
>             "name": "Well-led",
>             "rating": "Good"
>           },
>           {
>             "name": "Caring",
>             "rating": "Good"
>           },
>           {
>             "name": "Responsive",
>             "rating": "Good"
>           },
>           {
>             "name": "Effective",
>             "rating": "Requires improvement"
>           }
>         ]
>       }
>     },
>     {
>       "reportLinkId": "0cc4226b-401e-4f0f-ba35- 062cbadffa8f",
>       "reportDate": "2016-06-11",
>       "overall": {
>         "rating": "Requires improvement",
>         "keyQuestionRatings": [
>           {
>             "name": "Safe",
>             "rating": "Requires improvement"
>           },
>           {
>             "name": "Well-led",
>             "rating": "Requires improvement"
>           },
>           {
>             "name": "Caring",
>             "rating": "Requires improvement"
>           },
>           {
>             "name": "Responsive",
>             "rating": "Requires improvement"
>           },
>           {
>             "name": "Effective",
>             "rating": "Good"
>           }
>         ]
>       }
>     },
>     {
>       "reportLinkId": "a11c1e52-ddfd-4cd8-8b56- 1b96ac287c96",
>       "reportDate": "2015-01-12",
>       "overall": {
>         "rating": "Good",
>         "keyQuestionRatings": [
>           {
>             "name": "Safe",
>             "rating": "Good"
>           },
>           {
>             "name": "Well-led",
>             "rating": "Good"
>           },
>           {
>             "name": "Caring",
>             "rating": "Good"
>           },
>           {
>             "name": "Responsive",
>             "rating": "Requires improvement"
>           },
>           {
>             "name": "Effective",
>             "rating": "Good"
>           }
>         ]
>       }
>     }
>   ],
>   "reports": [
>     {
>       "linkId": "1157c975-c2f1-423e-a2b4- 66901779e014",
>       "reportDate": "2020-10-01",
>       "reportUri": "/reports/1157c975-c2f1-423e- a2b4-66901779e014",
>       "firstVisitDate": "2020-06-23",
>       "reportType": "Location"
>     },
>     {
>       "linkId": "63ff05ec-4d31-406e-83de- 49a271cfdc43",
>       "reportDate": "2019-10-04",
>       "reportUri": "/reports/63ff05ec-4d31-406e- 83de-49a271cfdc43",
>       "firstVisitDate": "2019-08-28",
>       "reportType": "Location"
>     },
>     {
>       "linkId": "4f20da40-89a4-4c45-a7f9- bfd52b48f286",
>       "reportDate": "2017-09-08",
>       "reportUri": "/reports/4f20da40-89a4-4c45- a7f9-bfd52b48f286",
>       "firstVisitDate": "2017-07-19",
>       "reportType": "Location"
>     },
>     {
>       "linkId": "0cc4226b-401e-4f0f-ba35- 062cbadffa8f",
>       "reportDate": "2016-06-11",
>       "reportUri": "/reports/0cc4226b-401e-4f0f- ba35-062cbadffa8f",
>       "firstVisitDate": "2016-03-15",
>       "reportType": "Location"
>     },
>     {
>       "linkId": "a11c1e52-ddfd-4cd8-8b56- 1b96ac287c96",
>       "reportDate": "2015-01-12",
>       "reportUri": "/reports/a11c1e52-ddfd-4cd8- 8b56-1b96ac287c96",
>       "firstVisitDate": "2014-08-12",
>       "reportType": "Location"
>     }
>   ]
> }
>
> In [ ]:
>
>
> In [25]:
> j
>
>
> import pandas as pd
>
> import json
>
> j = json.JSONDecoder().decode(req. text)  ###req.json
>
> df = pd.DataFrame.from_dict(j)
>
>
>
>
> _______________________________________________
> IPython-dev mailing list
> IPython-dev at python.org
> https://mail.python.org/mailman/listinfo/ipython-dev


More information about the IPython-dev mailing list