Produce time series data in a JSON file using python












0














I am trying to produce the following JSON structure via python. This was taken from the mongoDB web site



{
timestamp_hour: ISODate("2013-10-10T23:00:00.000Z"),
type: “memory_used”,
values: {
0: { 0: 999999, 1: 999999, …, 59: 1000000 },
1: { 0: 2000000, 1: 2000000, …, 59: 1000000 },
…,
58: { 0: 1600000, 1: 1200000, …, 59: 1100000 },
59: { 0: 1300000, 1: 1400000, …, 59: 1500000 }
}
}


So far I have the following:



import json
import random

data = {}
data['type'] = "memory_used"
data['timeStamp_Hour'] = "2018-10-01T00:00:00.000Z"
data['values'] =

for x in range(59):
for y in range(59):
data['values'].append({
x : round(random.uniform(0, 100), 2)
})

with open('data.txt', 'w') as outfile:
json.dump(data, outfile)


Which gives me:



{
"type": "memory_used",
"timeStamp_Hour": "2018-10-01T00:00:00.000Z",
"values": [
{
"0": 9.8
},
{
"0": 33.61
},
......


I am not sure how to structure the loop so I can append to the values section.










share|improve this question



























    0














    I am trying to produce the following JSON structure via python. This was taken from the mongoDB web site



    {
    timestamp_hour: ISODate("2013-10-10T23:00:00.000Z"),
    type: “memory_used”,
    values: {
    0: { 0: 999999, 1: 999999, …, 59: 1000000 },
    1: { 0: 2000000, 1: 2000000, …, 59: 1000000 },
    …,
    58: { 0: 1600000, 1: 1200000, …, 59: 1100000 },
    59: { 0: 1300000, 1: 1400000, …, 59: 1500000 }
    }
    }


    So far I have the following:



    import json
    import random

    data = {}
    data['type'] = "memory_used"
    data['timeStamp_Hour'] = "2018-10-01T00:00:00.000Z"
    data['values'] =

    for x in range(59):
    for y in range(59):
    data['values'].append({
    x : round(random.uniform(0, 100), 2)
    })

    with open('data.txt', 'w') as outfile:
    json.dump(data, outfile)


    Which gives me:



    {
    "type": "memory_used",
    "timeStamp_Hour": "2018-10-01T00:00:00.000Z",
    "values": [
    {
    "0": 9.8
    },
    {
    "0": 33.61
    },
    ......


    I am not sure how to structure the loop so I can append to the values section.










    share|improve this question

























      0












      0








      0







      I am trying to produce the following JSON structure via python. This was taken from the mongoDB web site



      {
      timestamp_hour: ISODate("2013-10-10T23:00:00.000Z"),
      type: “memory_used”,
      values: {
      0: { 0: 999999, 1: 999999, …, 59: 1000000 },
      1: { 0: 2000000, 1: 2000000, …, 59: 1000000 },
      …,
      58: { 0: 1600000, 1: 1200000, …, 59: 1100000 },
      59: { 0: 1300000, 1: 1400000, …, 59: 1500000 }
      }
      }


      So far I have the following:



      import json
      import random

      data = {}
      data['type'] = "memory_used"
      data['timeStamp_Hour'] = "2018-10-01T00:00:00.000Z"
      data['values'] =

      for x in range(59):
      for y in range(59):
      data['values'].append({
      x : round(random.uniform(0, 100), 2)
      })

      with open('data.txt', 'w') as outfile:
      json.dump(data, outfile)


      Which gives me:



      {
      "type": "memory_used",
      "timeStamp_Hour": "2018-10-01T00:00:00.000Z",
      "values": [
      {
      "0": 9.8
      },
      {
      "0": 33.61
      },
      ......


      I am not sure how to structure the loop so I can append to the values section.










      share|improve this question













      I am trying to produce the following JSON structure via python. This was taken from the mongoDB web site



      {
      timestamp_hour: ISODate("2013-10-10T23:00:00.000Z"),
      type: “memory_used”,
      values: {
      0: { 0: 999999, 1: 999999, …, 59: 1000000 },
      1: { 0: 2000000, 1: 2000000, …, 59: 1000000 },
      …,
      58: { 0: 1600000, 1: 1200000, …, 59: 1100000 },
      59: { 0: 1300000, 1: 1400000, …, 59: 1500000 }
      }
      }


      So far I have the following:



      import json
      import random

      data = {}
      data['type'] = "memory_used"
      data['timeStamp_Hour'] = "2018-10-01T00:00:00.000Z"
      data['values'] =

      for x in range(59):
      for y in range(59):
      data['values'].append({
      x : round(random.uniform(0, 100), 2)
      })

      with open('data.txt', 'w') as outfile:
      json.dump(data, outfile)


      Which gives me:



      {
      "type": "memory_used",
      "timeStamp_Hour": "2018-10-01T00:00:00.000Z",
      "values": [
      {
      "0": 9.8
      },
      {
      "0": 33.61
      },
      ......


      I am not sure how to structure the loop so I can append to the values section.







      python






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 23 '18 at 11:17









      SilentbobSilentbob

      93062446




      93062446
























          1 Answer
          1






          active

          oldest

          votes


















          2














          Looks like the values is meant to be Dict[int, Dict[int,int]] rather than a list as you have.



          ...
          data['values'] = {}

          for x in range(59):
          d={}
          for y in range(59):
          d[y]=round(random.uniform(0, 100), 2)
          data['values'][x]= d
          ...





          share|improve this answer























          • I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
            – Silentbob
            Nov 23 '18 at 12:13










          • You had an extra ) at the end of that line, works without it.
            – Silentbob
            Nov 23 '18 at 12:17










          • Thanks, I edited it.
            – Joshua Fox
            Nov 23 '18 at 13:40











          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%2f53445696%2fproduce-time-series-data-in-a-json-file-using-python%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          2














          Looks like the values is meant to be Dict[int, Dict[int,int]] rather than a list as you have.



          ...
          data['values'] = {}

          for x in range(59):
          d={}
          for y in range(59):
          d[y]=round(random.uniform(0, 100), 2)
          data['values'][x]= d
          ...





          share|improve this answer























          • I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
            – Silentbob
            Nov 23 '18 at 12:13










          • You had an extra ) at the end of that line, works without it.
            – Silentbob
            Nov 23 '18 at 12:17










          • Thanks, I edited it.
            – Joshua Fox
            Nov 23 '18 at 13:40
















          2














          Looks like the values is meant to be Dict[int, Dict[int,int]] rather than a list as you have.



          ...
          data['values'] = {}

          for x in range(59):
          d={}
          for y in range(59):
          d[y]=round(random.uniform(0, 100), 2)
          data['values'][x]= d
          ...





          share|improve this answer























          • I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
            – Silentbob
            Nov 23 '18 at 12:13










          • You had an extra ) at the end of that line, works without it.
            – Silentbob
            Nov 23 '18 at 12:17










          • Thanks, I edited it.
            – Joshua Fox
            Nov 23 '18 at 13:40














          2












          2








          2






          Looks like the values is meant to be Dict[int, Dict[int,int]] rather than a list as you have.



          ...
          data['values'] = {}

          for x in range(59):
          d={}
          for y in range(59):
          d[y]=round(random.uniform(0, 100), 2)
          data['values'][x]= d
          ...





          share|improve this answer














          Looks like the values is meant to be Dict[int, Dict[int,int]] rather than a list as you have.



          ...
          data['values'] = {}

          for x in range(59):
          d={}
          for y in range(59):
          d[y]=round(random.uniform(0, 100), 2)
          data['values'][x]= d
          ...






          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited Nov 23 '18 at 13:45

























          answered Nov 23 '18 at 11:20









          Joshua FoxJoshua Fox

          7,85495177




          7,85495177












          • I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
            – Silentbob
            Nov 23 '18 at 12:13










          • You had an extra ) at the end of that line, works without it.
            – Silentbob
            Nov 23 '18 at 12:17










          • Thanks, I edited it.
            – Joshua Fox
            Nov 23 '18 at 13:40


















          • I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
            – Silentbob
            Nov 23 '18 at 12:13










          • You had an extra ) at the end of that line, works without it.
            – Silentbob
            Nov 23 '18 at 12:17










          • Thanks, I edited it.
            – Joshua Fox
            Nov 23 '18 at 13:40
















          I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
          – Silentbob
          Nov 23 '18 at 12:13




          I get a syntax error on the line d[y]=round(random.uniform(0, 100), 2) )
          – Silentbob
          Nov 23 '18 at 12:13












          You had an extra ) at the end of that line, works without it.
          – Silentbob
          Nov 23 '18 at 12:17




          You had an extra ) at the end of that line, works without it.
          – Silentbob
          Nov 23 '18 at 12:17












          Thanks, I edited it.
          – Joshua Fox
          Nov 23 '18 at 13:40




          Thanks, I edited it.
          – Joshua Fox
          Nov 23 '18 at 13:40


















          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.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • 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%2f53445696%2fproduce-time-series-data-in-a-json-file-using-python%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

          What visual should I use to simply compare current year value vs last year in Power BI desktop

          Alexandru Averescu

          Trompette piccolo