How to read a JSON object in Pandas dataframe
I am developing a service that receives a POST request with a JSON data packet. After receiving, the service needs to send this JSON object to another method where it needs to convert it to Pandas dataframe.
I know Pandas read_json method expects file. But I do now have a file and I do not want to write a file. How do I resolve this?
@app.route('/data/api/json',methods=['POST'])
def getData():
content=jsonify(request.json)
#return content
process(content)
def process(jsonContent):
test = pd.read_json(jsonContent) #this will NOT work
python json pandas
asked Nov 25 '18 at 1:49
nadnad
57531326
add a comment |
I am developing a service that receives a POST request with a JSON data packet. After receiving, the service needs to send this JSON object to another method where it needs to convert it to Pandas dataframe.
I know Pandas read_json method expects file. But I do now have a file and I do not want to write a file. How do I resolve this?
@app.route('/data/api/json',methods=['POST'])
def getData():
content=jsonify(request.json)
#return content
process(content)
def process(jsonContent):
test = pd.read_json(jsonContent) #this will NOT work
python json pandas
asked Nov 25 '18 at 1:49
nadnad
57531326
1
If it is already loaded as a python dictionary, usepd.io.json.json_normalize(data).
– coldspeed
Nov 25 '18 at 2:23
add a comment |
I am developing a service that receives a POST request with a JSON data packet. After receiving, the service needs to send this JSON object to another method where it needs to convert it to Pandas dataframe.
I know Pandas read_json method expects file. But I do now have a file and I do not want to write a file. How do I resolve this?
@app.route('/data/api/json',methods=['POST'])
def getData():
content=jsonify(request.json)
#return content
process(content)
def process(jsonContent):
test = pd.read_json(jsonContent) #this will NOT work
python json pandas
asked Nov 25 '18 at 1:49
nadnad
57531326
I am developing a service that receives a POST request with a JSON data packet. After receiving, the service needs to send this JSON object to another method where it needs to convert it to Pandas dataframe.
I know Pandas read_json method expects file. But I do now have a file and I do not want to write a file. How do I resolve this?
@app.route('/data/api/json',methods=['POST'])
def getData():
content=jsonify(request.json)
#return content
process(content)
def process(jsonContent):
test = pd.read_json(jsonContent) #this will NOT work
python json pandas
python json pandas
asked Nov 25 '18 at 1:49
nadnad
57531326
asked Nov 25 '18 at 1:49
nadnad
57531326
asked Nov 25 '18 at 1:49
nadnad
57531326
asked Nov 25 '18 at 1:49
nadnad
57531326
asked Nov 25 '18 at 1:49
nadnad
57531326
57531326
1
If it is already loaded as a python dictionary, usepd.io.json.json_normalize(data).
– coldspeed
Nov 25 '18 at 2:23
add a comment |
1
If it is already loaded as a python dictionary, usepd.io.json.json_normalize(data).
– coldspeed
Nov 25 '18 at 2:23
1
1
If it is already loaded as a python dictionary, use
pd.io.json.json_normalize(data).– coldspeed
Nov 25 '18 at 2:23
If it is already loaded as a python dictionary, use
pd.io.json.json_normalize(data).– coldspeed
Nov 25 '18 at 2:23
add a comment |
2 Answers
2
active
oldest
votes
It depends a bit on how your JSON is structured, so if none of the suggestions work please share a simple example of your JSON file. For files looking like
[{col1:foo, col2: bar},{col1:footwo, col2:bartwo}]
I usually use
import pandas as pd
df = pd.io.json.json_normalize(data)
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
add a comment |
You can convert your string to a file-like buffer:
import io
test = pd.read_json(io.StringIO(jsonContent))
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53463997%2fhow-to-read-a-json-object-in-pandas-dataframe%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
It depends a bit on how your JSON is structured, so if none of the suggestions work please share a simple example of your JSON file. For files looking like
[{col1:foo, col2: bar},{col1:footwo, col2:bartwo}]
I usually use
import pandas as pd
df = pd.io.json.json_normalize(data)
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
add a comment |
It depends a bit on how your JSON is structured, so if none of the suggestions work please share a simple example of your JSON file. For files looking like
[{col1:foo, col2: bar},{col1:footwo, col2:bartwo}]
I usually use
import pandas as pd
df = pd.io.json.json_normalize(data)
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
add a comment |
It depends a bit on how your JSON is structured, so if none of the suggestions work please share a simple example of your JSON file. For files looking like
[{col1:foo, col2: bar},{col1:footwo, col2:bartwo}]
I usually use
import pandas as pd
df = pd.io.json.json_normalize(data)
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
It depends a bit on how your JSON is structured, so if none of the suggestions work please share a simple example of your JSON file. For files looking like
[{col1:foo, col2: bar},{col1:footwo, col2:bartwo}]
I usually use
import pandas as pd
df = pd.io.json.json_normalize(data)
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
answered Nov 25 '18 at 2:04
sgtbpsgtbp
556
556
add a comment |
add a comment |
You can convert your string to a file-like buffer:
import io
test = pd.read_json(io.StringIO(jsonContent))
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
add a comment |
You can convert your string to a file-like buffer:
import io
test = pd.read_json(io.StringIO(jsonContent))
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
add a comment |
You can convert your string to a file-like buffer:
import io
test = pd.read_json(io.StringIO(jsonContent))
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
You can convert your string to a file-like buffer:
import io
test = pd.read_json(io.StringIO(jsonContent))
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
answered Nov 25 '18 at 1:54
DYZDYZ
26.8k62049
26.8k62049
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53463997%2fhow-to-read-a-json-object-in-pandas-dataframe%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
If it is already loaded as a python dictionary, use
pd.io.json.json_normalize(data).– coldspeed
Nov 25 '18 at 2:23