我正在尝试学习Google App脚本,因为我觉得它对我的工作非常有用 . 我在下面粘贴的数据是我从外部API获得的数据,截断的版本显示了我们其中一个网站过去14天的需求和网络访问量 . 我需要您的帮助才能获取此数据并将其以常规表格格式粘贴到Google表格中 .
{"chart":{"renderTo":"container","defaultSeriesType":"line"},"title":{"text":"Test data"},"xAxis":{"categories":["2018-11-18 00:00:00","2018-11-19 00:00:00","2018-11-20 00:00:00","2018-11-21 00:00:00","2018-11-22 00:00:00","2018-11-23 00:00:00","2018-11-24 00:00:00","2018-11-25 00:00:00","2018-11-26 00:00:00","2018-11-27 00:00:00","2018-11-28 00:00:00","2018-11-29 00:00:00","2018-11-30 00:00:00","2018-12-01 00:00:00"],"title":{"text":null},"labels":{"rotation":-90,"step":1,"align":"right"}},"yAxis":{"plotLines":[{"value":0,"width":1,"color":"#808080"}],"title":{"text":null},"startOnTick":false},"legend":{"symbolPadding":1,"symbolWidth":10,"enabled":true},"plotOptions":{"pie":{"dataLabels":{"enabled":"false"}}},"series":[{"name":"Web Demand","data":[["2018-11-18 00:00:00",91829.33],["2018-11-19 00:00:00",70922.5],["2018-11-20 00:00:00",71637.51],["2018-11-21 00:00:00",87323.88],["2018-11-22 00:00:00",110634.95],["2018-11-23 00:00:00",189215.81],["2018-11-24 00:00:00",146681.11],["2018-11-25 00:00:00",229967.43],["2018-11-26 00:00:00",330220.47],["2018-11-27 00:00:00",137886.3],["2018-11-28 00:00:00",108642.67],["2018-11-29 00:00:00",126365.65],["2018-11-30 00:00:00",140458.59],["2018-12-01 00:00:00",181448.12]]},{"name":"Web Visits","data":[["2018-11-18 00:00:00",52167],["2018-11-19 00:00:00",39785],["2018-11-20 00:00:00",50454],["2018-11-21 00:00:00",51053],["2018-11-22 00:00:00",59999],["2018-11-23 00:00:00",92882],["2018-11-24 00:00:00",78601],["2018-11-25 00:00:00",99010],["2018-11-26 00:00:00",111094],["2018-11-27 00:00:00",79914],["2018-11-28 00:00:00",51760],["2018-11-29 00:00:00",60145],["2018-11-30 00:00:00",63811],["2018-12-01 00:00:00",65633]]},
在我的python脚本中,可以使用pd.read_csv()将此数据放入数据框中 . 我无法弄清楚如何使用谷歌应用程序脚本 . 理想情况下,我希望看到数据如下所示:
谢谢你的帮助!
1 回答
将此作为从外部API获取的样本数据
您可以使用它来提取/格式化数据
希望它有所帮助!