creating new binary columns using range of numbers in dataset

Question

I am using pandas library in python for the following:

i currently have a dataset that looks like this :

ID       START      END
x         450       600
y         100       500
.          .         .

Here start and end represent footmarks, ie a vessel was parked here from point x to y.

What i want to do is create binary columns 1, 2 3... till the max value in 'END' and have it show a 1 if that column number is within the range of 'START' to 'END'

what i want to accomplish here is finding the total number of times all the footmarks have been used. Right now my approach is to have the binary columns and sum them up to get the total count.

I am also open to better methods of solving my problem.

edit_1:

What i want -

ID       START      END    1   2   3  ...... 450 ..... 500 .... 600   601  
x         450       600    0   0   0          1         1        1     0
y         100       500    0   0   0          1         1        0     0
.          .         .

nothing so far, i looked up the get_dummies function but cant seem to figure out how to do that for a range of numbers. — Aasheet Kumar
– Aasheet Kumar, Commented Aug 22, 2017 at 19:12
@AasheetKumar, could you also explain why do you need such an unusual (not very efficient) structure? — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Aug 22, 2017 at 19:36

nanojohn · Accepted Answer · 2017-08-22 19:28:33Z

1

If I understand correctly, you want to loop through values 1 to max('END') and produce True/False values based on range START to END. I think you want something like:

for i in range(1,df['END'].max()+1):
    df[i] = ((i >= df['START']) & (i <= df['END'])).astype(int)

However, if you only want to figure out the number of steps where all rows "overlap", you can just do:

max((df['END'].min() - df['START'].max()), 0)

Since the vessels will only overlap when everything is >= 'START' but <= 'END'

answered Aug 22, 2017 at 19:28

nanojohn

5921 gold badge3 silver badges13 bronze badges

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

1 Comment

Aasheet Kumar Over a year ago

the first part worked for me, thank you. The second code is not exactly what i am looking for, i have just added a comment to the question, maybe that helps explain my needs better. Thank you again!

Collectives™ on Stack Overflow

creating new binary columns using range of numbers in dataset

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related