给出一个数字,如何获得前一个和下一个值内的一个列表吗? [关闭]

0

的问题

我有以下数据框:

VALUE_TO_FIND  UNORDERED_LIST
5              [0,10]
3              [1,0,10,8,4,2]
2              [9,10,0]
5              [4,8,0,1,2,10]
4              [0,10,4]

给出的数值从柱 VALUE_TO_FIND我怎么得到的以前和下一个值的内部 UNORDERED_LIST?

VALUE_TO_FIND  UNORDERED_LIST   PREVIOUS_VALUE   NEXT_VALUE
5              [0,10]           0                10
3              [1,0,10,8,4,2]   2                4
2              [9,10,0]         0                9
5              [4,8,0,1,2,10]   4                8
4              [0,10,4]         4                4

注: UNORDERED_LIST 总是会有的最小和最大的 VALUE_TO_FIND

dataframe pandas python
2021-11-24 02:55:34
1

最好的答案

1

可能有一个更有效的解决方案,但我已经尝试了 zip平的两个相关的栏目:

import pandas as pd
df = pd.DataFrame({'VALUE_TO_FIND': [5, 3, 2, 5, 4,],
    'UNORDERED_LIST': [[0,10], [1,0,10,8,4,2], [9,10,0], [4,8,0,1,2,10], [0,10,4],]})

def find_prev_next(x, lst):
    return max(y for y in lst if y <= x), min(y for y in lst if y >= x) # tuple

_ = [find_prev_next(x, lst) for x, lst in zip(df.VALUE_TO_FIND, df.UNORDERED_LIST)]
df['PREVIOUS_VALUE'], df['NEXT_VALUE'] = zip(*_)

print(df)
   # VALUE_TO_FIND       UNORDERED_LIST  PREVIOUS_VALUE  NEXT_VALUE
# 0              5              [0, 10]               0          10
# 1              3  [1, 0, 10, 8, 4, 2]               2           4
# 2              2           [9, 10, 0]               0           9
# 3              5  [4, 8, 0, 1, 2, 10]               4           8
# 4              4           [0, 10, 4]               4           4
2021-11-24 03:32:02

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................