Read txt file with multiple separators

Question

I want to read the data to create a plot.

My source data is:

["201801",111],["201802",222],["201803",333]

I want to create a dataframe like:

201801 111

201802 222

201803 333

I tried to use

df <- read.table('fuel_data.txt',header=FALSE, sep = ",")

It doesn't work because "," is not only used to separate data inside record but also separate different records. Is there a way to read this kind of data into a data frame?

Thanks!

Answer 1

Replace each [ with a newline and each ] and comma with a space and then read it in:

txt <- '["201801",111],["201802",222],["201803",333]'
read.table(text = chartr("[],", "\n  ", txt))

giving:

      V1  V2
1 201801 111
2 201802 222
3 201803 333