Tagged Questions
0
votes
1answer
33 views
finding standard deviation down a column of data in python
A.append([(float(a) + float(b) + float(c))/3,
(float(d) + float(e) + float(f))/3,
(float(g) + float(h) + ...
0
votes
1answer
32 views
iterating through an output comparing data in same position for continuity
A.append([(float(a) + float(b) + float(c))/3,
(float(d) + float(e) + float(f))/3,
(float(g) + float(h) + float(i))/3,
(float(j) + float(k) + float(l))/3,
(float(m) + float(n) + ...
1
vote
1answer
32 views
screening out negatives before taking average (python)
I have this program to read in data, average across a row of three and then average down columns, so far it does all this fine. However I am now trying to go back and have it take out negative data ...
0
votes
1answer
35 views
formatting python output file in such a way that columns can be accessed later
In the program I am working on I am reading in data from a .xls filethat looks like this
2012-SEP-27 04:35:00 0.035173 0.019666 0.001566 -0.002356 0.028054 ...
2
votes
3answers
72 views
Averaging down a column of averaged data
I am writing a code in python for a project that has to accomplish a few things;
1) read in data from an xls file column by column
2) average each row of the columns in groups of three
3) then average ...
-1
votes
0answers
73 views
Make an array using variables in Python
I have a netCDF file and I want to insert 5 variables with lists of data into 5 different columns. Basically I want to make an array. How can I do this?
How would I take these variables and format ...
0
votes
3answers
110 views
Counting number of columns in text file with Python
I have two text files composed of spaced-separated columns. These are excerpts of these two files:
FileA
1 1742.420 -0.410 20.1530 0.4190 1.7080 0.5940
2 1872.060 0.070 21.4710 ...
0
votes
0answers
46 views
combining multiple CSV processes with python
I work for a local municipality and provide mapping for the police department. Each month, I get a report from them that I use to plot their calls. For a while, I manually edited the CSV file to ...
0
votes
2answers
87 views
how to compare values of a column and add a counter if the same value is found
I have the file energy.txt:
path energy counter
AXX 100.00 1
AXX 99.99 2
AXX 99.98 1
AXX 99.50 1
AXX 99.00 7
I want to compare ...
0
votes
0answers
96 views
Search a .log file and output results to csv in Python
I would like to use Python to search through a log file multiple times using the same grep statement (or the equivalent of a grep statement in Python) and output the results to .csv file, appending ...
0
votes
1answer
99 views
Reformatting a stopwatch .csv in Python
I know that there must be a few ways of doing this, but I'd love to get your opinion on which would be the best way to do so.
I have a .csv, outputted from a phone's stopwatch application that looks ...
1
vote
0answers
124 views
Creating a new list of csv columns for each iteration
I'm trying to write a csv file that should look like this. What I get is this, where all the data is output as two long columns. Here's the code.
import requests
import csv
item_dictionary = ...
3
votes
4answers
150 views
Efficient way to organise data file in columns with Python
I'm getting an output data file of a program which looks like this, with more than one line for each time step:
0.0000E+00 0.0000E+00 0.0000E+00 0.0000E+00 0.0000E+00 0.0000E+00 \n ...
0
votes
1answer
381 views
Python Pandas: converting several boolean columns into a (possibly repeated) column made up of the boolean column names
Suppose I have the DataFrame below:
>>> dfrm = pandas.DataFrame({
"A":[1,2,3],
"id1":[True, True, False],
...
0
votes
0answers
294 views
columns independently spanning over multiple pages in reportlab's pdfgen
I am trying to create a pdf with two columns spanning over multiple pages where each column gets populated independently of the other. Pdfgen though seems to fill up all available space pagewise and ...
