No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
6 Posted Topics
if a file that has multiple columns, like [CODE]1 7 3 8 5 6 3 4 5 6 7 8 1 7 6 4 4 3[/CODE] i want to read the first row and see if there numbers that are grater than 6. Then add that number to all the …
i have a folder that contains csv excel files that have numbers in the first column labeled 'x', second column label'y', and third column labeled'z'. i was trying to take all of the numbers in the x and calculate the averages and std, take all the numbers in the y …
my excel files have more than a 1000 numbers under the columns that are labeled x, y, z for each excel file. i was trying to print the x, y, and z values for all of the excel files in to a single excel file(Trying_excel.xls)that would have all of the …
im trying to calculate the average and std for x, y, and z column for about 50 excel files that i saved in a folder. each excel files has x values in the first column, y in the second, and z in the third column. im using this script, but …
[CODE]import xlrd import os path='foder' #put in the path to the folder where you saved all your excel files dirList=os.listdir(path) for file in dirList: fullpath=os.path.join(path,file) wb = xlrd.open_workbook(file) sh = wb.sheet_by_index(0) #or you can open the sheet by name sh = wb.sheet_by_name(u'Sheet1')[/CODE]
i have about a 1000 excel files that have data sets.it was collected from about a 20 patients. so i have a script that reads data sets for each patient from all of the excel files. im having trouble printing the values in separate excel files that each file represents …
The End.