csv - With statement being ignored in Python -


i have 2 functions. first creates new csv file (from existing csv). second appends same data new csv, in different order of rows.

when run in 1 file first function works second not. when tried putting second function in separate file calling in first script, did work, albeit had enter input twice.

what need change second function run properly? 

import csv export = raw_input('>') new_file = raw_input('>')  ynabfile = open(export, 'rb') reader = csv.reader(ynabfile)  def create_file():     open(new_file, 'wb') result:         writer = csv.writer(result)         r in reader:             writer.writerow((r[3], r[5], r[6],r[7], r[7],                 r[8],r[8],r[9],r[10]))  def append():     open(new_file, 'ab') result2:         writer2 = csv.writer(result2)         in reader:             writer.writerow((r[3], r[5], r[6], r[7], r[7],                 r[8], r[8], r[10], r[9]))  create_file()  append()

i'm new python , programming in general, if there around better way this, i'm ears.

the csv reader has read entire file pointed ynabfile, on second call (or subsequent calls) either create_file or append not able fetch more data using reader until file pointer sent beginning. in case, quick fix this:

create_file() ynabfile.seek(0) append()

i recommend restructuring code bit avoid pitfalls this. few recommendations:

  • read contents in ynabfile list instead, if can fit entirety of file memory
  • have create_file , append take parameter of input , output file names
  • alternatively, have 2 functions take file pointer (ynabfile in case), , ensure seeked beginning create new csv.reader instance using that.

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more