R \u3067data frame\u306b\u5bfe\u3057\u3066sql \u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3067\u304d\u308b\u30d1\u30c3\u30b1\u30fc\u30b8\u306esqldf\u3067\u3001\u5b58\u5728\u3057\u3066\u3044\u308b\u306f\u305a\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u6307\u5b9a\u3057\u3066\u3082’no such table’\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u8fd4\u3063\u3066\u304d\u307e\u3057\u305f<\/p>\n
\u95a2\u9023\u3059\u308b\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u3078\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u305f\u308a\u3001R\u3092\u518d\u8d77\u52d5\u3057\u305f\u308a\u3057\u305f\u306e\u3067\u3059\u304c\u52b9\u679c\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002\u3069\u3046\u3084\u3089\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u540d\u306b.\uff08\u30c9\u30c3\u30c8\uff09\u304c\u3042\u308b\u3068\u30c0\u30e1\u306a\u3088\u3046\u3067\u3059\u3002<\/p>\n
\u4ee5\u4e0b\u306e\u8a66\u884c\u4f8b\u3067\u306f\u3001df_LineList\u3067\u306f\u30a8\u30e9\u30fc\u304c\u51fa\u307e\u305b\u3093\u304cdf.LineList\u3067\u306f\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059<\/p>\n
> df.LineList <- df_LineList # \u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306e\u5185\u5bb9\u306f\u540c\u3058\r\n> df.test <- sqldf('SELECT * FROM df_LineList')\u3000# \u30a8\u30e9\u30fc\u306a\u3057\r\n> df.test <- sqldf('SELECT * FROM df.LineList')\u3000# \u3053\u3061\u3089\u3067\u306f\u30a8\u30e9\u30fc\u304c\u51fa\u308b\r\n \u30a8\u30e9\u30fc: no such table: df.LineList\r\n\r\n> class(df.LineList)\r\n[1] \"tbl_df\" \"tbl\" \"data.frame\"\r\n> class(df_LineList)\r\n[1] \"tbl_df\" \"tbl\" \"data.frame\"\r\n><\/pre>\n <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
R \u3067data frame\u306b\u5bfe\u3057\u3066sql \u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3067\u304d\u308b\u30d1\u30c3\u30b1\u30fc\u30b8\u306esqldf\u3067\u3001\u5b58\u5728\u3057\u3066\u3044\u308b\u306f\u305a\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u6307\u5b9a\u3057\u3066\u3082’no such table’\u3068\u3044\u3046\u30a8\u30e9\u30fc\u304c\u8fd4\u3063\u3066\u304d\u307e\u3057\u305f \u95a2…<\/p>\n","protected":false},"author":1,"featured_media":3355,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3380","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous"],"jetpack_featured_media_url":"https:\/\/plaza.umin.ac.jp\/~OIO\/wp-content\/uploads\/2024\/03\/Rplot.png","jetpack_shortlink":"https:\/\/wp.me\/p9b6zl-Sw","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/posts\/3380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3380"}],"version-history":[{"count":0,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/posts\/3380\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/media\/3355"}],"wp:attachment":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}