Hi list, i need to load .txt files with data into tables.<br><br>But my .txt file is not forrmated and theres some texts i need to get rid from my files:<br><br><br><br>my .txt looks like this:<br><br> Format IAGA-2002 |<br>
Source of Data Institute of Geophysics NAS of Ukraine |<br> Station Name Kiev Dymer |<br> IAGA CODE KIV |<br>
Geodetic Latitude 50.700 |<br> Geodetic Longitude 30.300 |<br> Elevation |<br>
Reported XYZF |<br> Sensor Orientation |<br> Digital Sampling |<br>
Data Interval Type 1-minute |<br> Data Type variation |<br> # This data file was created using INTERMAGNET data |<br>
# from the Edinburgh GIN. These data were acquired |<br> # from an INTERMAGNET reported data file. |<br> # Final data will be available on the INTERMAGNET DVD |<br>
# Go to <a href="http://www.intermagnet.org">www.intermagnet.org</a> for details on obtaining this product. |<br> # CONDITIONS OF USE: The conditions of use for data provided |<br> # through INTERMAGNET and acknowledgement templates can be found |<br>
# at <a href="http://www.intermagnet.org">www.intermagnet.org</a> |<br>DATE TIME DOY KIVX KIVY KIVZ KIVF |<br>2011-08-22 00:00:00.000 234 19201.70 2411.10 46524.20 99999.00<br>
2011-08-22 00:01:00.000 234 19201.50 2411.20 46524.20 99999.00<br>2011-08-22 00:02:00.000 234 19201.50 2411.20 46524.30 99999.00<br>2011-08-22 00:03:00.000 234 19201.40 2411.20 46524.30 99999.00<br>
2011-08-22 00:04:00.000 234 19201.30 2411.20 46524.30 99999.00<br>2011-08-22 00:05:00.000 234 19201.20 2411.00 46524.40 99999.00<br>2011-08-22 00:06:00.000 234 19201.10 2410.80 46524.50 99999.00<br>
2011-08-22 00:07:00.000 234 19201.00 2411.00 46524.50 99999.00<br>2011-08-22 00:08:00.000 234 19201.00 2411.20 46524.40 99999.00<br>2011-08-22 00:09:00.000 234 19201.10 2411.40 46524.30 99999.00<br>
2011-08-22 00:10:00.000 234 19201.10 2411.60 46524.30 99999.00<br>2011-08-22 00:11:00.000 234 19201.00 2411.70 46524.30 99999.00<br>2011-08-22 00:12:00.000 234 19201.10 2411.70 46524.30 99999.00<br>
2011-08-22 00:13:00.000 234 19201.20 2412.00 46524.30 99999.00<br>2011-08-22 00:14:00.000 234 19201.30 2411.90 46524.40 99999.00<br><br><br><br><br>and so on....<br><br><br>I just need to load the 3 last colums into tables starting at line 20.<br>
<br>Is it possible to tell pd to load just specific specific part of my .txt file?<br>or which is the best approach for this?<br><br>I can copy the data by hand but since i have tons of .txt files im looking for an automatic way of doing this.<br>
<br><br><br>cheers<br><br><br><br>Umberto.<br><br>