In [1]:
import pandas as pd
In [2]:
df = pd.read_json("random.json")
In [3]:
df.head()
Out[3]:
_id about address age balance company email eyeColor favoriteFruit friends ... guid index isActive latitude longitude name phone picture registered tags
0 5cc095cd3bb1d8db94ae0298 Qui quis dolore magna tempor ipsum nostrud. De... 527 Kane Street, Wakulla, Arkansas, 3271 22 $2,454.67 COMFIRM wareolson@comfirm.com green banana [{'id': 0, 'name': 'Mcclain Reynolds'}, {'id':... ... d80bf481-8600-4060-aa46-c0bbfb851565 0 False 33.173757 118.301423 Ware Olson +1 (893) 474-3269 http://placehold.it/32x32 2016-11-17T07:42:27 -00:00 [ea, qui, excepteur, pariatur, quis, eu, amet]
1 5cc095cd5db59db376e474a2 Voluptate mollit dolor enim magna. Aliquip aut... 939 National Drive, Finderne, Guam, 9661 32 $3,329.84 BLEENDOT janiewatson@bleendot.com green strawberry [{'id': 0, 'name': 'Chang Shields'}, {'id': 1,... ... adbe793a-7140-451b-8363-e71570101f5d 1 False 49.463498 -20.295514 Janie Watson +1 (979) 595-3274 http://placehold.it/32x32 2019-01-16T12:44:14 -00:00 [amet, tempor, laboris, velit, voluptate, ad, ...
2 5cc095cd0551db37967572f3 Sunt non quis non sint id cupidatat sit labore... 806 Montana Place, Floris, Oklahoma, 1854 29 $1,512.75 PRINTSPAN rosalynmoon@printspan.com green banana [{'id': 0, 'name': 'Tricia Heath'}, {'id': 1, ... ... a2420ae7-16f6-489f-913b-711a842ec1f1 2 True -39.273096 -48.150869 Rosalyn Moon +1 (986) 559-2880 http://placehold.it/32x32 2016-01-07T01:34:48 -00:00 [esse, sint, ad, incididunt, aliquip, incididu...
3 5cc095cd6b91b0808c417ec3 Do deserunt commodo labore officia officia. In... 997 Highland Avenue, Glidden, American Samoa, ... 32 $1,121.81 COMBOGENE francislawrence@combogene.com brown apple [{'id': 0, 'name': 'Katelyn Cantrell'}, {'id':... ... 785d237a-9584-4911-b2a7-bae51f8ba12f 3 False 43.047739 177.235031 Francis Lawrence +1 (817) 478-2690 http://placehold.it/32x32 2018-03-20T02:21:36 -00:00 [proident, velit, tempor, commodo, officia, am...
4 5cc095cdf3f69ad62a6aa01c Laborum sunt voluptate laboris minim dolore ei... 402 Judge Street, Gilgo, Texas, 4747 37 $1,645.50 CANOPOLY huffochoa@canopoly.com blue banana [{'id': 0, 'name': 'Sally Beasley'}, {'id': 1,... ... ba77ddef-6d46-4f80-b114-3cf63117e932 4 True 26.937567 -1.433873 Huff Ochoa +1 (962) 535-2924 http://placehold.it/32x32 2016-09-03T10:24:40 -01:00 [eiusmod, culpa, dolore, amet, nisi, minim, ex...

5 rows × 22 columns

In [4]:
pd.read_json(pd.read_json(df.friends.to_json()).T.iloc[:,0].to_json()).T
Out[4]:
id name
0 0 Mcclain Reynolds
1 0 Chang Shields
2 0 Tricia Heath
3 0 Katelyn Cantrell
4 0 Sally Beasley