How to import and clean a text file into dataframe in R

Question

How to clean a text file into dataframe in R? I have a text file with tables, paragraphs, and few headings. How to extract from txt file with rows

Answer 1

You can use readLines() or read.table() depending on the data.

Suppose if your text file contain text, headings or paragraphs, netadata,etc. the you can fetch that data using readLines and mentioning the number of lines and starting line number using skip.

read_table = read.table("C:\\Users\\Cherukuri_Sindhu\\Documents\\sample.txt", skip = 1,nrows = 4)

The above code will fetch 4 rows from 2nd line. similarily use different parameters available to get your table from text document.

read_text = readLines("C:\\Users\\Cherukuri_Sindhu\\Documents\\sample.txt",n = 2)