How to create a range list in Python?

Question

I want to have a table like this

I then want to input a value and if it's in between column a and b's value, then return column c's value.

I thought of making a dataframe with range values and seeing if the value in is the range, but I also need to check float values:

x = [
    range(0,16),
    range(16,18),
    range(18,20),
    range(22,24),
    range(24,26),
    range(26,28),
    range(28,30),
    range(30,32),
    range(32,34),
    range(34,36),
    range(36,38),
    range(38,99),
    ]

values = [.2, .4, 1,1,1,1,1,1,1,1,1,1]

df_c = pd.DataFrame([x, values]).transpose()

Is there a better way to do this?

What do you want to output if val is not between a and b? — Jon Kiparsky
– Jon Kiparsky, Commented Jun 29, 2017 at 17:59

Jon Kiparsky · Accepted Answer · 2017-06-29 17:58:21Z

1

def c_if_between(a, b, c, val):
    interval = sorted(a,b)
    if interval[0] < val < interval[1]:
        return c

answered Jun 29, 2017 at 17:58

Jon Kiparsky

7,8242 gold badges26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lgiro · Accepted Answer · 2017-06-29 17:46:01Z

0

def c_if_between(a, b, c, val):
    if sorted([a, b, val])[1] == val:
        return c

answered Jun 29, 2017 at 17:46

Lgiro

7725 silver badges13 bronze badges

Comments

AGN Gazer · Accepted Answer · 2017-06-29 18:19:37Z

0

import numpy as np
np.array(c)[(value >= np.array(a)) & (value < np.array(b))]

answered Jun 29, 2017 at 18:19

AGN Gazer

8,4272 gold badges31 silver badges49 bronze badges

1 Comment

Daniel F Over a year ago

While this code may answer the question, providing additional context regarding how and/or why it solves the problem would improve the answer's long-term value.

Collectives™ on Stack Overflow

How to create a range list in Python?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related