csv Questions
5
Solved
I'm using Python and I need to split my .csv imported data in two parts, a training and test set, E.G 70% training and 30% test.
I keep getting various errors, such as 'list' object is not callab...
Kirghiz asked 29/4, 2017 at 15:13
22
I am trying to read a *.csv-file.
The *.csv-file consist of two columns separated by semicolon (";").
I am able to read the *.csv-file using StreamReader and able to separate each line by using ...
5
I'm currently struggling with Windows Browser to check mimetype of a csv file. I've tried checking it via:
console.log($('#file')[0].files[0].type); // output: ""
But when I use Linux browser, i...
Sean asked 26/5, 2016 at 16:56
11
How do you convert multiple xlsx files to csv files with a batch script?
Arlberg asked 10/3, 2011 at 7:34
17
Solved
I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS.
How do I do it?
23
Solved
I have an unnormalized events-diary CSV from a client that I'm trying to load into a MySQL table so that I can refactor into a sane format. I created a table called 'CSVImport' that has one field f...
Photograph asked 3/9, 2010 at 11:10
2
Solved
I have a big data.frame that I want to write into a compressed CSV file. Is there any way to directly write the data into a CSV.TAR.GZ compressed file instead of performing write.csv/gzip steps in ...
2
I would like to create a code which is Python 2.7-3.6 compatible I am trying to fix a problem with the csv module where initially I used outfile=open('./test.csv','wb') in Python 2.7 now I have to ...
Rickrickard asked 19/5, 2019 at 8:56
3
Solved
I have dumped a mysql table as CSV. In this CSV file, the NULL values are written as \N
Now I want to import this data into sqlite database, but I am unable to tell sqlite that \N are null values. ...
20
Solved
15
I am importing some data of 20,000 rows from a CSV file into MySQL.
Columns in the CSV file are in a different order than MySQL tables' columns. How can I automatically assign columns corresponding...
Nadinenadir asked 2/1, 2013 at 18:55
8
Solved
How do I read the following CSV file?
1,"A towel,",1.0
42," it says, ",2.0
1337,is about the most ,-1
0,massively useful thing ,123
-2,an interstellar hitchhiker can have.,3
H...
26
Solved
I'm working on a feature to export search results to a CSV file to be opened in Excel. One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. In order to co...
Grassi asked 19/4, 2010 at 15:31
11
Solved
I'm running PostgreSQL 9.2.6 on OS X 10.6.8. I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually cre...
Polyhydric asked 9/1, 2014 at 10:57
3
Solved
I use Google Sheets (spreadsheet) to combine article data for different sources for my Gambio shop.
To import the data I need the pipe symbol as delimiter / separator and " as text delimiter in a ....
Luciferase asked 13/3, 2018 at 4:48
7
Solved
I have a CSV file with 100 rows.
How do I read specific rows?
I want to read say the 9th line or the 23rd line etc?
3
I am able to successfully write the CSV data to SQLite using pandas in python using this code:
df = pandas.read_csv(path + '/issues.csv')
df.to_sql('issues', connection, if_exists='replace', inde...
3
Solved
Hi I am trying to write a CSV with HEBREW text in it. It writes some symbol not an Hebrew text. Below is my PHP CODE.
<?php
$list = array (
array('שלטל', 'שלטל', 'שלטל', 'שלטל'),
array('123'...
Applicator asked 22/1, 2016 at 6:36
2
Solved
I have a .csv file that I would like to render in a FastAPI app. I only managed to render the .csv file in JSON format as follows:
def transform_question_format(csv_file_name):
json_file_name = f...
3
Solved
I using jackson-dataformat-csv library. I want parse CSV file. I have this code:
CsvMapper csvMapper = new CsvMapper();
CsvSchema csvSchema = csvMapper.typedSchemaFor(Map.class).withHeader();
L...
5
Solved
I'm trying to load 2 big csv into nodejs, first one has a size of 257 597 ko and second one 104 330 ko. I'm using the filesystem (fs) and csv modules, here's my code :
fs.readFile('path/to/my/file...
5
Solved
I am importing a CSV file using powershell.
The problem is, the title of one of the columns is "Remaining Time - Hours".
So I'm getting a sequence of objects, and it's actually assigned the proper...
Embrocation asked 1/2, 2011 at 0:47
10
If you have a csv dataset like this:
name, age, gender
john, 20, male
jane, 30, female
bob, 25, male
Can you get to this:
[ {"name": "john", "age": 20, "gender&q...
13
Solved
I am using awk to perform counting the sum of one column in the csv file. The data format is something like:
id, name, value
1, foo, 17
2, bar, 76
3, "I am the, question", 99
I was using this aw...
Sulemasulf asked 29/6, 2010 at 6:35
9
Solved
I am just in need to convert a this html table automatically in csv using PHP.
Can someone provide any idea how to do this?
Thanks.
$table = '<table border="1">
<tr>
<th>Header 1...
© 2022 - 2025 — McMap. All rights reserved.