I’ve got a two step solution for you: x <- list.files(path = “your directory”, pattern = “.csv”) y <- lapply(x,fread) data <- rbindlist(y) Reads in all the csvs in your directory as data tables then binds then together. After that i’d just subset as follows: data <- data[Date >= “your dates”,] EDIT* I get the … Read more
i found the solution thank you guys for showing intrest, accully the function where() do the iteration it self (that i did’nt know) there is no need to put it in an other loop, only the loop over “ngrains will do the trick. data=loadtxt(‘data.csv’,delimiter=”,”) data1=data.transpose() ngrains=loadtxt(‘nombre_grain.csv’,delimiter=”,”) phi0ex=len(ngrains)*[zeros(shape(250))] for k in range(len(ngrains)): print ngrains[k] phi0ex[k]=where(data1==ngrains[k],1,0) print … Read more
What you’re WriteLineing is a value of List<string>.ToString(), which is not what you want. Try foreaching over the test list and WriteLine each line separately.
Are you trying to write your dictionary in a Excel Spreadsheet? In this case, you could use win32com library: import win32com.client xlApp = win32com.client.DispatchEx(‘Excel.Application’) xlApp.Visible = 0 xlBook = xlApp.Workbooks.Open(my_filename) sht = xlBook.Worksheets(my_sheet) row = 1 for element in dict.keys(): sht.Cells(row, 1).Value = element sht.Cells(row, 2).Value = dict[element] row += 1 xlBook.Save() xlBook.Close() Note that … Read more
This should work public bool CheckFile() { StreamReader sr = new StreamReader(File.Open(@”YourFilePath”, FileMode.Open)); string toCheck; using (sr) { toCheck = sr.ReadToEnd(); } return toCheck.Contains(“fileName”); }
You can effectively update any existing file “in-place” by first giving it a temporary file name and then writing a new file with its original name. import csv import os filename=”mytestfile.csv” tempfilename = os.path.splitext(filename)[0] + ‘.bak’ try: os.remove(tempfilename) # delete any existing temp file except OSError: pass os.rename(filename, tempfilename) with open(filename, mode=”wb”) as outfile: csvwriter … Read more
with open(‘the_file_name’) as file: only_numbers = [re.findall(r’\b\d+\b’, line) for line in file] then save it to another file.
You want to skip 1 line but this will skip two lines: for(int i = 0; i <= 1; i++) Also your code is unnecessarily complicated, something like this is easier to follow: String line = br.readLine(); // read first line br.readLine(); // skip 2nd line while((line = br.readLine()) != null) // read the rest … Read more
This part is pretty easy because you’re able to run LINQ queries on IEnumerable<T> – in other words, anything that you can do a foreach loop on is something that you can query. And there are a great many ways to do that. First, however, I’m assuming that you already know the schema for the … Read more
import re data = open(“state_capitals.csv”).read() state_name = raw_input(“Enter State Name:”) print re.findall(“.*%s.*”%(state_name,),data,re.I) probably