擅长:python、mysql、java
<ul>
<li>在这种情况下,最容易在<code>df</code>的<code>'Item'</code>列上使用<code>pandas.json_normalize</code></li>
<li>因为您有一列链接,所以我提供了代码,将其显示为笔记本中的可单击链接,或保存到html文件中</李>
</ul>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
from IPython.display import HTML # used to show clickable link in a notebook
# read the file in as you are already doing
df = pd.read_json("test.json", lines=True, orient="columns")
# normalized the Item column
df = pd.json_normalize(df.Item)
# optional steps
# make the link clickable
df['title.S'] = '<a href=' + df['title.S'] + '>' + df['title.S'] + '</a>'
# display clickable dataframe in notebook
HTML(df.to_html(escape=False))
# save to html file
HTML(so.to_html('test.html', escape=False))
</code></pre>