解析半结构化json数据（Python/R）
回答此问题可获得 20 贡献值，回答如果被采纳可获得 50 分。
<p>我不擅长正则表达式或编程。在</p>
<p>我在一个文本文件中有这样的数据：</p>
<pre><code>RAMCHAR@HOTMAIL.COM ():
PATTY.FITZGERALD327@GMAIL.COM ():
OHSCOACHK13@AOL.COM (19OB3IRCFHHYO): [{"num":1,"name":"Bessey VAS23 Vario Angle Strap Clamp","link":"http:\/\/www.amazon.com\/dp\/B0000224B3\/ref=wl_it_dp_v_nS_ttl\/181-6441163-6563619?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I1YMLERDXCK3UU&psc=1","old-price":"N\/A","new-price":"","date-added":"October 19, 2014","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/51VMDDHT20L._SL500_SL135_.jpg","page":1},{"num":2,"name":"Designers Edge L-5200 500-Watt Double Bulb Halogen 160 Degree Wide Angle Surround Portable Worklight, Red","link":"http:\/\/www.amazon.com\/dp\/B0006OG8MY\/ref=wl_it_dp_v_nS_ttl\/181-6441163-6563619?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I1BZH206RPRW8B","old-price":"N\/A","new-price":"","date-added":"October 8, 2014","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/5119Z4RDFYL._SL500_SL135_.jpg","page":1},{"num":3,"name":"50 Pack - 12"x12" (5) Bullseye Splatterburst Target - Instantly See Your Shots Burst Bright Florescent Yellow Upon Impact!","link":"http:\/\/www.amazon.com\/dp\/B00C88T12K\/ref=wl_it_dp_v_nS_ttl\/181-6441163-6563619?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I31RJXFVF14TBM","old-price":"N\/A","new-price":"","date-added":"October 8, 2014","priority":"","rating":"N\/A","total-ratings":"67","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/51QwsvI43IL._SL500_SL135_.jpg","page":1},{"num":4,"name":"DEWALT DW618PK 12-AMP 2-1\/4 HP Plunge and Fixed-Base Variable-Speed Router Kit","link":"http:\/\/www.amazon.com\/dp\/B00006JKXE\/ref=wl_it_dp_v_nS_ttl\/181-6441163-6563619?_encoding=UTF8&colid=37XI10RRD17X2&coliid=I39QDQSBY00R56&psc=1","old-price":"N\/A","new-price":"","date-added":"September 3, 2012","priority":"","rating":"N\/A","total-ratings":"","comment":"","picture":"http:\/\/ecx.images-amazon.com\/images\/I\/416a5nzkYTL._SL500_SL135_.jpg","page":1}]
</code></pre>
<p>有人能建议任何简单的方法将这些数据分成两列（第一列是email id，第二列是json格式的数据）。有些行可能只有email id（如第1行）而没有相应的json数据。在</p>
<p>请帮忙。谢谢！在</p>
请先 登录 后评论
针对此问题: 更多的回答
- 89 关注
- 1 收藏，216 浏览
- 网友 提问于 2天前
相关Python问题
- jupyter运行一个旧的pytorch版本 10 回答
- Jupyter运行不同版本的卸载库？ 6 回答
- Jupyter运行指定的键盘快捷键 6 回答
- Jupyter通过.local文件“逃逸”virtualenv。我该如何缓解这种情况？ 2 回答
- Jupyter重新加载自定义样式 3 回答
- Jupyter错误：“没有名为Jupyter_core.paths的模块” 6 回答
- jupyter错误：无法在随机林中将决策树视为png 4 回答
- Jupyter错误'内核似乎已经死亡，它将自动重新启动'为一个给定的代码块 10 回答
- Jupyter错误地用阿拉伯语和字母数字元素显示Python列表 2 回答
- Jupyter隐藏数据帧索引，但保留原始样式 5 回答
- Jupyter集线器：启动器中出现致命错误。。。系统找不到指定的文件 6 回答
- Jupyther中相同值的相同哈希，但导出到Bigquery时不相同 9 回答
- Jupy上Python的读/写访问问题 4 回答
- jupy上没有模块cv 9 回答
- Jupy上的排序错误 4 回答
- Jupy中bqplot图形的紧凑布局 4 回答
- Jupy中matplotlib plot的连续更新 8 回答
- Jupy中Numpy函数的文档 4 回答
- Jupy中Pandas的自动完成问题 9 回答
- jupy中Qt后端的Matplotlib动画 9 回答
