+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Function to skip meta data in a .csv file using Python (/thread-11701.html)
Function to skip meta data in a .csv file using Python - ajgardev - Jul-22-2018
I have a functioning code to skip the meta data in a .csv file using Python. However, I cannot understand what this part of the code is doing:
else:
if not col:
continue #No columns found yet
else:
i+=1 #Last column found
break The whole code is as follows:def readPandoraCSV(file):
with open(file) as f:
lines=f.readlines()
col=0
for i in range(len(lines)):
line=lines[i]
if line[0:6]=='Column':
col+=1
else:
if not col:
continue #No columns found yet
else:
i+=1 #Last column found
break
df=read_csv(file,skiprows=range(i),header=None)
try:
df['JDate']=df[df.columns[0]].apply(getJD)
df=df.drop(df.columns[0],1)
except:
df['JDate']=df[df.columns[1]].apply(getJD)
df=df.drop(df.columns[1],1)
return dfThe meta data in the .csv file looks as follows:https://i.stack.imgur.com/uS4zJ.jpg
RE: Function to skip meta data in a .csv file using Python - Larz60+ - Jul-22-2018
if
col == 0, then if not col is True.continue means skip remainder of this iteration (of loop) and continue with next
break means quit loop unconditionally