I would like to import data from a CSV file into an existing database table. I do not want to save the CSV file, just take the data from it and put it into the existing table. I am using Ruby 1.9.2 and Rails 3. This is my table: create_table “mouldings”, :force => true do … Read more
Anyone know of a simple library or function to parse a csv encoded string and turn it into an array or dictionary? I don’t think I want the built in csv module because in all the examples I’ve seen that takes filepaths, not strings. 9 Answers 9
I have a long list of lists of the following form — a = [[1.2,’abc’,3],[1.2,’werew’,4],……..,[1.4,’qew’,2]] i.e. the values in the list are of different types — float,int, strings.How do I write it into a csv file so that my output csv file looks like 1.2,abc,3 1.2,werew,4 . . . 1.4,qew,2 12 Answers 12
I have data in a MySQL database. I am sending the user a URL to get their data out as a CSV file. I have the e-mailing of the link, MySQL query, etc. covered. How can I, when they click the link, have a pop-up to download a CVS with the record from MySQL? I … Read more
I have a set of custom post types and taxonomies I’ve added using the Custom Post Type UI plugin, and need to enter several hundred entries ( >500 ) How can I import this data in bulk? E.g. as a csv? 2 Answers 2 There are many options, but these functions are your friends: wp_insert_post … Read more
I am looking for help to import a .csv file into SQL Server using BULK INSERT and I have few basic questions. Issues: The CSV file data may have , (comma) in between (Ex: description), so how can I make import handling these data? If the client creates the CSV from Excel then the data … Read more
I am trying to create a .csv file with the values from a Python list. When I print the values in the list they are all unicode (?), i.e. they look something like this [u’value 1′, u’value 2′, …] If I iterate through the values in the list i.e. for v in mylist: print v … Read more
I have a list of dictionaries that looks something like this: toCSV = [{‘name’:’bob’,’age’:25,’weight’:200},{‘name’:’jim’,’age’:31,’weight’:180}] What should I do to convert this to a csv file that looks something like this: name,age,weight bob,25,200 jim,31,180 7 Answers 7
I have a CSV file with about 2000 records. Each record has a string, and a category to it: This is the first line,Line1 This is the second line,Line2 This is the third line,Line3 I need to read this file into a list that looks like this: data = [(‘This is the first line’, ‘Line1’), … Read more
I am reading a csv file into pandas. This csv file constists of four columns and some rows, but does not have a header row, which I want to add. I have been trying the following: Cov = pd.read_csv(“path/to/file.txt”, sep=’\t’) Frame=pd.DataFrame([Cov], columns = [“Sequence”, “Start”, “End”, “Coverage”]) Frame.to_csv(“path/to/file.txt”, sep=’\t’) But when I apply the code, … Read more
