csv Questions
13
I am a little new to Python, and I have been using the Jupyter Notebook through Anaconda. I am trying to import a csv file to make a DataFrame, but I am unable to import the file.
Here is an attem...
10
Solved
I have a .xls I need to convert to .csv
The file contains some date columns. The format on the date is "*14/03/2001" which, according to Excel means the date responds to regional date and time set...
Dressmaker asked 7/2, 2013 at 23:8
4
Solved
I'm working with DataTable's and I need to convert them to a CSV file format. Most of the tables I am working with have over 50,000 records so I'm trying to minimize the time it takes to convert th...
Highams asked 13/2, 2015 at 15:51
9
Solved
I am using python to extract Arabic tweets from twitter and save it as a CSV file, but when I open the saved file in excel the Arabic language displays as symbols. However, inside python, notepad, ...
Bantam asked 15/2, 2020 at 13:13
5
I have a text file in this format :
{
attribute1 attribute2 attribute3.... attributeN
value"A" value"B" value"C".... value"Z"
/* next line of values*/
}
Each word is separated by a tab.
H...
Witchery asked 8/4, 2011 at 4:58
4
Solved
I'm working with an ODS file in LibreOffice, and every now and then I want to convert it to CSV from the command line.
I have found two tools for this: libreoffice --headless --convert-to csv and u...
Disparage asked 29/10, 2020 at 10:21
6
Solved
I need to compare two csv files in windows7.
How can I proceed to achieve this. I want to see the differences in both the files , like we can use tkdiff in Linux.
Transverse asked 4/11, 2015 at 13:38
4
I'm currently trying to parse a value from a csv file that is a boolean. We've noticed that the value will successfully parse Yes and Y (in any case) but will not parse No and N
I'm mapping the va...
7
Solved
I am new to python and I have a scenario where there are multiple parquet files with file names in order. ex: par_file1,par_file2,par_file3 and so on upto 100 files in a folder.
I need to read the...
7
Solved
I try to read a CSV and echo the content. But the content displays the characters wrong.
Mäx Müstermänn -> Mäx Müstermänn
Encoding of the CSV file is UTF-8 without BOM (checked with Notepad++...
5
Solved
Is there anyway to write the following code in Ruby without writing the file to disk?
temp_file = 'path/to/file.csv'
users = [[email protected], [email protected]]
CSV.open(temp_file, "...
2
Solved
Learning Ruby for the first time to automate cleaning up some CSV files.
I've managed to piece together the script below from other SO questions but for some reason the script does not read the f...
10
I have several method to transform php array to csv string both from stackoverflow and google. But I am in trouble that if I want to store mobile number such as 01727499452, it saves as without fir...
Percolate asked 3/5, 2013 at 6:0
10
Solved
I'm trying to parse a CSV string to an array in PHP. The CSV string has the following attributes:
Delimiter: ,
Enclosure: "
New line: \r\n
Example content:
"12345","Computers","Acer","4","Varta...
4
Solved
I've been trying to get a express app to send the response as stream.
var Readable = require('stream').Readable;
var rs = Readable();
app.get('/report', function(req,res) {
res.statusCode = 20...
Mckibben asked 5/8, 2016 at 11:58
3
Solved
I'm trying to upload a csv file, which is 250MB. Basically 4 million rows and 6 columns of time series data (1min). The usual procedure is:
location = r'C:\Users\Name\Folder_1\Folder_2\file.csv'
d...
7
Context: I have a Post Mongoose model that contains a csv_files array field to store csv strings. I make a fetch API request from a different web app to POST the csv strings for a particular Post.
...
Michaud asked 20/7, 2017 at 18:51
3
Solved
I realize that the csv library in Python always generates DOS end-of-line characters. Even if I use the 'wb' mode, even if I use Linux.
import csv
f = open('output.txt', 'wb');
writer = csv.write...
Rockhampton asked 23/3, 2012 at 19:53
8
Solved
I need to import a csv file with 20 million rows and 2 columns into a database, but when I try to do this with MySQL Workbench's data import wizard it is extremely slow, probably is going to take 1...
Carabiniere asked 23/10, 2015 at 7:3
6
Solved
Is it possible to use the with statement directly with CSV files? It seems natural to be able to do something like this:
import csv
with csv.reader(open("myfile.csv")) as reader:
# do things with...
Remarkable asked 13/1, 2009 at 22:36
10
Solved
I am struggling to find a way to write data to a CSV in Node.js.
There are several CSV plugins available however they only 'write' to stdout.
Ideally I want to write on a row-by-row basis using a...
Porphyria asked 19/4, 2012 at 11:32
7
Solved
I have been looking for the past 2 hours for a solution to my problem in vain. I'am trying to read a CSV File using Apache commons ,I am able to read the whole file but my problem is how to extract...
Hurlburt asked 28/3, 2016 at 19:13
5
Solved
I'm trying to write a CSV file using Python's csv writer.
One of the column values is enclosed in "" [double quotes] e.g.: 'col1' 'col2' "test". When I open the file in Wordpad,...
Galimatias asked 31/7, 2014 at 10:43
10
My csv file has no column name for the first column, and I want to rename it. Usually, I would do data.rename(columns={'oldname':'newname'}, inplace=True), but there is no name in the csv file, jus...
5
I am trying to upload a csv into MySQL using the Workbench, and so far all my attempts have proven fruitless.
I initially attempted to use the "Upload" function, but it complained about any null/e...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.