import pandas as pd df = pd.read_table("C:\\Campbellsci\\LoggerNet\\CR1000_Table1.dat", delimiter=',', parse_dates=[1,], low_memory=False, skiprows=1) cols = df.columns.drop("TMSTAMP") df[cols] = df[cols].apply(pd.to_numeric, errors='coerce') df.to_excel("C:\\Users\\Makada\\Desktop\\Map1.xlsx")
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs