Python, CSV, skipping lines based on content -

-

I am handling CSV files with buffer rows before the header, the number of rows changes and some rows are stringed Nothing is nothing but the one thing that is consistent is that one or more cells in these buffer rows have zero values, so I am trying to release any line from a null cell.

I've got this scripting outputting a blank file on the following script. I am feeling that I am not getting 'and' but I am feeling that if I put it in a loop, then I will prepare a file for each line ... 

 Outf ("out_" + fileName, 'wb') in the form of inf (filename, 'rb') as outf: csvreader = csv.DictReader (inf) if 'csvreader.fieldnames' In: next (csvreader) else: fieldnames = [name 'url_source', 'downloaded_at'] + csvreader.fieldnames # csvwriter = csv.DictWriter (outf, field name) for csvwriter.writeheader () Add column name to node, in enumerate Line (csv Reader, 1): csvwriter .writerow (dict (line, url_source = csvUrl, downloaded_at = today))

Your code a object; Either it will read and leave a line, then back, or will read this whole file and copy it to a new CSV. Both of them will never do

If you can not rely on the first row of the header, then do not rely on DictReader () field names to auto-load. Find the headers manually, then go to DictReader () constructor on them.

Open as a regular csv.reader () , first , find the first line to find that real line, then type the file to Reload as csv.DictReader () as a field name clearly as: Asf opened (file name, 'rb') with < / P> 

  open ("out _" + filename, 'wb') outf: reader = csv.reader (inf) # Line for the line in the reader as the header: if not in the '' line Is: field name = row Breaking Second Second: # Ops, * Only * Rows with empty values ​​value value ('unable to set header row)' # Rewind, switch to dict reader, headline inf.seek for line in previous read reader (0) reader = csv.DictReader (inf, fieldnames): If all the rows with row.keys () == row.values ​​() break # extra two columns author = csv.DictWriter (outf, [ 'Url_source', 'downloaded' '+ name of field)
author Author (Author) (Author (Author (Author (R, URL_Source = CSU URL, Download_T = = Today) for R in Reader)

Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Create dynamic LINQ query expression at runtime which translates into a parameterized SQL query for nullable types -

-
This question is related to my I want to make my custom expression for IQueryable in a nutshell. To achieve this goal, I wrote the next code. Public stable IQueryable & lt; T & gt; Filter Aquales & lt; T, TLL & gt; (This IQueryable & lt; T & gt; qSource, expression & lt; Func & lt; t; TLL; Field, TV value) {var fieldFilter = ExpressionClosureFactory.GetField (value); Var constraint = expression. Aqual (field. Body, field filter); Apply Return (qSource, Obstacle, Zone. Parameter); } Private Stable IQueryable & lt; T & gt; Apply & lt; T & gt; (IQueryable & lt; T & gt; qSource, Expression Barrier, ReadOnlyCollection & lt; Parameter Exposure & gt; Parameter) {var predicateFrom = Expression Lambda & lt; Func & lt; T, bool & gt; & Gt; (Hurdle, parameter); Return qSource.Where (predicateFrom); } Public Speaking Expression Clausfactree {Public Status Member Expert Gatefield & lt; TVLUE & gt; (TV va...
Read more

cmake - cpack generates RPMs with %files entries that conflict with the RPM spec. How to fix? -

-
Recently, I need to make sure that using our software by using cpack RHEL 7 and it can be packaged for free reconstruction (such as CentOS 7). Despite this, I have had a problem which was not present for RHEL 6.x and its free rebuilding: RPM, which has its % files cpack System entries such as the following are generated: % dir% attr (0755, root, root) "/"% dir% attr (0755, root, root) "/ usr"% Dir% attr (0755, root, root) "/ usr / bin"% dir% attr (0755, root, root) "/ usr / share"% dir% attr (0755, root, root) "/ usr / share / Applications "% dir% atr (0755, root, root)" / usr / share / doc "% dir% attr (0755, root, root)" / usr / share / icons "% di "/ Usr / share / icons / hicolor" / dir / hicolor "/ usr / users / share / icon / hicolor / scalable"% dir% attr (0755, root, root) Enter the% dir% plus (0755, root, root) "/ scalable / app" code which should not be declared by ...
Read more