データの読み書き

data

挿入済みのパッケージで利用可能なデータ一覧を表示する。

data()

Data sets in package ‘datasets’:

AirPassengers                  Monthly Airline Passenger Numbers 1949-1960
BJsales                        Sales Data with Leading Indicator
BJsales.lead (BJsales)         Sales Data with Leading Indicator
BOD                            Biochemical Oxygen Demand
CO2                            Carbon Dioxide Uptake in Grass Plants
ChickWeight                    Weight versus age of chicks on different diets
DNase                          Elisa assay of DNase
EuStockMarkets                 Daily Closing Prices of Major European Stock Indices,
                               1991-1998
Formaldehyde                   Determination of Formaldehyde
HairEyeColor                   Hair and Eye Color of Statistics Students
Harman23.cor                   Harman Example 2.3
Harman74.cor                   Harman Example 7.4
Indometh                       Pharmacokinetics of Indomethacin
InsectSprays                   Effectiveness of Insect Sprays
JohnsonJohnson                 Quarterly Earnings per Johnson & Johnson Share
LakeHuron                      Level of Lake Huron 1875-1972
LifeCycleSavings               Intercountry Life-Cycle Savings Data
Loblolly                       Growth of Loblolly pine trees
Nile                           Flow of the River Nile
Orange                         Growth of Orange Trees
OrchardSprays                  Potency of Orchard Sprays
PlantGrowth                    Results from an Experiment on Plant Growth
Puromycin                      Reaction Velocity of an Enzymatic Reaction
Seatbelts                      Road Casualties in Great Britain 1969-84
Theoph                         Pharmacokinetics of Theophylline
Titanic                        Survival of passengers on the Titanic
ToothGrowth                    The Effect of Vitamin C on Tooth Growth in Guinea Pigs
UCBAdmissions                  Student Admissions at UC Berkeley
UKDriverDeaths                 Road Casualties in Great Britain 1969-84
UKgas                          UK Quarterly Gas Consumption
USAccDeaths                    Accidental Deaths in the US 1973-1978
USArrests                      Violent Crime Rates by US State
USJudgeRatings                 Lawyers' Ratings of State Judges in the US Superior Court
USPersonalExpenditure          Personal Expenditure Data
UScitiesD                      Distances Between European Cities and Between US Cities
VADeaths                       Death Rates in Virginia (1940)
WWWusage                       Internet Usage per Minute
WorldPhones                    The World's Telephones
ability.cov                    Ability and Intelligence Tests
airmiles                       Passenger Miles on Commercial US Airlines, 1937-1960
airquality                     New York Air Quality Measurements
anscombe                       Anscombe's Quartet of 'Identical' Simple Linear Regressions
attenu                         The Joyner-Boore Attenuation Data
attitude                       The Chatterjee-Price Attitude Data
austres                        Quarterly Time Series of the Number of Australian Residents
beaver1 (beavers)              Body Temperature Series of Two Beavers
beaver2 (beavers)              Body Temperature Series of Two Beavers
cars                           Speed and Stopping Distances of Cars
chickwts                       Chicken Weights by Feed Type
co2                            Mauna Loa Atmospheric CO2 Concentration
crimtab                        Student's 3000 Criminals Data
discoveries                    Yearly Numbers of Important Discoveries
esoph                          Smoking, Alcohol and (O)esophageal Cancer
euro                           Conversion Rates of Euro Currencies
euro.cross (euro)              Conversion Rates of Euro Currencies
eurodist                       Distances Between European Cities and Between US Cities
faithful                       Old Faithful Geyser Data
fdeaths (UKLungDeaths)         Monthly Deaths from Lung Diseases in the UK
freeny                         Freeny's Revenue Data
freeny.x (freeny)              Freeny's Revenue Data
freeny.y (freeny)              Freeny's Revenue Data
infert                         Infertility after Spontaneous and Induced Abortion
iris                           Edgar Anderson's Iris Data
iris3                          Edgar Anderson's Iris Data
islands                        Areas of the World's Major Landmasses
ldeaths (UKLungDeaths)         Monthly Deaths from Lung Diseases in the UK
lh                             Luteinizing Hormone in Blood Samples
longley                        Longley's Economic Regression Data
lynx                           Annual Canadian Lynx trappings 1821-1934
mdeaths (UKLungDeaths)         Monthly Deaths from Lung Diseases in the UK
morley                         Michelson Speed of Light Data
mtcars                         Motor Trend Car Road Tests
nhtemp                         Average Yearly Temperatures in New Haven
nottem                         Average Monthly Temperatures at Nottingham, 1920-1939
npk                            Classical N, P, K Factorial Experiment
occupationalStatus             Occupational Status of Fathers and their Sons
precip                         Annual Precipitation in US Cities
presidents                     Quarterly Approval Ratings of US Presidents
pressure                       Vapor Pressure of Mercury as a Function of Temperature
quakes                         Locations of Earthquakes off Fiji
randu                          Random Numbers from Congruential Generator RANDU
rivers                         Lengths of Major North American Rivers
rock                           Measurements on Petroleum Rock Samples
sleep                          Student's Sleep Data
stack.loss (stackloss)         Brownlee's Stack Loss Plant Data
stack.x (stackloss)            Brownlee's Stack Loss Plant Data
stackloss                      Brownlee's Stack Loss Plant Data
state.abb (state)              US State Facts and Figures
state.area (state)             US State Facts and Figures
state.center (state)           US State Facts and Figures
state.division (state)         US State Facts and Figures
state.name (state)             US State Facts and Figures
state.region (state)           US State Facts and Figures
state.x77 (state)              US State Facts and Figures
sunspot.month                  Monthly Sunspot Data, from 1749 to "Present"
sunspot.year                   Yearly Sunspot Data, 1700-1988
sunspots                       Monthly Sunspot Numbers, 1749-1983
swiss                          Swiss Fertility and Socioeconomic Indicators (1888) Data
treering                       Yearly Treering Data, -6000-1979
trees                          Girth, Height and Volume for Black Cherry Trees
uspop                          Populations Recorded by the US Census
volcano                        Topographic Information on Auckland's Maunga Whau Volcano
warpbreaks                     The Number of Breaks in Yarn during Weaving
women                          Average Heights and Weights for American Women


Use ‘data(package = .packages(all.available = TRUE))’
to list the data sets in all *available* packages.
# 挿入済みで有効なパッケージのみを表示する
data(package = .packages(all.available = TRUE))
# パッケージ名を指定して利用可能なデータ一覧を表示する
data(package = "ggplot2")

count.fields

読み込まれたデータの列数を数える

# 030temp.txtを読み込む
count.fields("030temp.txt", sep = ",")
## [1] 12
030temp.txtの内容は
"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

read.csv

CSV形式のデータを読み込む

# 030temp.csv:"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"
x <- read.csv("030temp.csv", header = FALSE, quote = "\"", sep = ",")
x
##    V1  V2  V3  V4  V5  V6  V7  V8  V9 V10 V11 V12
## 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
関数 header sep quote dec fill
read.csv TRUE , " . TRUE
read.csv2 TRUE ; " , TRUE

read.csv2は、セミコロンで区切られ、小数点がカンマの時に使用する。

write.csv

csv形式のファイルを作成する

write.csv(mtcars, file = "030mtcars.csv", row.names = FALSE, fileEncoding = "UTF-8")

read.delim

タブ区切りデータの読み込み

# 030temp.tsv:"Jan" "Feb" "Mar" "Apr" "May" "Jun" "Jul" "Aug" "Sep" "Oct" "Nov" "Dec"
x <- read.delim("030temp.tsv", header = FALSE, quote = "\"", sep = "\t")
x
##    V1  V2  V3  V4  V5  V6  V7 V8  V9 V10 V11 V12 V13
## 1 Jan Feb Mar Apr May Jun Jul NA Aug Sep Oct Nov Dec
関数 header sep quote dec fill
read.delim TRUE \t " . TRUE
read.delim2 TRUE \t " , TRUE

read.delim2は、tabで区切られ、小数点がカンマの時に使用する。

write.delim

タブ区切りデータの書き込み

library(caroline)
write.delim(mtcars, file = "030mtcars.tsv", row.names = FALSE, fileEncoding = "UTF-8")
保存された「030mtcars.tsv」の内容
mpg cyl disp    hp  drat    wt  qsec    vs  am  gear    carb
21      6   160   110   3.9   2.62  16.46   0   1   4   4
21    6 160   110   3.9   2.875 17.02   0   1   4   4
22.8    4   108   93    3.85    2.32    18.61   1   1   4   1
21.4    6   258   110   3.08    3.215   19.44   1   0   3   1
18.7    8   360   175   3.15    3.44    17.02   0   0   3   2
18.1    6   225   105   2.76    3.46    20.22   1   0   3   1
14.3    8   360   245   3.21    3.57    15.84   0   0   3   4
24.4    4   146.7   62  3.69    3.19    20    1 0   4   2
22.8    4   140.8   95  3.92    3.15    22.9    1   0   4   2
19.2    6   167.6   123 3.92    3.44    18.3    1   0   4   4
17.8    6   167.6   123 3.92    3.44    18.9    1   0   4   4
16.4    8   275.8   180 3.07    4.07    17.4    0   0   3   3
17.3    8   275.8   180 3.07    3.73    17.6    0   0   3   3
15.2    8   275.8   180 3.07    3.78    18    0 0   3   3
10.4    8   472   205   2.93    5.25    17.98   0   0   3   4
10.4    8   460   215   3       5.424   17.82   0   0   3   4
14.7    8   440   230   3.23    5.345   17.42   0   0   3   4
32.4    4   78.7    66  4.08    2.2 19.47     1 1   4   1
30.4    4   75.7    52  4.93    1.615   18.52   1   1   4   2
33.9    4   71.1    65  4.22    1.835   19.9    1   1   4   1
21.5    4   120.1   97  3.7   2.465 20.01   1   0   3   1
15.5    8   318   150   2.76  3.52  16.87   0   0   3   2
15.2    8   304   150   3.15    3.435   17.3    0   0   3   2
13.3    8   350   245   3.73  3.84  15.41   0   0   3   4
19.2    8   400   175   3.08    3.845   17.05   0   0   3   2
27.3    4   79    66    4.08    1.935   18.9    1   1   4   1
26    4 120.3 91    4.43    2.14    16.7    0   1   5   2
30.4    4   95.1    113 3.77    1.513   16.9    1   1   5   2
15.8    8   351   264   4.22    3.17    14.5    0   1   5   4
19.7    6   145   175   3.62    2.77    15.5    0   1   5   6
15    8 301   335   3.54    3.57    14.6    0   1   5   8
21.4    4   121   109   4.11    2.78    18.6    1   1   4   2
最終更新日:2016/04/27

copyrigth © 2016 r-beginners.com All rigths reserved.

PAGE TOP ▲