2023年3月7日 21:23:10go评论63阅读模式

英文:

Extract information from Google Doc into Pandas DF

问题

我正在寻找一种方法从我的私人Google文档中提取信息并将它们放入DF（数据框）以执行一些简单的分析。

我已连接到Google文档API，并能够读取文档，但我正在努力提取仅相关信息并按正确顺序排列。

我的文档如下所示：

我需要的输出如下所示：

我可以创建单个项目的正则表达式，但如何将它们分组到像上面那样的表中，考虑到单个日期的段落数和标签数可能会有所变化？

谢谢！

这是我从API收到的内容：

{'title': 'test',
 'body': {'content': [{'endIndex': 1,
    'sectionBreak': {'sectionStyle': {'columnSeparatorStyle': 'NONE',
      'contentDirection': 'LEFT_TO_RIGHT',
      'sectionType': 'CONTINUOUS'}}},
   {'startIndex': 1,
    'endIndex': 11,
    'paragraph': {'elements': [{'startIndex': 1,
       'endIndex': 11,
       'textRun': {'content': 'Doc Title\n',
        'textStyle': {'bold': True,
         'fontSize': {'magnitude': 13, 'unit': 'PT'}}}}],
     'paragraphStyle': {'namedStyleType': 'NORMAL_TEXT',
      'alignment': 'CENTER',
      'direction': 'LEFT_TO_RIGHT'}}},
   {'startIndex': 11,
    'endIndex': 12,
    'paragraph': {'elements': [{'startIndex': 11,
       'endIndex': 12,
       'textRun': {'content': '\n',
        'textStyle': {'bold': True,
         'fontSize': {'magnitude': 13, 'unit': 'PT'}}}}],
     'paragraphStyle': {'namedStyleType': 'NORMAL_TEXT',
      'alignment': 'CENTER',
      'direction': 'LEFT_TO_RIGHT'}}},
   ...
   ...

请注意，以上只是给出的一部分内容，其中包含了文档的结构和示例文本段。如果您需要对文档的特定部分进行进一步的翻译或解释，请提供详细的信息。

英文:

I'm looking for a way to extract information from my private Google Doc and put them into DF to perform some simple analysis.

I'm connected to the Google Doc API and able to read the document but I'm struggling with extracting only relevant information and in correct order.

This is how my doc looks like:

And this is the output I need to have:

I would be able to create separate regexes for single items but how to group it into table like above, given that number of paragraphs for single date can vary (same for tags)?

Thanks

This is what I received from API:

{&#39;title&#39;: &#39;test&#39;,
&#39;body&#39;: {&#39;content&#39;: [{&#39;endIndex&#39;: 1,
&#39;sectionBreak&#39;: {&#39;sectionStyle&#39;: {&#39;columnSeparatorStyle&#39;: &#39;NONE&#39;,
&#39;contentDirection&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;sectionType&#39;: &#39;CONTINUOUS&#39;}}},
{&#39;startIndex&#39;: 1,
&#39;endIndex&#39;: 11,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 1,
&#39;endIndex&#39;: 11,
&#39;textRun&#39;: {&#39;content&#39;: &#39;Doc Title\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 13, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;CENTER&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 11,
&#39;endIndex&#39;: 12,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 11,
&#39;endIndex&#39;: 12,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 13, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;CENTER&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 12,
&#39;endIndex&#39;: 13,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 12,
&#39;endIndex&#39;: 13,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 13, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;CENTER&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 13,
&#39;endIndex&#39;: 23,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 13,
&#39;endIndex&#39;: 23,
&#39;textRun&#39;: {&#39;content&#39;: &#39;7.03.2023\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 13, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;CENTER&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 23,
&#39;endIndex&#39;: 24,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 23,
&#39;endIndex&#39;: 24,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 13, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;CENTER&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 24,
&#39;endIndex&#39;: 27,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 24,
&#39;endIndex&#39;: 27,
&#39;textRun&#39;: {&#39;content&#39;: &#39;1.\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 27,
&#39;endIndex&#39;: 41,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 27,
&#39;endIndex&#39;: 41,
&#39;textRun&#39;: {&#39;content&#39;: &#39;Example text…\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 41,
&#39;endIndex&#39;: 42,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 41,
&#39;endIndex&#39;: 42,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 42,
&#39;endIndex&#39;: 55,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 42,
&#39;endIndex&#39;: 55,
&#39;textRun&#39;: {&#39;content&#39;: &#39;#tag1, #tag2\n&#39;,
&#39;textStyle&#39;: {&#39;underline&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 55,
&#39;endIndex&#39;: 56,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 55,
&#39;endIndex&#39;: 56,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 56,
&#39;endIndex&#39;: 59,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 56,
&#39;endIndex&#39;: 59,
&#39;textRun&#39;: {&#39;content&#39;: &#39;2.\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 59,
&#39;endIndex&#39;: 73,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 59,
&#39;endIndex&#39;: 73,
&#39;textRun&#39;: {&#39;content&#39;: &#39;Example text…\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 73,
&#39;endIndex&#39;: 74,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 73,
&#39;endIndex&#39;: 74,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 74,
&#39;endIndex&#39;: 94,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 74,
&#39;endIndex&#39;: 94,
&#39;textRun&#39;: {&#39;content&#39;: &#39;#tag1, #tag2, #tag3\n&#39;,
&#39;textStyle&#39;: {&#39;underline&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 94,
&#39;endIndex&#39;: 95,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 94,
&#39;endIndex&#39;: 95,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 95,
&#39;endIndex&#39;: 105,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 95,
&#39;endIndex&#39;: 105,
&#39;textRun&#39;: {&#39;content&#39;: &#39;8.03.2023\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 13, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;CENTER&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 105,
&#39;endIndex&#39;: 106,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 105,
&#39;endIndex&#39;: 106,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 106,
&#39;endIndex&#39;: 109,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 106,
&#39;endIndex&#39;: 109,
&#39;textRun&#39;: {&#39;content&#39;: &#39;1.\n&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 109,
&#39;endIndex&#39;: 123,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 109,
&#39;endIndex&#39;: 123,
&#39;textRun&#39;: {&#39;content&#39;: &#39;Example text…\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 123,
&#39;endIndex&#39;: 124,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 123,
&#39;endIndex&#39;: 124,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 124,
&#39;endIndex&#39;: 137,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 124,
&#39;endIndex&#39;: 137,
&#39;textRun&#39;: {&#39;content&#39;: &#39;#tag1, #tag2\n&#39;,
&#39;textStyle&#39;: {&#39;underline&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 137,
&#39;endIndex&#39;: 138,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 137,
&#39;endIndex&#39;: 138,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 138,
&#39;endIndex&#39;: 141,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 138,
&#39;endIndex&#39;: 141,
&#39;textRun&#39;: {&#39;content&#39;: &#39;2.\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 141,
&#39;endIndex&#39;: 155,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 141,
&#39;endIndex&#39;: 155,
&#39;textRun&#39;: {&#39;content&#39;: &#39;Example text…\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 155,
&#39;endIndex&#39;: 156,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 155,
&#39;endIndex&#39;: 156,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 156,
&#39;endIndex&#39;: 176,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 156,
&#39;endIndex&#39;: 176,
&#39;textRun&#39;: {&#39;content&#39;: &#39;#tag1, #tag2, #tag3\n&#39;,
&#39;textStyle&#39;: {&#39;underline&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 176,
&#39;endIndex&#39;: 177,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 176,
&#39;endIndex&#39;: 177,
&#39;textRun&#39;: {&#39;content&#39;: &#39;\n&#39;,
&#39;textStyle&#39;: {&#39;underline&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 177,
&#39;endIndex&#39;: 180,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 177,
&#39;endIndex&#39;: 180,
&#39;textRun&#39;: {&#39;content&#39;: &#39;3.\n&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}},
{&#39;startIndex&#39;: 180,
&#39;endIndex&#39;: 186,
&#39;paragraph&#39;: {&#39;elements&#39;: [{&#39;startIndex&#39;: 180,
&#39;endIndex&#39;: 186,
&#39;textRun&#39;: {&#39;content&#39;: &#39;#tag1\n&#39;,
&#39;textStyle&#39;: {&#39;underline&#39;: True,
&#39;fontSize&#39;: {&#39;magnitude&#39;: 10, &#39;unit&#39;: &#39;PT&#39;}}}}],
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;}}}]},
&#39;documentStyle&#39;: {&#39;background&#39;: {&#39;color&#39;: {}},
&#39;pageNumberStart&#39;: 1,
&#39;marginTop&#39;: {&#39;magnitude&#39;: 72, &#39;unit&#39;: &#39;PT&#39;},
&#39;marginBottom&#39;: {&#39;magnitude&#39;: 72, &#39;unit&#39;: &#39;PT&#39;},
&#39;marginRight&#39;: {&#39;magnitude&#39;: 72, &#39;unit&#39;: &#39;PT&#39;},
&#39;marginLeft&#39;: {&#39;magnitude&#39;: 72, &#39;unit&#39;: &#39;PT&#39;},
&#39;pageSize&#39;: {&#39;height&#39;: {&#39;magnitude&#39;: 841.8897637795277, &#39;unit&#39;: &#39;PT&#39;},
&#39;width&#39;: {&#39;magnitude&#39;: 595.2755905511812, &#39;unit&#39;: &#39;PT&#39;}},
&#39;marginHeader&#39;: {&#39;magnitude&#39;: 36, &#39;unit&#39;: &#39;PT&#39;},
&#39;marginFooter&#39;: {&#39;magnitude&#39;: 36, &#39;unit&#39;: &#39;PT&#39;},
&#39;useCustomHeaderFooterMargins&#39;: True},
&#39;namedStyles&#39;: {&#39;styles&#39;: [{&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: False,
&#39;italic&#39;: False,
&#39;underline&#39;: False,
&#39;strikethrough&#39;: False,
&#39;smallCaps&#39;: False,
&#39;backgroundColor&#39;: {},
&#39;foregroundColor&#39;: {&#39;color&#39;: {&#39;rgbColor&#39;: {}}},
&#39;fontSize&#39;: {&#39;magnitude&#39;: 11, &#39;unit&#39;: &#39;PT&#39;},
&#39;weightedFontFamily&#39;: {&#39;fontFamily&#39;: &#39;Arial&#39;, &#39;weight&#39;: 400},
&#39;baselineOffset&#39;: &#39;NONE&#39;},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;alignment&#39;: &#39;START&#39;,
&#39;lineSpacing&#39;: 115,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spacingMode&#39;: &#39;COLLAPSE_LISTS&#39;,
&#39;spaceAbove&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;borderBetween&#39;: {&#39;color&#39;: {},
&#39;width&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;padding&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;dashStyle&#39;: &#39;SOLID&#39;},
&#39;borderTop&#39;: {&#39;color&#39;: {},
&#39;width&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;padding&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;dashStyle&#39;: &#39;SOLID&#39;},
&#39;borderBottom&#39;: {&#39;color&#39;: {},
&#39;width&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;padding&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;dashStyle&#39;: &#39;SOLID&#39;},
&#39;borderLeft&#39;: {&#39;color&#39;: {},
&#39;width&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;padding&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;dashStyle&#39;: &#39;SOLID&#39;},
&#39;borderRight&#39;: {&#39;color&#39;: {},
&#39;width&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;padding&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;dashStyle&#39;: &#39;SOLID&#39;},
&#39;indentFirstLine&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;indentStart&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;indentEnd&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: False,
&#39;keepWithNext&#39;: False,
&#39;avoidWidowAndOrphan&#39;: True,
&#39;shading&#39;: {&#39;backgroundColor&#39;: {}},
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;HEADING_1&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 20, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;magnitude&#39;: 20, &#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 6, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;HEADING_2&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: False, &#39;fontSize&#39;: {&#39;magnitude&#39;: 16, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;magnitude&#39;: 18, &#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 6, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;HEADING_3&#39;,
&#39;textStyle&#39;: {&#39;bold&#39;: False,
&#39;foregroundColor&#39;: {&#39;color&#39;: {&#39;rgbColor&#39;: {&#39;red&#39;: 0.2627451,
&#39;green&#39;: 0.2627451,
&#39;blue&#39;: 0.2627451}}},
&#39;fontSize&#39;: {&#39;magnitude&#39;: 14, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;magnitude&#39;: 16, &#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 4, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;HEADING_4&#39;,
&#39;textStyle&#39;: {&#39;foregroundColor&#39;: {&#39;color&#39;: {&#39;rgbColor&#39;: {&#39;red&#39;: 0.4,
&#39;green&#39;: 0.4,
&#39;blue&#39;: 0.4}}},
&#39;fontSize&#39;: {&#39;magnitude&#39;: 12, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;magnitude&#39;: 14, &#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 4, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;HEADING_5&#39;,
&#39;textStyle&#39;: {&#39;foregroundColor&#39;: {&#39;color&#39;: {&#39;rgbColor&#39;: {&#39;red&#39;: 0.4,
&#39;green&#39;: 0.4,
&#39;blue&#39;: 0.4}}},
&#39;fontSize&#39;: {&#39;magnitude&#39;: 11, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;magnitude&#39;: 12, &#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 4, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;HEADING_6&#39;,
&#39;textStyle&#39;: {&#39;italic&#39;: True,
&#39;foregroundColor&#39;: {&#39;color&#39;: {&#39;rgbColor&#39;: {&#39;red&#39;: 0.4,
&#39;green&#39;: 0.4,
&#39;blue&#39;: 0.4}}},
&#39;fontSize&#39;: {&#39;magnitude&#39;: 11, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;magnitude&#39;: 12, &#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 4, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;TITLE&#39;,
&#39;textStyle&#39;: {&#39;fontSize&#39;: {&#39;magnitude&#39;: 26, &#39;unit&#39;: &#39;PT&#39;}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 3, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}},
{&#39;namedStyleType&#39;: &#39;SUBTITLE&#39;,
&#39;textStyle&#39;: {&#39;italic&#39;: False,
&#39;foregroundColor&#39;: {&#39;color&#39;: {&#39;rgbColor&#39;: {&#39;red&#39;: 0.4,
&#39;green&#39;: 0.4,
&#39;blue&#39;: 0.4}}},
&#39;fontSize&#39;: {&#39;magnitude&#39;: 15, &#39;unit&#39;: &#39;PT&#39;},
&#39;weightedFontFamily&#39;: {&#39;fontFamily&#39;: &#39;Arial&#39;, &#39;weight&#39;: 400}},
&#39;paragraphStyle&#39;: {&#39;namedStyleType&#39;: &#39;NORMAL_TEXT&#39;,
&#39;direction&#39;: &#39;LEFT_TO_RIGHT&#39;,
&#39;spaceAbove&#39;: {&#39;unit&#39;: &#39;PT&#39;},
&#39;spaceBelow&#39;: {&#39;magnitude&#39;: 16, &#39;unit&#39;: &#39;PT&#39;},
&#39;keepLinesTogether&#39;: True,
&#39;keepWithNext&#39;: True,
&#39;pageBreakBefore&#39;: False}}]},
&#39;revisionId&#39;: &#39;xxxxxxx&#39;,
&#39;suggestionsViewMode&#39;: &#39;SUGGESTIONS_INLINE&#39;,
&#39;documentId&#39;: &#39;xxxxxxx&#39;}

答案1

得分: 3

假设 d 是由Google API返回的字典，您可以使用以下代码：

import itertools

# 提取内容数据
content = itertools.chain(*[c['paragraph']['elements']
                           for c in d['body']['content']
                           if 'paragraph' in c])

# 提取期望数据
df = (pd.json_normalize(content)['textRun.content']
    .str.strip().loc[lambda x: x.str.len() > 0]
    .str.extract('^(?P<Date>\d+\.\d+\.\d+)|(?P<Paragraph>\d+\.)|(?P<Tags>#.*)')
    .dropna(how='all'))

# 过滤数据框
out = (df.ffill().loc[df['Tags'].notna()]
     .assign(Tags=lambda x: x['Tags'].str.split(',\s*'))
     .reset_index(drop=True))

输出：

>>> out
        Date Paragraph                   Tags
0  7.03.2023        1.         [#tag1, #tag2]
1  7.03.2023        2.  [#tag1, #tag2, #tag3]
2  8.03.2023        1.         [#tag1, #tag2]
3  8.03.2023        2.  [#tag1, #tag2, #tag3]
4  8.03.2023        3.                [#tag1]

英文:

Suppose d the dictionary returned by Google API, you can use:

import itertools
# Extract content data
content = itertools.chain(*[c[&#39;paragraph&#39;][&#39;elements&#39;]
for c in d[&#39;body&#39;][&#39;content&#39;]
if &#39;paragraph&#39; in c])
# Extract expected data
df = (pd.json_normalize(content)[&#39;textRun.content&#39;]
.str.strip().loc[lambda x: x.str.len() &gt; 0]
.str.extract(&#39;^(?P&lt;Date&gt;\d+\.\d+\.\d+)|(?P&lt;Paragraph&gt;\d+\.)|(?P&lt;Tags&gt;#.*)&#39;)
.dropna(how=&#39;all&#39;))
# Filter dataframe
out = (df.ffill().loc[df[&#39;Tags&#39;].notna()]
.assign(Tags=lambda x: x[&#39;Tags&#39;].str.split(&#39;,\s*&#39;))
.reset_index(drop=True))

Output:

&gt;&gt;&gt; out
Date Paragraph                   Tags
0  7.03.2023        1.         [#tag1, #tag2]
1  7.03.2023        2.  [#tag1, #tag2, #tag3]
2  8.03.2023        1.         [#tag1, #tag2]
3  8.03.2023        2.  [#tag1, #tag2, #tag3]
4  8.03.2023        3.                [#tag1]

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

从Google文档中提取信息到Pandas数据框。

问题

答案1

如何优化在Kotlin中进行的n个异步并发调用。

Finding Distant Pairs in Python taking advantage of pandas

Python动态更改JSON键

在Python Polars中筛选时区感知的日期时间时的偏移量

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论