Menu
in python is there a way to create of list that will skip numbers and will continue after skipping? something like the following code:
x = [1...3, 6...10]
print(x)
# [1,2,3,6,7,8,9,10]
Well its easy to write a for loop and then skip each defined index/value, or i can just use range, what I am looking for is a shorter more readable line. If not I can understand.
340
To combine or concatenate ranges in Excel with a formula, you can use a formula based on the INDEX function and the SEQUENCE function . In the example below, the formula in cell F5 is: where range1 (B5:B8) and range2 (D5:D9) are named ranges. The formula appends the second range to the first range and the result spills into F5:F13.
List Concatenation can also be done using the list comprehension technique. In this case, a new list is created, this method is a one-liner alternative to the loop method. The extend () is the function extended by lists in Python language and hence can be used to perform list concatenation operation.
Here are the steps to concatenate an Excel Range with space as the separator (as shown in the pic): Select the cell where you need the result. Based on your regional settings, you can also try =A1:A5 (instead of =TRANSPOSE (A1:A5)). Select the entire formula and press F9 (this converts the formula into values).
While you can enter the reference one by one within the CONCATENATE function, it would not work if you enter the reference of multiple cells at once (as shown below): For example, in the example above, while the formula used is =CONCATENATE (A1:A5), the result only shows ‘Today’ and doesn’t combine all the cells.
Simplest way to do this is to call range() and unpack result inside list assignment.
x = [*range(1, 4), *range(6, 11)]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
