If you need VBA, you could do something quick like this: This will print the number of the last row with data in it. Obviously don’t need MsgBox in there if you’re using it for some other purpose, but lastRow will become that value nonetheless.
For large arrays, a vectorised numpy operation is the fastest. If you must loop, prefer xrange/range and avoid using np.arange. In numpy you should use combinations of vectorized calculations, ufuncs and indexing to solve your problems as it runs at C speed. Looping over numpy arrays is inefficient compared to this. (Something like the worst … Read more
As the comments mention, this could produce unpredictable results like: To get the expected result, you can use one of the other answers in this question, or as @Tadhg mentioned, you can use decimal.Decimal as the jump argument. Make sure to initialize it with a string rather than a float. Or even: And then: [editor’s not: if you only … Read more
You have pylab.ylim: Note: The command has to be executed after the plot! Update 2021Since the use of pylab is now strongly discouraged by matplotlib, you should instead use pyplot:
It’s an O(N) operation to construct the new vector, but there isn’t really a better way.
To get the final value of a list pop’ed, you can do it this way: Keep in mind that pop removes the item, and the list changes length after the pop. Use negative numbers to index from the end of a list that may be changing in size, or just use pop() with no arguments for the … Read more
All of the following examples use Swift 4 Strings got a pretty big overhaul in Swift 4. When you get some substring from a String now, you get a Substring type back rather than a String. Why is this? Strings are value types in Swift. That means if you use one String to make a new one, then … Read more
You’re probably using Python3, where xrange has become range.
You are trying to run a Python 2 codebase with Python 3. xrange() was renamed to range() in Python 3. Run the game with Python 2 instead. Don’t try to port it unless you know what you are doing, most likely there will be more problems beyond xrange() vs. range(). For the record, what you are seeing is not a syntax error … Read more
use reversed() function: It’s much more meaningful. Update: If you want it to be a list (as btk pointed out): Update: If you want to use only range to achieve the same result, you can use all its parameters. range(start, stop, step) For example, to generate a list [5,4,3,2,1,0], you can use the following: It may be less intuitive but as … Read more