url = 'https://api.github.com/repos/pandas-dev/pandas/issues' resp = requests.get(url) data = resp.json() print(pd.DataFrame(data,columns=['number','title','labels','state'])) ==> number ... state 028452 ... open 128451 ... open 228448 ... open 328447 ... open 428446 ... open 528444 ... open 628443 ... open 728442 ... open 828441 ... open 928440 ... open 1028438 ... open 1128436 ... open 1228435 ... open 1328434 ... open 1428433 ... open 1528432 ... open 1628431 ... open 1728430 ... open 1828429 ... open 1928428 ... open 2028427 ... open 2128426 ... open 2228425 ... open 2328424 ... open 2428423 ... open 2528422 ... open 2628418 ... open 2728417 ... open 2828415 ... open 2928414 ... open