Gap Analysis/Report for CSV in Python 3.6.2 -

- 

start         end mm0001        mm0009 mm0010        mm0020 mm0030        mm0039 mm0059        mm0071

good afternoon, wanted create code in python in 3.6.2 allow me gaps in rows of consecutive numbers, such one. output screen missing numbers in format similar below:

mm0021    mm0029 mm0040    mm0051 mm0052    mm0058

i've created code program based on answer found around here, don't believe it's complete, being done in python 2.7 believe. used basis trying do.

import csv open('thedata.csv') csvfile:     reader = csv.reader (csvfile)     line, row in enumerate(reader, 1):     if not row:        print 'start of line', line, 'contents', row

any appreciated.

import csv  def out(*args):      print('{},{}'.format(*(str(i).rjust(4, "0") in args)))  prev = 0 data = csv.reader(open('thedata.csv'))  print(*next(data), sep=', ') #  header  line in data:     start, end = (int(s.strip()[2:]) s in line)      if start != prev+1:         out(prev+1, start-1)      prev = end     out(start, end)

it’s ugly sorry, should work?

outputs comma separated text

if doesn’t work, or want save file, comment


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more