Questions tagged [vroom]
The vroom tag has no usage guidance.
vroom
30
questions
1
vote
1
answer
38
views
How to read CSV file with all variables in character using `vroom`?
How to read 'myfile.csv' with all variables in character using vroom ?
library(vroom)
'Below code can't work
input_file_2<- vroom('myfile.csv',colClasses = 'character')
1
vote
2
answers
41
views
How to check what percentage of a column is made up of certain rows
I have a CSV file that is too large to be opened in Excel. In this file, I am trying to see how much of each column's sum is from rows 1, 47:56, and 156:158. This does NOT include the first two ...
1
vote
0
answers
72
views
Difficulty making HTTP request to VROOM and obtaining the list of optimized coordinates
The goal of my study is to optimize garbage collection routes. To achieve this, I utilized OpenStreetMaps to obtain a list of coordinates and, using OSRM, calculated the distance of the current route. ...
2
votes
0
answers
72
views
R: read_csv ignores col_types
I'm using read_csv to read in data while trying to ensure variables are read in as the correct type. To do so, I've first set up a "data dictionary", containing the mapping between variable ...
0
votes
0
answers
63
views
vroom-express and ors , locations out of bounds
hey have trouble getting the locations to work no idea how
this is my api request :
http://localhost:3000
header Content-Type application/json
and body :
{"vehicles":[{"id":1,"...
0
votes
0
answers
113
views
Vroom error in reading multiple csv files in a folder
I have a vroom error when reading multiple csv files, the strange thing is that the code was made 9 months ago without any issues, so I am guessing something happened after package updates or Rstudio ...
0
votes
0
answers
35
views
Error in vroom:vroom("x.csv") : NA/NaN argument
I have wrote a tibble using vroom_write(df, 'x.csv) in a first script.
Next, when I want to open this tibble, using x <- vroom:vroom('x.csv'), it does not work and show me the following error ...
0
votes
0
answers
88
views
How to Enforce a Specific Starting Point for a Vehicle in VROOM
I'm implementing a delivery routing system using VROOM and I need to control the starting point in which a driver picks up orders from different restaurants. The driver, referred to as Vehicle 1, is ...
2
votes
2
answers
161
views
Pre-filtering with pipe connections and vroom
I want to read a large .txt file into R using the vroom package, because is fast and supports pipe connections for pre-filtering.
For reproducibility, let's read this UK cats csv file from the Tidy ...
2
votes
2
answers
107
views
`read_fwf` and `vroom_fwf` accidentally skipping first lines?
I'm sure I'm doing something silly, but I can't quite figure it out. Both read_fwf and vroom_fwf are producing files that lack one line (the first line, to be precise) when importing fixed-width files....
2
votes
0
answers
58
views
Define the linebreak character importing a csv in R
I am wondering, if there's no way to import this type of csv file into R. The csv file, one can download from https://ec.europa.eu/eurostat/ramon/nomenclatures/index.cfm?TargetUrl=LST_CLS_DLD&...
0
votes
1
answer
18
views
full join error in R since switching from read.csv
I've just swapped out read.csv for vroom and since then my full_join is not working. It throws following error
Error in [.data.table(y, x, nomatch = if (all.x) NA else NULL, on = by, : logical ...
4
votes
1
answer
317
views
vroom id argument - use filenames instead of archive name
I'd like to read a remote archive file with vroom and get a additional column with the filenames instead of archive name. Is this possible with vroom without the local archive_extract step as shown in ...
1
vote
1
answer
52
views
vroom_write writes negative zeros to file
I am trying to use vroom::vroom_write to write a tibble to a text file. Within my R session, I see that the third column of my tibble has some zeros. When I examine the text file, I see that some of ...
0
votes
3
answers
474
views
Converting 7 or 8 digit numbers to dates in R
I am importing a very large fixed-width dataset into R and wish to use vroom for much better speed. However, the dates in this dataset are in numeric format with either 7 or 8 digits, depending on ...