Displaying 6 results from an estimated 6 matches for "read_fwf".
Did you mean:
read_fds
2017 Oct 05
1
dealing with a messy dataset
dear Jim,
Yes I fixed the problem. Thanks again all of you for your contribution!
This worked :
start <- c(1, 20, 35, 41, 44, 48, 53, 59, 64, 70, 76, 78, 83, 88,
+ 93, 114, 122, 127)
data1<-read_fwf("lvg_table2.txt",skip=70, fwf_widths(diff(start)))
Well now I know how to deal with fixed-width files :)
Cheers
Jean-Philippe
On 05/10/2017 18:42, jim holtman wrote:
> You should be able to use that header information to create the
> correct parameters to the read_fwf function...
2017 Oct 05
0
dealing with a messy dataset
You should be able to use that header information to create the
correct parameters to the read_fwf function to read in the data.
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Thu, Oct 5, 2017 at 11:02 AM, jean-philippe
<jeanphilippe.fontaine at gssi.infn.it> wrote:
> dear Jim,
>
> Thank...
2017 Oct 05
3
dealing with a messy dataset
...33 5 0 -5.8 27.1 5.2 6
5.7 0 NA -18 2 2. 4 MESSIER031 2 4 1.75
Cheers, thanks again
Jean-Philippe
On 05/10/2017 16:49, jim holtman wrote:
> start <- c(1, 20, 35, 41, 44, 48, 53, 59, 64, 69, 75, 77, 82, 87,
> + 92, 114, 121, 127)
> > read_fwf(input, fwf_widths(diff(start)))
--
Jean-Philippe Fontaine
PhD Student in Astroparticle Physics,
Gran Sasso Science Institute (GSSI),
Viale Francesco Crispi 7,
67100 L'Aquila, Italy
Mobile: +393487128593, +33615653774
2017 Oct 05
4
dealing with a messy dataset
dear R-users,
I am facing a quite regular and basic problem when it comes to dealing
with datasets, but I cannot find any satisfying answer so far.
I have a messy dataset of galaxies like that :
And XVIII 000214.5+450520 0.69 17 9 0.00 -8.7 26.8 6.44
6.78 < 6.65 -44 0.5 MESSIER031 0.6 1.54
PAndAS-03 000356.4+405319 0.10 17 0.00 -3.6 27.8
4.38
2017 Oct 05
0
dealing with a messy dataset
Is this a fixed width format?
If so, read.fwf() in base, or read_fwf() in the readr package will solve the problem. You may need to trim trailing spaces though.
B.
> On Oct 5, 2017, at 10:12 AM, jean-philippe <jeanphilippe.fontaine at gssi.infn.it> wrote:
>
> dear R-users,
>
>
> I am facing a quite regular and basic problem when it c...
2017 Oct 05
0
dealing with a messy dataset
...3 -1.5 -2.72
+ And XX 000730.7+350756 0.20 33 5 0.00 -5.8 27.1
5.26 5.70 -182 2.4 MESSIER031 2.4 1.75"
>
> start <- c(1, 20, 35, 41, 44, 48, 53, 59, 64, 69, 75, 77, 82, 87,
+ 92, 114, 121, 127)
> read_fwf(input, fwf_widths(diff(start)))
# A tibble: 7 x 17
X1 X2 X3 X4 X5 X6 X7 X8
X9 X10 X11 X12 X13 X14
<chr> <chr> <dbl> <int> <int> <dbl> <dbl> <dbl>
<dbl> <dbl>...