import

  1. F

    How to extract/import a PDF table in a data frame?

    To extract a PDF table in R I have used the pdftools package: library(pdftools) txt <- pdf_text("Downloads/Bac-2016.pdf") The extracted table I can see as a plain text with: cat(txt) The question is how to import this plain text table in a data frame? My OS is Ubuntu 16.04 * Introducing...
  2. A

    how to manipulate (best package) NoSQL data format in R

    Hi, I'm trying to manage data in a NoSQL format. Example: ID Date Rule 1 2016-02-03 A:20;B:30 2 2016-02-01 A:20 3 2016-01-01 B:50;C:10 I would like to be able to go through my data like Dataset[1["Rule]] and also to create the frequency distribution...
  3. R

    Importing from Excel: SAS Newbie

    I have an Excel table. In SAS 9.2, I can use File > Import Data to bring that table into the SAS Explorer pane: contents of Work now includes that file. If I double-click on it, I get a VIEWTABLE pane showing the data. I am under the impression that it exists as a temporary file that I...
  4. R

    Import several text files

    I am beginning to use R after a long stint with MATLAB and have come across a problem. I apologise in advance for the simplicity of this question. Consider the following example: TopFolder = "E:\\University" SubFolder = list.files(TopFolder) PathName =...
  5. J

    Importing Excel matrix to R.

    For an easy example, assume that Excel data ""text.xls"" in Excel 2003 (old version) version 1 3 2 5 located at the root directory c:\\ . If we want to import the matrix to an R data matrix with same size in R data directory, I used the command read.csv(file="c:\\test. xls"...