Questions tagged as 'csv'

3
answers

Pre-process large text files in R

I am writing a script, which I will make public, to open the RAIS microdata (unidentified, available here ) in R using MonetDB. However, the bank does not accept a vignette (,) as a decimal separator. Each RAF UFano.txt file is quite large (up...
asked by 09.10.2014 / 22:52
3
answers

Organize data in Excel to open as table in R?

I have a file with 50 comments and 3 variables in Excel (.xlsx) file, and I made it into .csv. I used banco1<- read.csv("teste1.csv") to create the table in R, but my 3 variables appear in the same column. How do I make them appear sep...
asked by 29.09.2014 / 05:19
2
answers

How to create a csv from a database query and data

I was able to create a perfect .xls file, but .csv can not, it follows the code I used to create .xls $dadosXls = ""; $dadosXls .= " <table border='1' >"; $dadosXls .= " <tr>"; $dadosXls .= " <th&...
asked by 10.11.2015 / 14:31
3
answers

How to read CSV files in Java

I'm developing a web application, where after the user uploads a CSV file, my java application needs to read this CSV. Preferably separate the data into fields, so that you can add these to a database for example. After some research done on...
asked by 29.07.2014 / 20:31
1
answer

How do I export table in R in txt or csv?

I would like to know how do I export a generated data table within R to txt or csv format?     
asked by 27.04.2015 / 17:11
1
answer

Merge CSV with Python

I have a collection of dozens of CSV files. Most of them share the same fields, but some have unique fields. I want to merge them by using Python in a single CSV file with a global header that includes all the fields of all the columns. I'm usin...
asked by 11.06.2015 / 21:55
1
answer

Write to a CSV file

I need my script to write to a CSV file. The same will open a CSV file that has the column created_at (date and time), after that, the variable will be "broken" and will be written in a new CSV file the column day and time. However, it...
asked by 29.04.2017 / 17:18
1
answer

Error "invalid input '..' in utf8towcs" with "read.csv"

I have a .csv database that gathers posts from both Facebook and twitter. For reading the bank in R, the code I have used is bancodedados <- read.csv("nomedobanco.csv", sep=";", encoding="UTF-8") The code loads the database almost to t...
asked by 28.01.2015 / 14:12
1
answer

R is not recognizing the csv file separators

I have some files to work with in R, with data in decimal numbers. Files that have separators such as ; are being read correctly, but one of them has , as the border between cells. I do not know how to fix this problem in Linux Ubu...
asked by 27.10.2017 / 14:17
1
answer

Error importing CSV to phpMyAdmin

I need to import a .csv file into phpMyAdmin, but the special characters do not appear, nor the text that follows them. What could be the problem?     
asked by 16.05.2014 / 20:42