0

I have a curiously formatted text file with data that I'm trying to upload into R. The text file is structured in three huge lines of data (one for each variable). I'd like each line to be a column, and each entry to be an observation. The observations correspond to one another by order. As in, the 5th entry in 'epochNums' corresponds to the 5th entry in 'epochDates' and the 5th entry in 'epochDays'.

The problem is that in the first and third variables, each datapoint is separated by a space; in the second, datapoints are separated by quotations. I'm having trouble figuring out how to work around that as I upload the data. I have included three screenshots of the beginning of each variable as they appear in the text file.

And this link (https://www.dropbox.com/s/4ey94shqnk05jcm/Data?dl=0) should allow people to download the data.

Very grateful for any guidance!

Variable 1

Variable 2

Variable 3

Andrew
  • 5
  • 2
  • 3
    We cannot read data into R from images. Please [make this question reproducible](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) by including a small representative dataset in a plain text format - for example the output from `dput(yourdata)`, if that is not too large. – neilfws Oct 10 '22 at 00:07
  • 1
    Okay I just posted a link to the data that should allow a download. – Andrew Oct 10 '22 at 00:23

1 Answers1

0

This will get the data read in, which is just the start of your problems, you will need to do some structuring to make this useful.

require(readtext)
data=readtext("data.txt")
data$text[1] #Returns the text in a giant string you need to parse

My way of handling this would be to use some kind of a text editor/simple IDE like Brackets or Notepad++ to go with find/replace and get it in the shape it needs to be to read as a tab or comma separated file, that would be the easiest way to work with it down the line, but you can read it in this way and figure out what to do with it from here.

sconfluentus
  • 4,693
  • 1
  • 21
  • 40