r - 查找不再可用的数据集？-6ren

r - 查找不再可用的数据集？

转载作者：行者123 更新时间：2023-12-05 02:25:57

我正在尝试按照本教程使用 R ( https://rpubs.com/brandonkopp/creating-a-treemap-in-r ) 进行数据可视化，但正在使用的数据集不再可用:

 url <- "https://www.whitehouse.gov/sites/default/files/omb/budget/fy2017/assets/outlays.csv"
 outlays <- read.csv(url, stringsAsFactors = FALSE)

Error in file(file, "rt") : cannot open the connection
In addition: Warning message:
In file(file, "rt") :
  cannot open URL 'https://www.whitehouse.gov/sites/default/files/omb/budget/fy2017/assets/outlays.csv': HTTP status was '404 Not Found'

使用“Wayback Machine”，我找到了这个网站的存档版本:https://web.archive.org/web/20160705194932/https://www.whitehouse.gov/sites/default/files/omb/budget/fy2017/assets/outlays.csv

本网站的数据以下列形式存储:

Agency Code,Agency Name,Bureau Code,Bureau Name,Account Code,Account Name,Treasury Agency Code,Subfunction Code,Subfunction Title,BEA Category,Grant/non-grant split,On- or Off- Budget,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,TQ,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021
001,Legislative Branch,00,Legislative Branch,,"Receipts, Central fiscal operations",,803,Central fiscal operations,Mandatory,Nongrant,On-budget,-628,-390,-469,-413,-410,-722,-464,-522,-439,-360,-343,-427,-539,-307,-287,-132,-429,-385,-726,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
001,Legislative Branch,00,Legislative Branch,,"Receipts, Central fiscal operations",,908,Other interest,Net interest,Nongrant,On-budget,0,0,0,-8,-7,-7,-7,-6,-6,-6,-5,-4,-4,-4,-30,-17,-104,-61,-548,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
001,Legislative Branch,00,Legislative Branch,241400,Charges for services to trust funds,,803,Central fiscal operations,Mandatory,Nongrant,On-budget,0,0,0,0,0,0,0,-32,-40,-24,0,-26,-50,0,-28,-31,-16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
001,Legislative Branch,05,Senate,0000,Senate,00,801,Legislative functions,Discretionary,Nongrant,On-budget,"26,946","29,310","29,914","33,261","35,388","38,060","42,441","47,619","57,585","65,050","74,140","78,870","93,066","102,237","123,851","31,104","138,507","158,208","169,454","183,890","195,467","213,229","227,439",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

我不确定如何获取这种格式的数据，然后将其导入 R。

有人可以建议如何做到这一点吗？又或者我把这个问题弄得太复杂了，这个数据集实际上可能在其他地方可用？

谢谢!

最佳答案

使用 read.csv。使用选择<右键单击>>> This Frame >> Show only this frame 时获得的链接。

data <- read.csv('https://web.archive.org/web/20160705194932if_/https://www.whitehouse.gov/sites/default/files/omb/budget/fy2017/assets/outlays.csv')
str(data)
# 'data.frame': 5086 obs. of  73 variables:
#   $ Agency.Code          : int  1 1 1 1 1 1 1 1 1 1 ...
# $ Agency.Name          : chr  "Legislative Branch" "Legislative Branch" "Legislative Branch" "Legislative Branch" ...
# $ Bureau.Code          : int  0 0 0 5 5 5 5 5 5 5 ...
# $ Bureau.Name          : chr  "Legislative Branch" "Legislative Branch" "Legislative Branch" "Senate" ...
# $ Account.Code         : int  NA NA 241400 0 100 101 107 108 110 115 ...
# $ Account.Name         : chr  "Receipts, Central fiscal operations" "Receipts, Central fiscal operations" "Charges for services to trust funds" "Senate" ...
# $ Treasury.Agency.Code : int  NA NA NA 0 0 0 0 0 0 0 ...
# $ Subfunction.Code     : int  803 908 803 801 801 801 801 801 801 801 ...
# $ Subfunction.Title    : chr  "Central fiscal operations" "Other interest" "Central fiscal operations" "Legislative functions" ...
# $ BEA.Category         : chr  "Mandatory" "Net interest" "Mandatory" "Discretionary" ...
# $ Grant.non.grant.split: chr  "Nongrant" "Nongrant" "Nongrant" "Nongrant" ...
# $ On..or.Off..Budget   : chr  "On-budget" "On-budget" "On-budget" "On-budget" ...
# $ X1962                : chr  "-628" "0" "0" "26,946" ...
# $ X1963                : chr  "-390" "0" "0" "29,310" ...
# $ X1964                : chr  "-469" "0" "0" "29,914" ...
# $ X1965                : chr  "-413" "-8" "0" "33,261" ...
# $ X1966                : chr  "-410" "-7" "0" "35,388" ...
# $ X1967                : chr  "-722" "-7" "0" "38,060" ...
# $ X1968                : chr  "-464" "-7" "0" "42,441" ...
# $ X1969                : chr  "-522" "-6" "-32" "47,619" ...
# $ X1970                : chr  "-439" "-6" "-40" "57,585" ...
# $ X1971                : chr  "-360" "-6" "-24" "65,050" ...
# $ X1972                : chr  "-343" "-5" "0" "74,140" ...
# $ X1973                : chr  "-427" "-4" "-26" "78,870" ...
# $ X1974                : chr  "-539" "-4" "-50" "93,066" ...
# $ X1975                : chr  "-307" "-4" "0" "102,237" ...
# $ X1976                : chr  "-287" "-30" "-28" "123,851" ...
# $ TQ                   : chr  "-132" "-17" "-31" "31,104" ...
# $ X1977                : chr  "-429" "-104" "-16" "138,507" ...
# $ X1978                : chr  "-385" "-61" "0" "158,208" ...
# $ X1979                : chr  "-726" "-548" "0" "169,454" ...
# $ X1980                : chr  "0" "0" "0" "183,890" ...
# $ X1981                : chr  "0" "0" "0" "195,467" ...
# $ X1982                : chr  "0" "0" "0" "213,229" ...
# $ X1983                : chr  "0" "0" "0" "227,439" ...
# $ X1984                : chr  "0" "0" "0" "0" ...
# $ X1985                : chr  "0" "0" "0" "0" ...
# $ X1986                : chr  "0" "0" "0" "0" ...
# $ X1987                : chr  "0" "0" "0" "0" ...
# $ X1988                : chr  "0" "0" "0" "0" ...
# $ X1989                : chr  "0" "0" "0" "0" ...
# $ X1990                : chr  "0" "0" "0" "0" ...
# $ X1991                : chr  "0" "0" "0" "0" ...
# $ X1992                : chr  "0" "0" "0" "0" ...
# $ X1993                : chr  "0" "0" "0" "0" ...
# $ X1994                : chr  "0" "0" "0" "0" ...
# $ X1995                : chr  "0" "0" "0" "0" ...
# $ X1996                : chr  "0" "0" "0" "0" ...
# $ X1997                : chr  "0" "0" "0" "0" ...
# $ X1998                : chr  "0" "0" "0" "0" ...
# $ X1999                : chr  "0" "0" "0" "0" ...
# $ X2000                : chr  "0" "0" "0" "0" ...
# $ X2001                : chr  "0" "0" "0" "0" ...
# $ X2002                : chr  "0" "0" "0" "0" ...
# $ X2003                : chr  "0" "0" "0" "0" ...
# $ X2004                : chr  "0" "0" "0" "0" ...
# $ X2005                : chr  "0" "0" "0" "0" ...
# $ X2006                : chr  "0" "0" "0" "0" ...
# $ X2007                : chr  "0" "0" "0" "0" ...
# $ X2008                : chr  "0" "0" "0" "0" ...
# $ X2009                : chr  "0" "0" "0" "0" ...
# $ X2010                : chr  "0" "0" "0" "0" ...
# $ X2011                : chr  "0" "0" "0" "0" ...
# $ X2012                : chr  "0" "0" "0" "0" ...
# $ X2013                : chr  "0" "0" "0" "0" ...
# $ X2014                : chr  "0" "0" "0" "0" ...
# $ X2015                : chr  "0" "0" "0" "0" ...
# $ X2016                : chr  "0" "0" "0" "0" ...
# $ X2017                : chr  "0" "0" "0" "0" ...
# $ X2018                : chr  "0" "0" "0" "0" ...
# $ X2019                : chr  "0" "0" "0" "0" ...
# $ X2020                : chr  "0" "0" "0" "0" ...
# $ X2021                : chr  "0" "0" "0" "0" ...

关于r - 查找不再可用的数据集？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/74161070/

文章推荐： android - Jetpack Compose 中的导航。按钮点击问题

文章推荐： r - 带 dplyr 的条件 rowMeans

文章推荐： android - Jetpack 撰写 : how to reset LazyListState?

delphi - 检测到机器是否已连接/可用？
如何检测当前网络中计算机是否已连接/可用。当然，它有多种用途，但我主要关心的是我的应用程序使用位于特定计算机中的资源，如果这些资源不可用，它甚至不会尝试连接，而是使用本地资源。最佳答案您可以尝试
javascript - 延迟函数直到 $ 可用
雅虎建议load scripts at the bottom of an HTML pages出于性能原因。我使用遵守规则的 HTML5 Boilerplate。这种方法的问题是 jQuery 也是
javascript - 如何使组件仅对少数用户可见/可用？
我有一个场景，我需要只向管理员而不是普通用户展示一个组件。说， // This component should be rendered for public users.
javascript - 将数组转换为具有默认值的对象的更简洁的方法？ (Lodash 可用)
我有一个数组，比方说 ["a","b","c"]，我想把它变成一个对象，它以数组值作为键和一个默认值我可以设置。因此，如果默认值为 true，我希望我的输出为 {a:true, b:true, c:t
.net - 如何使在该函数中可访问的函数中创建的 PSDrive 可用？
我假设在函数中创建一个新的 PS-Drive 会使该驱动器只能在该函数中访问。如何通过从该函数可访问的 MAIN 调用函数来创建 PS 驱动器？ $temproraryPSDriveName =
.net - 可用 .net 控件库的比较
您会推荐哪些 .net 控制库作为企业必备的？可以免费/非免费至少应该包含一个真正强大的Datagrid Ajax 功能有没有可用的比较？最佳答案我用过 Telerik ASP.NET控制之
javascript - 无法获取所选文本的容器(可用 jsfiddle)
假设我有一些像这样的 html: Hello World Javascript代码: var fooBar = document.getElementById('fooBar'); fooBar.
dart - Flutter 相机插件无法导入/可用
开始实现 camera plugin 时出现以下错误在我的 flutter 应用程序上: [VERBOSE-2:dart_error.cc(16)] Unhandled exception:
java - 我应该在哪里正确声明我的 "count"可用？
我想知道应该在哪里正确放置 countA，因为我希望将计数添加到所做的每个按钮中。开头的“count”变量用于制作新按钮，“countA”是我试图声明的计数，但它无法编译。这是我的代码片段:我的问题再
python - 可用 **kwargs 列表
在python帮助文档中我经常看到带有函数名和命名参数的签名行，然后你会看到**kwarg(关键字参数)。 list? 打印到帮助文档字符串: Init signature: list(self, /
c# - 可用 UWP 菜单控件之间的区别
我是 UWP 的新手，想知道“Flyout”、“ContextFlyout”和“Popup”之间的区别。另外，我想知道“AppBar”和“CommandBar”之间的区别。我相信这些是容纳菜单或菜单项
android - 可用 Wifi 设备列表
我想显示可用的 Wifi 设备列表。这是我的代码，我不明白这里有什么错误: wifi = (WifiManager) getSystemService(Context.WIFI_SERVICE); i
javascript - 使函数仅对其原型(prototype)可用
这是我的代码: Random = function(name) { this.name = name; this.addSomething = function(a, b) {
ios - 使按钮连续动画，可用 - Swift
我希望我的按钮持续动画直到用户触摸它，这是代码 func animate() { UIView.animateWithDuration(1, animations: { () -> Void
java - 阻塞直到 DataInputStream 可用
我正在为我正在参加的类(class)制作一个 HTTP 服务器作为项目，一周来我一直在尝试寻找解决方案。我有一个 DataInputStream，我需要等待客户端向我发送 http 请求，由于连接保持
linux - 如何仅打印特定范围内关闭(可用)的端口？
我想创建一个 bash 脚本来检查我的 Linux 服务器中的哪些端口已关闭且未在特定范围(端口范围 (3000-3010))中使用。打印输出只需1个端口，如果将输出保存为变量或保存在同一个文件中，
c - 如何让我的设备对 QEMU 可用
我写了一个我认为是最小的自定义设备来测试我对 QOM 和 QEMU 的总体理解。以下是省略注释的相关代码。不幸的是，当我启动 guest 并将我的设备名称作为命令行参数传递时，它无法找到我的设备并退出
python - opencv中有哪些常量(代码)可用
调用Opencv函数时，通常会提供一个常量给函数调用，如: im_hsv = cv2.cvtColor(im, cv2.COLOR_BGR2HSV) 虽然我找不到对所有可用常量的引用。 Opencv
c++ - 标准化之前多长时间 `string` 可用？
C++ 于 1998 年正式标准化，但我们能在多久以前找到一个名为 string 的类，它看起来像 C++2003 中的 std::string预标准 C++ 实现？我问是因为 CString 作为
git - 可用 --porcelain 选项的命令列表
是否有一个官方的(或可能没有)git 命令列表，--porcelain 选项可用？或者我应该在 the porcelain commands list 中手动查看它们中的每一个吗？？我已经设法用谷

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

r - 查找不再可用的数据集？