python - Creating dataframe from json not always working -


i'm trying run code create data frame json link. sometimes, code run. other times, error message (below). i'm not sure why occurs, though code same.

import requests import json  url = "http://stats.nba.com/stats/leaguedashplayerstats?college=&conference=&country=&datefrom=&dateto=&division=&draftpick=&draftyear=&gamescope=&gamesegment=&height=&lastngames=0&leagueid=00&location=&measuretype=advanced&month=0&opponentteamid=0&outcome=&poround=0&paceadjust=n&permode=totals&period=0&playerexperience=&playerposition=&plusminus=n&rank=n&season=2016-17&seasonsegment=&seasontype=regular+season&shotclockrange=&starterbench=&teamid=0&vsconference=&vsdivision=&weight="  jd = requests.get(url).json()  df = [] item in requests.get(url).json()['resultsets']:     print("got here")     row_df = []     row in item['rowset']:         row_df.append(str(row).strip('[]'))     df.append("\n")     df.append(row_df)  print(df)

error message:

traceback (most recent call last): file "/users/k/pycharmprojects/mousefun/fun", line 8, in <module> jd = requests.get(url).json()  file "/library/frameworks/python.framework/versions/3.4/lib/python3.4/site-packages/requests/models.py", line 812, in json return complexjson.loads(self.text, **kwargs) file "/library/frameworks/python.framework/versions/3.4/lib/python3.4/json/__init__.py", line 318, in loads return _default_decoder.decode(s) file "/library/frameworks/python.framework/versions/3.4/lib/python3.4/json/decoder.py", line 343, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) file "/library/frameworks/python.framework/versions/3.4/lib/python3.4/json/decoder.py", line 361, in raw_decode raise valueerror(errmsg("expecting value", s, err.value)) none valueerror: expecting value: line 1 column 1 (char 0)

change request logic , try again:

r = requests.get(url) r.raise_for_status()  df = [] item in r.json()["resultsets"]:     # ...

r.raise_for_status() raise if status not ok .

also, not request 2 times code does.


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more