Python Forum
Function to skip meta data in a .csv file using Python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Function to skip meta data in a .csv file using Python
#1
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 df
The meta data in the .csv file looks as follows:

https://i.stack.imgur.com/uS4zJ.jpg
Reply
#2
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Why is the 'meta description' html tag not translated? Melcu54 2 983 Oct-15-2022, 10:55 PM
Last Post: Larz60+
  How to modify python script to append data on file using sql server 2019? ahmedbarbary 1 1,232 Aug-03-2022, 06:03 AM
Last Post: Pedroski55
  need to skip password prompt, continue... tester_V 2 1,476 Oct-19-2021, 05:49 PM
Last Post: tester_V
  Delimiters - How to skip some html tags from being translate Melcu54 0 1,663 May-26-2021, 06:21 AM
Last Post: Melcu54
  How to skip to a different line while importing a different script kat_gamer 2 2,251 Feb-03-2021, 04:10 AM
Last Post: deanhystad
  xml file creation from an XML file template and data from an excel file naji_python 1 2,125 Dec-21-2020, 03:24 PM
Last Post: Gribouillis
  How to use the count function from an Excel file using Python? jpy 2 4,470 Dec-21-2020, 12:30 AM
Last Post: jpy
  Databricks, Python Notebook Data file use issue khalid2200 0 1,765 Nov-25-2020, 03:36 AM
Last Post: khalid2200
  How to skip a folder directory in a loop mfkzolo 2 12,602 Nov-18-2020, 07:56 AM
Last Post: mfkzolo
  saving data from text file to CSV file in python having delimiter as space K11 1 2,415 Sep-11-2020, 06:28 AM
Last Post: bowlofred

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020