I have a csv file, while each row has 6 columns.
The first column represents ID, and are six characters (the first character is an empty space). The second and third columns represent latitude and longitude, where they each should be 8 floating point numbers with two decimals. The next 3 columns represent values, and they each have 10 floating points number with two decimals. How to reformat this csv file according to this format, and to save it as a txt file? Thanks for your help.
For example, DF represent the csv file:
12091 39.90 145.90 12.92 100.92
12092 39.95 144.12 14.00 110.10