问题描述
我正在研究一个项目，一位研究合作伙伴从他的网站为我提供了海量数据，我需要对其进行分析.我曾尝试将文件导入excel，但是这很尴尬，并且想出一种有效的方法来描绘数据已被证明几乎是不可能的.是否有任何程序或技术来获取JSON文件并将数据组织成类似于电子表格的内容? (最终，我需要对数据进行采样，但仅对几个变量进行数据分析.我需要将其转换为某种电子表格类型的格式，或者以某种视觉上(如果不是从功能上来说)类似的格式进行显示.找出我在相关类别中有多少个数据点并随机抽样)
谢谢您的帮助！
I''m working on a research project and a research partner has provided me with a massive file of data from his website, which I need to be able to analyze. I''ve tried importing the file into excel, but it''s awkward and figuring out an effective way to delineate the data has proven nearly impossible. Is there any program or technique to take the JSON file and organize the data into something resembling a spreadsheet? (Ultimately, I need to sample the data, but only for a couple variables, for my data analysis. I need to get it into some sort of spreadsheet-type format or something that is visually, if not functionally, similar that would allow me to figure out how many datapoints I have in the relevant categories and to randomly sample them)
Thanks for any help!
推荐答案
这篇关于如何查看/处理JSON文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！