How to convert the below json data to dataFrame?Python - How to convert JSON File to DataframeHow to merge two dictionaries in a single expression?How do I check whether a file exists without exceptions?How do you split a list into evenly sized chunks?How to sort a dataframe by multiple column(s)Renaming columns in pandasAdding new column to existing DataFrame in Python pandasHow to iterate over rows in a DataFrame in Pandas?Select rows from a DataFrame based on values in a column in pandasGet list from pandas DataFrame column headersConvert list of dictionaries to a pandas DataFrame

In Japanese, what’s the difference between “Tonari ni” (となりに) and “Tsugi” (つぎ)? When would you use one over the other?

What's the point of deactivating Num Lock on login screens?

How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?

Dragon forelimb placement

Approximately how much travel time was saved by the opening of the Suez Canal in 1869?

Fencing style for blades that can attack from a distance

"You are your self first supporter", a more proper way to say it

What do the dots in this tr command do: tr .............A-Z A-ZA-Z <<< "JVPQBOV" (with 13 dots)

What do you call a Matrix-like slowdown and camera movement effect?

How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?

Why dont electromagnetic waves interact with each other?

Why are electrically insulating heatsinks so rare? Is it just cost?

The use of multiple foreign keys on same column in SQL Server

Can I make popcorn with any corn?

How to format long polynomial?

Are the number of citations and number of published articles the most important criteria for a tenure promotion?

Adding span tags within wp_list_pages list items

Test if tikzmark exists on same page

Why was the small council so happy for Tyrion to become the Master of Coin?

What would happen to a modern skyscraper if it rains micro blackholes?

Is it possible to do 50 km distance without any previous training?

How could an uplifted falcon's brain work?

Smoothness of finite-dimensional functional calculus

Why not use SQL instead of GraphQL?



How to convert the below json data to dataFrame?


Python - How to convert JSON File to DataframeHow to merge two dictionaries in a single expression?How do I check whether a file exists without exceptions?How do you split a list into evenly sized chunks?How to sort a dataframe by multiple column(s)Renaming columns in pandasAdding new column to existing DataFrame in Python pandasHow to iterate over rows in a DataFrame in Pandas?Select rows from a DataFrame based on values in a column in pandasGet list from pandas DataFrame column headersConvert list of dictionaries to a pandas DataFrame






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















The JSON file looks like this:



{
"mgch_7":
"plot":
"ra":
[
1547551080000,
24
],
[
1547551140000,
24
],
[
1547551200000,
24
],
[
1547551260000,
24
]
]
,
"user": ,
"maintainance":




In the DataFrame I want two columns, e.g.: 1547551080000 in one column and 24 in second column.










share|improve this question



















  • 4





    Possible duplicate of Python - How to convert JSON File to Dataframe

    – User2321
    Mar 21 at 17:22











  • I can't figure it out please help

    – Pronnati Ramtekkar
    Mar 21 at 17:43











  • that's not the same problem :)

    – Pronnati Ramtekkar
    Mar 21 at 17:44






  • 1





    That JSON is not valid. I believe you have an extra ] in there

    – ecortazar
    Mar 21 at 17:53











  • Also, that "set" of lists of pairs of values that you want to be converted should be a list of dictionaries in order for this to be a valid JSON (e.g., [1547551080000 : 24, 1547551140000, 24], or ['Val1': 1547551080000, 'Val2': 24, 'Val1': 1547551140000, 'Val2': 24]).

    – AlexK
    Mar 21 at 19:20

















0















The JSON file looks like this:



{
"mgch_7":
"plot":
"ra":
[
1547551080000,
24
],
[
1547551140000,
24
],
[
1547551200000,
24
],
[
1547551260000,
24
]
]
,
"user": ,
"maintainance":




In the DataFrame I want two columns, e.g.: 1547551080000 in one column and 24 in second column.










share|improve this question



















  • 4





    Possible duplicate of Python - How to convert JSON File to Dataframe

    – User2321
    Mar 21 at 17:22











  • I can't figure it out please help

    – Pronnati Ramtekkar
    Mar 21 at 17:43











  • that's not the same problem :)

    – Pronnati Ramtekkar
    Mar 21 at 17:44






  • 1





    That JSON is not valid. I believe you have an extra ] in there

    – ecortazar
    Mar 21 at 17:53











  • Also, that "set" of lists of pairs of values that you want to be converted should be a list of dictionaries in order for this to be a valid JSON (e.g., [1547551080000 : 24, 1547551140000, 24], or ['Val1': 1547551080000, 'Val2': 24, 'Val1': 1547551140000, 'Val2': 24]).

    – AlexK
    Mar 21 at 19:20













0












0








0








The JSON file looks like this:



{
"mgch_7":
"plot":
"ra":
[
1547551080000,
24
],
[
1547551140000,
24
],
[
1547551200000,
24
],
[
1547551260000,
24
]
]
,
"user": ,
"maintainance":




In the DataFrame I want two columns, e.g.: 1547551080000 in one column and 24 in second column.










share|improve this question
















The JSON file looks like this:



{
"mgch_7":
"plot":
"ra":
[
1547551080000,
24
],
[
1547551140000,
24
],
[
1547551200000,
24
],
[
1547551260000,
24
]
]
,
"user": ,
"maintainance":




In the DataFrame I want two columns, e.g.: 1547551080000 in one column and 24 in second column.







python pandas dataframe






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 21 at 23:57









halloleo

2,49652361




2,49652361










asked Mar 21 at 17:16









Pronnati RamtekkarPronnati Ramtekkar

11




11







  • 4





    Possible duplicate of Python - How to convert JSON File to Dataframe

    – User2321
    Mar 21 at 17:22











  • I can't figure it out please help

    – Pronnati Ramtekkar
    Mar 21 at 17:43











  • that's not the same problem :)

    – Pronnati Ramtekkar
    Mar 21 at 17:44






  • 1





    That JSON is not valid. I believe you have an extra ] in there

    – ecortazar
    Mar 21 at 17:53











  • Also, that "set" of lists of pairs of values that you want to be converted should be a list of dictionaries in order for this to be a valid JSON (e.g., [1547551080000 : 24, 1547551140000, 24], or ['Val1': 1547551080000, 'Val2': 24, 'Val1': 1547551140000, 'Val2': 24]).

    – AlexK
    Mar 21 at 19:20












  • 4





    Possible duplicate of Python - How to convert JSON File to Dataframe

    – User2321
    Mar 21 at 17:22











  • I can't figure it out please help

    – Pronnati Ramtekkar
    Mar 21 at 17:43











  • that's not the same problem :)

    – Pronnati Ramtekkar
    Mar 21 at 17:44






  • 1





    That JSON is not valid. I believe you have an extra ] in there

    – ecortazar
    Mar 21 at 17:53











  • Also, that "set" of lists of pairs of values that you want to be converted should be a list of dictionaries in order for this to be a valid JSON (e.g., [1547551080000 : 24, 1547551140000, 24], or ['Val1': 1547551080000, 'Val2': 24, 'Val1': 1547551140000, 'Val2': 24]).

    – AlexK
    Mar 21 at 19:20







4




4





Possible duplicate of Python - How to convert JSON File to Dataframe

– User2321
Mar 21 at 17:22





Possible duplicate of Python - How to convert JSON File to Dataframe

– User2321
Mar 21 at 17:22













I can't figure it out please help

– Pronnati Ramtekkar
Mar 21 at 17:43





I can't figure it out please help

– Pronnati Ramtekkar
Mar 21 at 17:43













that's not the same problem :)

– Pronnati Ramtekkar
Mar 21 at 17:44





that's not the same problem :)

– Pronnati Ramtekkar
Mar 21 at 17:44




1




1





That JSON is not valid. I believe you have an extra ] in there

– ecortazar
Mar 21 at 17:53





That JSON is not valid. I believe you have an extra ] in there

– ecortazar
Mar 21 at 17:53













Also, that "set" of lists of pairs of values that you want to be converted should be a list of dictionaries in order for this to be a valid JSON (e.g., [1547551080000 : 24, 1547551140000, 24], or ['Val1': 1547551080000, 'Val2': 24, 'Val1': 1547551140000, 'Val2': 24]).

– AlexK
Mar 21 at 19:20





Also, that "set" of lists of pairs of values that you want to be converted should be a list of dictionaries in order for this to be a valid JSON (e.g., [1547551080000 : 24, 1547551140000, 24], or ['Val1': 1547551080000, 'Val2': 24, 'Val1': 1547551140000, 'Val2': 24]).

– AlexK
Mar 21 at 19:20












0






active

oldest

votes












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
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55285874%2fhow-to-convert-the-below-json-data-to-dataframe%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































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.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55285874%2fhow-to-convert-the-below-json-data-to-dataframe%23new-answer', 'question_page');

);

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







Popular posts from this blog

Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript