Data dodania Pytanie
2017-03-07 03:03 SyntaxError: Non-ASCII character '\xfe' in file error happen »
SyntaxError: Non-ASCII character '\xfe' in file error happen. I wanna read tsv file,and change into csv file.When I run this app,this error happen. I...
(1) odpowiedzi
2017-03-05 22:03 Sending Files in Angular 2 »
Below is my code and i am basically trying to send csv and xlxs files using my app. Although, everything looks right to me, i still cannot process and...
(0) odpowiedzi
2017-02-27 20:02 Importing CSV data into Rails app, using something other then the association "id" »
I am trying to import a few CSV files into my rails app. I learned and managed to import tables into Models without association. Now i have managed ...
(2) odpowiedzi
2017-02-26 06:02 Joining two datasets spark scala »
I have two csv files (datasets) file1 and file2. File1 consists of following columns: Orders | Requests | Book1 | Book2 Varchar| Integer | Integer...
(1) odpowiedzi
2017-02-26 00:02 pandas read_csv converters performance issue »
Description While reading large csv files (several million rows of mixed data), I used the converters parameter of pandas' read_csv method to conveni...
(1) odpowiedzi
2017-02-25 20:02 Download a csv file from ftp with ruby sinatra »
I have some ruby code that I'm using to download a csv file from an FTP server. However, right now but it's not working and not showing any error me...
(1) odpowiedzi
2017-02-21 19:02 Why would my WP plugin work for one person and not another on the same system? »
My cousin and I built a WordPress plugin for CoursePress that will take in a list of email addresses, and add them as users/students into a course. W...
(1) odpowiedzi
2017-02-16 20:02 Node js CSV to JSON (Large file) »
I need transform rows in csv file to json. I use csvtojson package and works like a charm, but my csv file is very huge, about 21.000.000 lines. :( M...
(1) odpowiedzi
2017-02-16 17:02 Rails 4: Import CSV and edit with AJAX before submission »
I have a CSV that I am directly importing using: CSV.foreach(file.path, headers: @weigh_in_cols) do |row| hashed_row = row.to_hash.except!(nil) ....
(1) odpowiedzi
2017-02-15 16:02 Download single record in CSV in Rails »
I'm using ruby csv library. When I'm trying to download multiple records it is working fine and downloading all the records in CSV file. @assets = As...
(1) odpowiedzi
2017-02-12 15:02 How to append a new list to an existing CSV file? »
I already have a CSV file created from a list using CSV writer. I want to append another list created through a for loop columnwise to a CSV file. Th...
(2) odpowiedzi
2017-02-05 00:02 turn rows values to columns , and count repetitions for all possible values mysql »
I have a table(from log file) with emails and three other columns that contains states of that user's interaction with a system, an email(user) may ha...
(4) odpowiedzi
2017-02-02 19:02 Postgresql - Regex split csv line with potentials quotes »
I would like to split a column that represent a csv line in postgres. Fields in this text line are delimited by pipe, sometime they are enclosed by qu...
(1) odpowiedzi
2017-02-01 22:02 Specifying the filename when saving a DataFrame as a CSV »
Say I have a Spark DF that I want to save to disk a CSV file. In Spark 2.0.0+, one can convert DataFrame(DataSet[Rows]) as a DataFrameWriter and use ...
(1) odpowiedzi
2017-02-01 15:02 Add header to CSV without loading CSV »
Is there a way to add a header row to a CSV without loading the CSV into memory in python? I have an 18GB CSV I want to add a header to, and all the m...
(3) odpowiedzi
2017-01-27 11:01 Speed of Powershell Script. Optimisation sought »
I have a working script who's objective is to parse data files for malformed rows before importing into Oracle. To process a 450MB csv file with > 1 m...
(3) odpowiedzi
2017-01-26 11:01 (Python)how to group rows by first column, not sorting by order? »
I have a quite oddly structured csv file. The column fields are composed of numbers, and the lines are partly, but not perfectly grouped by the first ...
(3) odpowiedzi
2017-01-25 18:01 Insert a large csv file, 200'000 rows+, into MongoDB in NodeJS »
I'm trying to parse and insert a big csv file into MongoDB but when the file extends 100'000 rows I get a bad response from the server. And the files ...
(1) odpowiedzi
2017-01-18 19:01 CSV order preserved in R »
The order of my data is important. If I load a CSV into R using read.csv, is the order of the rows in the dataframe guaranteed to match that of the CS...
(0) odpowiedzi
2017-01-15 18:01 Error Transaction.new into Rails app trying to import CSV data »
I try to import a CSV file into my database in a Rails app. I follow this gist. Here is my code: # db/seeds.rb require 'csv' csv_text = File.read(R...
(1) odpowiedzi
2017-01-04 22:01 DataTables for large CSV files »
I'm using datatables to display data from a CSV file. Some 60k rows. All works well apart from it obviously takes ages (over 70s) to display <?php...
(0) odpowiedzi
2017-01-04 15:01 How to COPY CSV as JSON fields »
Is there a way to COPY the CSV file data directly into a JSON or JSONb array? Example: CREATE TABLE mytable ( id serial PRIMARY KEY, info jS...
(1) odpowiedzi
2016-12-24 22:12 Sinatra Display CSV entries »
How do i display data from a csv file into a Sinatra-App? Sinatra: csv = CSV.read(data.csv) csv.each do |entry| @output = "#{entry[1]},#{entry[4...
(2) odpowiedzi
2016-12-19 07:12 Split column values in postgres »
I have one table with two columns id and data. The values in the table are as follows: id|data| 1 |A,B | 2 |B,C | 3 |C,D | 4 |D,A | 5 |E,C | I need...
(1) odpowiedzi
2016-12-18 23:12 How to extract data tables trapped in scanned pdf »
I have data tables trapped in scanned PDFs. I want to extract these tables into CSV files. Something similar to tabula in jruby is preferred. ...
(0) odpowiedzi
2016-12-17 20:12 Fast extraction of chunks of lines from large CSV file »
I have a large CSV file full of stock-related data formatted as such: Ticker Symbol, Date, [some variables...] So each line starts of with the s...
(3) odpowiedzi
2016-12-15 15:12 What's a fast and simple way to change a CSV sort order from a shell script? »
I have some CSVs with many columns per record; some are integers, some are (short) quoted strings. All CSVs have the same columns (and data types in t...
(1) odpowiedzi
2016-11-29 23:11 How can I export my bookmarks and import them into a table? »
I have hundreds of bookmarks that I have collected over the years that I would like to put into a searchable table with extra information such as cate...
(2) odpowiedzi
2016-11-21 14:11 How to replace comma in .xlsx file in ColdFusion? »
I have excel file that can contain commas in some fields. This can cause problem if I want to use cfspreadsheet to convert my file to csv. I was wonde...
(1) odpowiedzi
2016-11-21 13:11 Laravel whereBetween and Exporting result to CSV »
I'm using Matt Stauffer CSV export package. Using Reporting::all() I get the expected result and the CSV report is downlooaded successfully. But usin...
(1) odpowiedzi
2016-11-20 05:11 Wordpress Timeout »
I am a back end dev for a WordPress website: https://westtechshipping.com. The admin side is where the majority of our time is spent. We deal with ...
(0) odpowiedzi
2016-11-19 19:11 Writing a list to a CSV file »
I've got a piece of code that extracts coordinates from a KML file. It works beautifully and prints to the screen the way I'd want it to print to a C...
(1) odpowiedzi
2016-11-13 21:11 Letter with accent is not appearing properly in my Rails console, Postgres database or Webpage »
I have a Microsoft Excel file (saved as a CSV file) that contains a list of names. A few of the names have letters with an accent over it, like so: M...
(0) odpowiedzi
2016-11-11 19:11 Write dict to csv file with keys not in alphabetic order »
I know that when using python to write dicts to csv files, the headers will be put in alphabetic order. So is there a way that I can write the header ...
(3) odpowiedzi
2016-11-10 14:11 How to aggregate values over a bigger than RAM gzip'ed csv file? »
For starters I am new to bioinformatics and especially to programming, but I have built a script that will go through a so-called VCF file (only the i...
(2) odpowiedzi