Generating multiple CSV files on hourly basis in Python -

-

I have a python module, called HariseSecGeneration_JPi. I have some data that is generated on hourly basis. Sample.txt is Sample.txt is sampled in data here: - 

  2014-07-24 15: 00: 00,1,1,1,1,1001 2014-07-24 15: 01: 00,1,1,1,1,1001 2014-07-24 15: 02: 00,1,1,1,1001 2014-07-24 15:15, 00,1,1,1, 1, 1001 2014-07-24 15: 16: 00,1,1,1,1,1001 2014-07-24 15:17-17: 00,1,1,1,1001 2014-07-24 15:30: 00,1,1,1,1,1001 2014-07-24 15: 31: 00,1,1,1,1001 2014-07-24 15: 32,101,1,1, 1,1001 2014 -07-24 15: 45: 00,1,1,1,1,1001 2014-07-24 15: 46: 00,1,1,1,1,1001 2014-07-24 15:47:47, 1,1,1,1,1001   
 As you can see that 4 intervals are 00-15, 15-30, 30, 45 and 45-59 and the next hour starts And so on I am writing code that will read data in this txt file and generate 4 CSV files for each hour in one day. Therefore, the analysis of the above data should be generated by 4 CSV files, which should be named Conference 2014-07-24 15: 00 CSV, which contains 15:00 and 15:15, 2014-07-24 15:15 data containing CSV 15:15 And data for every hour at 15:30 and so on. Python code should do all this.  
 Here's my current code snippet: -  
  CSV import def Connection (): for = open ("sample.txt", "R") for data =. Line = line.strip ("\ n") line = line.split ("headline"); line = line.strip (" , ") Time = line [0] rows = [time for x]. Full ('in') if x] i = lane (rows) if i == 0: other release: hours, minutes, seconds = line [ 0], lines [1], lines [2] minute = int (minutes) if minutes & gt; = 0 more minute & lt; 15: print hours, minute print line [1:] alif min & gt; = 15 more minutes & lt; 30: print hours, minute print line [1:] alif min & gt; = 30 more minutes & lt; 45: print hours, minute print line [1:] alif min & gt; = 45 more minutes & lt; 59: Print Hours, Minutes Print Line [1:] Connection ()   
 [1:] Returns the right data for each interval and I am writing to write and write the CSV files I am information So instead of printing [1:], I want it to be written in the CSV file of that interval, which are written with the appropriate naming conventions as described in the above description.  
 Expected Output: -  
  2014-07-24 15: 00 CSV should contain 1,1,1,1,1001 1,1,1,1 , 1001,1,1,1,1001 2014-07-24 15:15 in CSV 1,1,1,1,1001,1,1,1,1,1,1,1,1,1,1,1001   
 and so on should be 15.30 for .csv and 15.45 csv. Keeping in mind this is a small part of the data. The actual data is meant for every hour of data to create 4 CSV files for 24 * 4 files each day for each day. So how can I make my code stronger and more efficient?  
 Any help? Thanks   
 
 
, seems like a job for  itertools.groupby  The time stamp is increasingly increasing the price:   from itertools as date time datetime from date import code> Import imap, from GroupBy operator import get_first = itemgetter (0) get_second = itemgetter ( 1) DEF (line) process_line itemgetter: timestamp_string, _, value = line.partition (',') timestamp = DateTime.strptime (timestamp_string, '% Y-% m-% D% H:% M:% S') Returns (timestamp.rele (min = timestamp.minet // 15 * 15, sec = 0), value) DE Main (): With Open ('sample.txt', 'R' as lines): Date, in group GroupBy (IMAP (process_line, lines), get_first): Open ('{0:% Y --comp.format (date), 'mou') with out_file as: out_file.writelines (IMAP (get_second, group)) if __name__ == '__main__': -% m-% d% H_% M} Main ()

Comments

Post a Comment

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

-
I have a SKScene where I am adding an SKSpriteNode I have subclassed the SKSpriteNode class to create this node. In the subclass I am defining some SKActions on Sprite. What do I want to do when the end of this phantom ends the SKAction sequence, then I add a new Prayer node to this scene. How is this possible. The following code is mine: The code for the sequence is that I'm running on the Scansprinitode subclass (TEMissileNode): - SKAction * moveDown = [SKAction moveToY: Self.position.y - 20 Duration: 0.2]; SKAction * animation = [SKAction animateWithTextures: textures timePerFrame: time / 7]; SKAction * moveMissileProjectile = [SKAction Moving: Pointoffscreen Term: Time]; SKAction * group = [SKAction group: @ [animation, movement projectile]]; SKAction * Sequence = [SKAction Sequence: @ [Hilldown, Group, [SKAction removalFromParent]]]; [Self run action: sequence]; From the main scene, I call those actions that execute these tasks TEMissileNode * missile = [tmissil...
Read more

Matlab transpose a table vector -

-
An embarrassing simple question seems to be, but how can I move a Matlab table vector? aTableT = aTable '; I tried a standard syntax for the simple interaction of a line vector to a line vector aTable : ATableT = reshape (aTable, 1, Height (aTable)); and aTableT = rot90 (aTable); According to the head, the last time table should work for table, see. However, I get this error code: Error type in using table / permit (line 396) Undefined function 'permute' for the input arguments. Error in rot 90 (line 29) b = magnitude (b, [2 1 3: ndims (a)]); NB: fliplr is not useful either pretty sure I have covered clear angles - any ideas? Thanks! Try changing your table into an array, move it, then back to a table In other words, try doing this: aTableArray = table2array (aTable); ATableT = array 2table (aTableArray. '); I have also read the document for rot90 , and it says that rot90 is definitely working for tables Do, and I find you...
Read more

c# - Textbox not clickable but editable -

-
I have a small form with 10 text boxes, I have set them in the correct tab order. I want them on my tab service I was wondering if there is a way to set the text box so that they can be selected for editing until they are tabbed. That is ... I do not want the end user to edit the text box to click on them, I just want to make them editable through tabu. this should do the trick public partial category poor text box: Text Box {Safe Override Zero WndProc (Ref: Message Message) {if (m.msg == (Int) WM.LBUTTONDOWN) {Return; // mount down events} base.WndProc (ref m); }} Window message enum can be found. How to do this without anherizing: text box : class EatMouseDown: netwindows {safe override zero WndProc (ref message message) {if (m.msg == (int) WM.LBUTTONDOWN) {return; } Base.WandProc (Ref M); }} Safe Override Zero Onload (EventEurge E) {base.OnLoad (e); How to do this without any part: left a clean part, whatever is important, this can be a buggy but it works R...
Read more