Data dodania Pytanie
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
2016-11-06 19:11 CSV | Text stored as elements of a list »
I am creating a csv file which gathers several articles scraped from a website. The articles are obtained by scraping the text from URLs contained in ...
(0) odpowiedzi
2016-11-03 12:11 How do easily filter CSV data in Ruby »
I am dealing with a CSV file(approx 500 lines). Is there a way to select data from this file with filters. I know I can do this in ruby by parsing the...
(2) odpowiedzi
2016-11-01 21:11 Where is the CSV gem in Rails? »
I’m using Rails 4.2 with Ruby 2.3.0. I want to use the CSV parsing library, which according to the documentation is part of the core Ruby distribut...
(1) odpowiedzi
2016-11-01 18:11 Importing CSV file into postgreSQL but have duplicates »
I am importing CSV data into postgreSQL using Python. I seem to have duplicates in my CSV file. I have five columns in my CSV file and one of them is ...
(1) odpowiedzi
2016-10-31 11:10 How to create CSV from a text file in Ruby »
I need to create a CSV file from a textfile with billing data about my calls. My textfile has a structure like: 01.02.2016 10:35:49 8998775 New York ...
(3) odpowiedzi
2016-10-28 22:10 importing CSV data into postgreSQL using Python »
I am trying to import CSV data I have into postgreSQL using Python. It shows an error near (User) when I run the code. Can someone please provide assi...
(2) odpowiedzi
2016-10-28 16:10 A way to write data from very large csv into SQL database »
I have a multiple csv files with the following content: Duration (ms),Start date,End date,Start station number,Start station,End station number,End s...
(1) odpowiedzi
2016-10-25 11:10 Python MySQL CSV export to json strange encoding »
I received a csv file exported from a MySQL database (I think the encoding is latin1 since the language is spanish). Unfortunately the encoding is wro...
(2) odpowiedzi
2016-10-25 06:10 How to download a csv file in python from a server? »
from pip._vendor import requests import csv url = 'https://docs.google.com/spreadsheets/abcd' dataReader = csv.reader(open(url), delimiter=',', quo...
(3) odpowiedzi
2016-10-24 15:10 Assert Capybara table data »
The app I am testing shows a lot of tables with multiple columns. Each table shows data that the app fetches from different data sources(csv files) wh...
(1) odpowiedzi