I have CSV file which has 2 columns. Time, Value. I want to read value, say corresponding to 104 nanoseconds but problem is Time is in exponential format and power of exponent keep on changing to ensure that there is just one digit before the decimal. Example.
Assuming your exponential values are numbers and not strings, exponential values are valid floats, so you could just multiply the values in the column by 10^9 for nano seconds
6.e-07 * 1000000000
would give you 600
if it is a string, then you can just cast it to a float:
float("6.e-07") * 1000000000