4 .Text is the formatted cell's displayed value; .Value is the value of the cell possibly augmented with date or currency indicators; .Value2 is the raw underlying value stripped of any extraneous information. val = d2['col_name'] But as a result, I get a dataframe that contains one row and one column (i.e., one cell). It is not what I need.

Understanding the Context

I need one value (one float number). How can I do it in pandas? How can I get a value from a cell of a dataframe? - Stack Overflow The fastest way to access indexes of list within loop in Python 3.7 is to use the enumerate method for small, medium and huge lists.

Key Insights

Please see different approaches which can be used to iterate over list and access index value and their performance metrics (which I suppose would be useful for you) in code samples below: How can I access the index value in a 'for' loop? - Stack Overflow 5 This exception will be returned if you attempt to count values in a null collection. For example the below works when Errors is not null, however if Errors is null then the Value cannot be null. Parameter name: source exception occurs. 2 Numpy can also be used to get the ascii value of a character.

Final Thoughts

It is particularly useful if you need to convert a lot of characters to their ascii/unicode codepoints. Depending on the number of characters, it could be orders of magnitude faster than calling ord in a loop. How to get the ASCII value of a character - Stack Overflow