页面树结构
resultquestion_iddatasetIdconvIdendTime
[{"年":2015,"销量":"14612656.0","销售规模":"26230.96","车均价":"18.0"},{"年":2016,"销量":"16979284.0","销售规模":"27825.88","车均价":"18.0"},{"年":2017,"销量":"17731037.0","销售规模":"29819.36","车均价":"18.0"},{"年":2018,"销量":"18027197.0","销售规模":"30935.84","车均价":"17.0"},{"年":2019,"销量":"16403681.0","销售规模":"29151.53","车均价":"17.0"},{"年":2020,"销量":"1298712.0","销售规模":"2331.23","车均价":"17.0"}]各年份销量,规模,均价81bad642-48ec-44e6-a3c9-7b67cf7b0c29I8a8aa3ed019172c872c8914601919746178077c0a0adff1b-e530-4014-af6d-dc1bd42edbd91724821670655
[{"年月":"2018-04","销量":"1435212.0","销量同期值":"1199600.0","销量同比增长率":"19.64%"},{"年月":"2018-05","销量":"1417879.0","销量同期值":"1219951.0","销量同比增长率":"16.22%"},{"年月":"2018-06","销量":"1407239.0","销量同期值":"1307295.0","销量同比增长率":"7.65%"}]2018年Q2的各月份销量、同期值、同比78e22d02-28a9-4d6a-87f0-62717ee89eccI8a8aa3ed019172c872c8914601919746178077c084d35703-6d01-4fa9-876d-07647a1d9b3a1724821792914
[{"年月":"2018-04","销量":"1435212.0","销量前期值":"1584035.0","销量前期增长":"-148823.0","销量环比增长率":"-9.4%"},{"年月":"2018-05","销量":"1417879.0","销量前期值":"1435212.0","销量前期增长":"-17333.0","销量环比增长率":"-1.21%"},{"年月":"2018-06","销量":"1407239.0","销量前期值":"1417879.0","销量前期增长":"-10640.0","销量环比增长率":"-0.75%"}]2018年Q2的各月份销量、前期值、前期增长值、环比7ca22f44-f179-4551-931a-0601c74d4f7eI8a8aa3ed019172c872c8914601919746178077c068a7e524-3973-424d-8457-cd835fa32b691724821895359
[{"年月":"2018-04","销量":"1435212.0","销量同期值":"1199600.0","销量同期增量":"235612.0","销量同比增长率":"19.64%"},{"年月":"2018-05","销量":"1417879.0","销量同期值":"1219951.0","销量同期增量":"197928.0","销量同比增长率":"16.22%"},{"年月":"2018-06","销量":"1407239.0","销量同期值":"1307295.0","销量同期增量":"99944.0","销量同比增长率":"7.65%"}]2018年Q2的各月份销量、同期值、同期增长值、同比4ebd5175-91ec-4d1a-8f74-db83e159b220I8a8aa3ed019172c872c8914601919746178077c0406220dd-de28-4b4a-ac7f-bbf0240917cc1724822013602
[{"年月":"2018-01","销量":"1865384.0","销量同期值":"1582656.0","销量同期增量":"282728.0","销量同比增长率":"17.86%"}]2018年1月销量、同期值、同期增长、同比d4abf07c-d509-4483-b541-7cf41db7d871I8a8aa3ed019172c872c8914601919746178077c078e61c78-c082-4ef8-8b55-49ed85790ce31724822154112
[{"年月":"2018-05","销量":"1417879.0","销量年累计":"7399460.0","销量年累计同期值":"6571753.0","销量年累计同比增长率":"12.59%"}]2018年5月的销量、年累、年累同期值、年累同比921aaa5e-826c-4022-a5f7-40212263f9a1I8a8aa3ed019172c872c8914601919746178077c070acb2d3-002a-4533-9b2e-77d2740ab2fd1724825775143
[{"年":2017,"品牌":"大众","销量":"3082742.0"},{"年":2017,"品牌":"本田","销量":"1348841.0"},{"年":2017,"品牌":"吉利","销量":"1176068.0"}]2017年销量前3的品牌bba1d44a-2810-43c0-a704-b1eaf123ab6dI8a8aa3ed019172c872c8914601919746178077c01012cc89-06da-40fd-9e76-36663810c8ac1726052978591
[{"年":"2015","销量":"14612656.0"},{"年":"2016","销量":"16979284.0"},{"年":"2017","销量":"17731037.0"},{"年":"2018","销量":"18027197.0"},{"年":"2019","销量":"16403681.0"},{"年":"2020","销量":"1298712.0"}]看每年的销量4f8f2414-0935-4e8a-8ee1-8cbec3fbe12dI8a8aa3ed019172c872c8914601919746178077c00fb061fe-ff29-439c-b269-33a52d09dbc11726107846714
[{"年":"2019","年月":"2019-01","销量":"1595800.0","销量同比增长率":"-14.45%"},{"年":"2019","年月":"2019-02","销量":"935057.0","销量同比增长率":"-14.76%"},{"年":"2019","年月":"2019-03","销量":"1453446.0","销量同比增长率":"-8.24%"},{"年":"2019","年月":"2019-04","销量":"1198770.0","销量同比增长率":"-16.47%"},{"年":"2019","年月":"2019-05","销量":"1184427.0","销量同比增长率":"-16.46%"},{"年":"2019","年月":"2019-06","销量":"1268292.0","销量同比增长率":"-9.87%"},{"年":"2019","年月":"2019-07","销量":"1191062.0","销量同比增长率":"-4.67%"},{"年":"2019","年月":"2019-08","销量":"1277671.0","销量同比增长率":"-10.43%"},{"年":"2019","年月":"2019-09","销量":"1513929.0","销量同比增长率":"-5.04%"},{"年":"2019","年月":"2019-10","销量":"1513153.0","销量同比增长率":"-6.02%"},{"年":"2019","年月":"2019-11","销量":"1598159.0","销量同比增长率":"-5.15%"},{"年":"2019","年月":"2019-12","销量":"1673915.0","销量同比增长率":"1.12%"}]2019年各月的销量,同比c2880de3-6e63-4335-bfb2-176134c15ef3I8a8aa3ed019172c872c8914601919746178077c0eff8c948-041a-47ba-81a3-20bfe4d267e61726107922907
{"data":[{"marker":{"color":"blue"},"name":"本田","x":["2019-01","2019-02","2019-03","2019-04","2019-05","2019-06","2019-07","2019-08","2019-09","2019-10","2019-11","2019-12"],"y":[132912,71505,136235,122723,121846,130344,121911,113703,145361,134410,144628,130130],"type":"bar"},{"marker":{"color":"green"},"name":"奔驰","x":["2019-01","2019-02","2019-03","2019-04","2019-05","2019-06","2019-07","2019-08","2019-09","2019-10","2019-11","2019-12"],"y":[54256,38416,52435,44159,47629,45151,47000,47660,48527,45646,45574,48704],"type":"bar"}],"layout":{"template":{"data":{"histogram2dcontour":[{"type":"histogram2dcontour","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"choropleth":[{"type":"choropleth","colorbar":{"outlinewidth":0,"ticks":""}}],"histogram2d":[{"type":"histogram2d","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"heatmap":[{"type":"heatmap","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"heatmapgl":[{"type":"heatmapgl","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"contourcarpet":[{"type":"contourcarpet","colorbar":{"outlinewidth":0,"ticks":""}}],"contour":[{"type":"contour","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"surface":[{"type":"surface","colorbar":{"outlinewidth":0,"ticks":""},"colorscale":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]]}],"mesh3d":[{"type":"mesh3d","colorbar":{"outlinewidth":0,"ticks":""}}],"scatter":[{"fillpattern":{"fillmode":"overlay","size":10,"solidity":0.2},"type":"scatter"}],"parcoords":[{"type":"parcoords","line":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatterpolargl":[{"type":"scatterpolargl","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"bar":[{"error_x":{"color":"#2a3f5f"},"error_y":{"color":"#2a3f5f"},"marker":{"line":{"color":"#E5ECF6","width":0.5},"pattern":{"fillmode":"overlay","size":10,"solidity":0.2}},"type":"bar"}],"scattergeo":[{"type":"scattergeo","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatterpolar":[{"type":"scatterpolar","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"histogram":[{"marker":{"pattern":{"fillmode":"overlay","size":10,"solidity":0.2}},"type":"histogram"}],"scattergl":[{"type":"scattergl","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatter3d":[{"type":"scatter3d","line":{"colorbar":{"outlinewidth":0,"ticks":""}},"marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scattermapbox":[{"type":"scattermapbox","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scatterternary":[{"type":"scatterternary","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"scattercarpet":[{"type":"scattercarpet","marker":{"colorbar":{"outlinewidth":0,"ticks":""}}}],"carpet":[{"aaxis":{"endlinecolor":"#2a3f5f","gridcolor":"white","linecolor":"white","minorgridcolor":"white","startlinecolor":"#2a3f5f"},"baxis":{"endlinecolor":"#2a3f5f","gridcolor":"white","linecolor":"white","minorgridcolor":"white","startlinecolor":"#2a3f5f"},"type":"carpet"}],"table":[{"cells":{"fill":{"color":"#EBF0F8"},"line":{"color":"white"}},"header":{"fill":{"color":"#C8D4E3"},"line":{"color":"white"}},"type":"table"}],"barpolar":[{"marker":{"line":{"color":"#E5ECF6","width":0.5},"pattern":{"fillmode":"overlay","size":10,"solidity":0.2}},"type":"barpolar"}],"pie":[{"automargin":true,"type":"pie"}]},"layout":{"autotypenumbers":"strict","colorway":["#636efa","#EF553B","#00cc96","#ab63fa","#FFA15A","#19d3f3","#FF6692","#B6E880","#FF97FF","#FECB52"],"font":{"color":"#2a3f5f"},"hovermode":"closest","hoverlabel":{"align":"left"},"paper_bgcolor":"white","plot_bgcolor":"#E5ECF6","polar":{"bgcolor":"#E5ECF6","angularaxis":{"gridcolor":"white","linecolor":"white","ticks":""},"radialaxis":{"gridcolor":"white","linecolor":"white","ticks":""}},"ternary":{"bgcolor":"#E5ECF6","aaxis":{"gridcolor":"white","linecolor":"white","ticks":""},"baxis":{"gridcolor":"white","linecolor":"white","ticks":""},"caxis":{"gridcolor":"white","linecolor":"white","ticks":""}},"coloraxis":{"colorbar":{"outlinewidth":0,"ticks":""}},"colorscale":{"sequential":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]],"sequentialminus":[[0.0,"#0d0887"],[0.1111111111111111,"#46039f"],[0.2222222222222222,"#7201a8"],[0.3333333333333333,"#9c179e"],[0.4444444444444444,"#bd3786"],[0.5555555555555556,"#d8576b"],[0.6666666666666666,"#ed7953"],[0.7777777777777778,"#fb9f3a"],[0.8888888888888888,"#fdca26"],[1.0,"#f0f921"]],"diverging":[[0,"#8e0152"],[0.1,"#c51b7d"],[0.2,"#de77ae"],[0.3,"#f1b6da"],[0.4,"#fde0ef"],[0.5,"#f7f7f7"],[0.6,"#e6f5d0"],[0.7,"#b8e186"],[0.8,"#7fbc41"],[0.9,"#4d9221"],[1,"#276419"]]},"xaxis":{"gridcolor":"white","linecolor":"white","ticks":"","title":{"standoff":15},"zerolinecolor":"white","automargin":true,"zerolinewidth":2},"yaxis":{"gridcolor":"white","linecolor":"white","ticks":"","title":{"standoff":15},"zerolinecolor":"white","automargin":true,"zerolinewidth":2},"scene":{"xaxis":{"backgroundcolor":"#E5ECF6","gridcolor":"white","linecolor":"white","showbackground":true,"ticks":"","zerolinecolor":"white","gridwidth":2},"yaxis":{"backgroundcolor":"#E5ECF6","gridcolor":"white","linecolor":"white","showbackground":true,"ticks":"","zerolinecolor":"white","gridwidth":2},"zaxis":{"backgroundcolor":"#E5ECF6","gridcolor":"white","linecolor":"white","showbackground":true,"ticks":"","zerolinecolor":"white","gridwidth":2}},"shapedefaults":{"line":{"color":"#2a3f5f"}},"annotationdefaults":{"arrowcolor":"#2a3f5f","arrowhead":0,"arrowwidth":1},"geo":{"bgcolor":"white","landcolor":"#E5ECF6","subunitcolor":"white","showland":true,"showlakes":true,"lakecolor":"white"},"title":{"x":0.05},"mapbox":{"style":"light"}}},"title":{"text":"2019年各月本田和奔驰销量对比","x":0.5},"xaxis":{"title":{"text":"月份"},"tickformat":"%Y-%m"},"yaxis":{"title":{"text":"销量"}},"barmode":"group"}}2019年各月本田和奔驰销量对比15352c83-d173-48bb-9c56-97433656728cI8a8aa3ed019172c872c8914601919746178077c08fe0af45-3f6d-4c28-84ea-895f06ad6a211726107988363
[{"总部省份":"安徽","中位数":1581.7655,"平均值":1581.7655,"最大值":1581.7655,"最小值":1581.7655,"方差":null},{"总部省份":"北京","中位数":26968.6484,"平均值":26968.6484,"最大值":26968.6484,"最小值":26968.6484,"方差":null},{"总部省份":"广东","中位数":23480.9434,"平均值":23480.9434,"最大值":23480.9434,"最小值":23480.9434,"方差":null},{"总部省份":"广西","中位数":2578.663,"平均值":2578.663,"最大值":2578.663,"最小值":2578.663,"方差":null},{"总部省份":"河北","中位数":5062.5183,"平均值":5062.5183,"最大值":5062.5183,"最小值":5062.5183,"方差":null},{"总部省份":"湖北","中位数":7356.7592,"平均值":7356.7592,"最大值":7356.7592,"最小值":7356.7592,"方差":null},{"总部省份":"吉林","中位数":10811.0513,"平均值":10811.0513,"最大值":10811.0513,"最小值":10811.0513,"方差":null},{"总部省份":"江苏","中位数":3740.7223,"平均值":3740.7223,"最大值":3740.7223,"最小值":3740.7223,"方差":null},{"总部省份":"辽宁","中位数":9793.0455,"平均值":9793.0455,"最大值":9793.0455,"最小值":9793.0455,"方差":null},{"总部省份":"上海","中位数":33516.5719999999,"平均值":33516.5719999999,"最大值":33516.5719999999,"最小值":33516.5719999999,"方差":null},{"总部省份":"天津","中位数":7616.3068,"平均值":7616.3068,"最大值":7616.3068,"最小值":7616.3068,"方差":null},{"总部省份":"浙江","中位数":4810.0384,"平均值":4810.0384,"最大值":4810.0384,"最小值":4810.0384,"方差":null},{"总部省份":"重庆","中位数":8977.7705,"平均值":8977.7705,"最大值":8977.7705,"最小值":8977.7705,"方差":null}]各省份的销售额、中位数、平均值、最大值、最小值、方差98fccf6a-5302-42c2-982b-bb80d137f6b8I8a8aa3ed019172c872c8914601919746178077c0fb310e25-f6ad-437c-9f98-5679bc05181c1726116172644
[{"级别":"中型","德系3强销量":3227317},{"级别":"中大型","德系3强销量":2067738},{"级别":"紧凑","德系3强销量":1644858}]各级别德系三强的销量,德系三强的销量是指奔驰销量+宝马销量+奥迪销量da6dabfc-f86b-46a0-9a45-e40071c0b3aeI8a8aa3ed019172c872c8914601919746178077c028f216ad-3ac8-40a1-80f4-52f7d06f6b741726128677173
[{"品牌":"大众","销量":"15028916.0"},{"品牌":"本田","销量":"6576346.0"},{"品牌":"丰田","销量":"6307037.0"},{"品牌":"其它品牌","销量":"57140268.0"},{"品牌":"所有品牌","销量":"85052567.0"}]销量前3的品牌,增加一行“其它品牌”的销量,增加一行“所有品牌”的销量。用concat函数合并多个Dataframef6abd5fc-3cba-4476-a38b-8fdec136c92bI8a8aa3ed019172c872c8914601919746178077c01df7b6cb-2517-4cc2-8563-79cde77b9f961726129551595