在numpy的多个插入其中配对的元素没有潜台词(Multiple inserts in numpy

这个问题跟进在此之前的帖子由@ecortazar回答。 不过，我也想在pd.Series两个元素是不包括某些字符串，只用熊猫/ numpy的之间粘贴。 注：所有的线href的文字是不同的。

import pandas as pd
import numpy as np

table = pd.Series(

        ["<td class='test'>AA</td>",                  # 0 
        "<td class='test'>A</td>",                    # 1
        "<td class='test'><a class='test' href=...",  # 2
        "<td class='test'>B</td>",                    # 3
        "<td class='test'><a class='test' href=...",  # 4
        "<td class='test'>BB</td>",                   # 5
        "<td class='test'>C</td>",                    # 6
        "<td class='test'><a class='test' href=...",  # 7 
        "<td class='test'>F</td>",                    # 8
        "<td class='test'>G</td>",                    # 9 
        "<td class='test'><a class='test' href=...",  # 10 
        "<td class='test'>X</td>"])                   # 11


dups = ~table.str.contains('href') & table.shift(-1).str.contains('href') 
array = np.insert(table.values, dups[dups].index, "None")
pd.Series(array)


# OUTPUT:
# 0                      <td class='test'>AA</td>
# 1                                          None
# 2                       <td class='test'>A</td>
# 3     <td class='test'><a class='test' href=...
# 4                                          None Incorrect
# 5                       <td class='test'>B</td>
# 6     <td class='test'><a class='test' href=...
# 7                      <td class='test'>BB</td>
# 8                                          None
# 9                       <td class='test'>C</td>
# 10    <td class='test'><a class='test' href=...
# 11                      <td class='test'>F</td>
# 12                                         None
# 13                      <td class='test'>G</td>
# 14    <td class='test'><a class='test' href=...
# 15                      <td class='test'>X</td>

下面是实际的文本输出，我想。

# OUTPUT:
# 0                      <td class='test'>AA</td>
# 1                                          None
# 2                       <td class='test'>A</td>
# 3     <td class='test'><a class='test' href=...
# 4                       <td class='test'>B</td>
# 5     <td class='test'><a class='test' href=...
# 6                      <td class='test'>BB</td>
# 7                                          None
# 8                       <td class='test'>C</td>
# 9     <td class='test'><a class='test' href=...
# 10                      <td class='test'>F</td>
# 11                                         None
# 12                      <td class='test'>G</td>
# 13    <td class='test'><a class='test' href=...
# 14                      <td class='test'>X</td>

Answer 1:

你可以做同样的程序前。

唯一需要注意的是，你必须转变前做不（〜）运算符。 原因是，这一转变将创造你的系列的第一个位置，这将定义为系列浮动的np.nan，因而无法在不操作。

import pandas as pd
import numpy as np

table = pd.Series(
        ["<td class='test'>AA</td>",                  # 0 
        "<td class='test'>A</td>",                    # 1
        "<td class='test'><a class='test' href=...",  # 2
        "<td class='test'>B</td>",                    # 3
        "<td class='test'><a class='test' href=...",  # 4
        "<td class='test'>BB</td>",                   # 5
        "<td class='test'>C</td>",                    # 6
        "<td class='test'><a class='test' href=...",  # 7 
        "<td class='test'>F</td>",                    # 8
        "<td class='test'>G</td>",                    # 9 
        "<td class='test'><a class='test' href=...",  # 10 
        "<td class='test'>X</td>"])                   # 11


not_contain = ~table.str.contains('href')
cond = not_contain & not_contain.shift(1)
array = np.insert(table.values, cond[cond].index, "None")
pd.Series(array)

Answer 2:

这解决了上述情况，但没有NumPy的和熊猫。 如果你可以与他们重建，我给你正确的答案。

import pandas as pd
import numpy as np

table = pd.Series(

        ["<td class='test'>AA</td>",                  # 0 
        "<td class='test'>A</td>",                    # 1
        "<td class='test'><a class='test' href=...",  # 2
        "<td class='test'>B</td>",                    # 3
        "<td class='test'><a class='test' href=...",  # 4
        "<td class='test'>BB</td>",                   # 5
        "<td class='test'>C</td>",                    # 6
        "<td class='test'><a class='test' href=...",  # 7 
        "<td class='test'>F</td>",                    # 8
        "<td class='test'>G</td>",                    # 9 
        "<td class='test'><a class='test' href=...",  # 10 
        "<td class='test'>X</td>"])                   # 11


insertAt = []
for i in range(0, len(table)-1):
  # print('count ', i)

  if i == 1:
    if 'href' not in table[0] and 'href' not in table[1]:
      print(i, ' starts with tag')
      print(i, ' is duplicated')
      insertAt.append(True) 
      insertAt.append(True) 
      next
    elif 'href' not in table[0] and 'href' in table[1]:
      print(i, ' not start with tag')
      print(i, ' is not duplicated')
      insertAt.append(True) 
      insertAt.append(False) 
      next

    else:
      print(i, ' not start with tag')
      print(i, ' is not duplicated')
      insertAt.append(False) 
      insertAt.append(False) 
      next

  if i > 1:

    if 'href' not in table[i-1] and 'href' not in table[i]: 
      print(i + 1, ' is duplicated')
      insertAt.append(True)

    else:
      print(i + 1, ' is not duplicated')
      insertAt.append(False)

insertAt = pd.Series(insertAt)
array = np.insert(table.values, insertAt[insertAt].index, "None")
pd.Series(array) # back to series if necessary

文章来源: Multiple inserts in numpy where paired elements don't have subtext