可视化文本数据：国会议员及其所属机构
我很难开始使用某种方法来可视化一些主要由国会议员及其政治背景组成的数据。因此，它主要是文本数据，并不能立即适用于像 ManyEyes、Google Charts 等这样的东西。
更重要的是，我有参议员和代表的数据电子表格，包括他们对一些相关立法的立场，更重要的是他们的成员资格在某些委员会和核心小组中。
作为一个电子表格，这些数据的信息量不是很大，我试图根据各种立法行动（法案、支持信）和隶属关系（同样，委员会和核心小组）中最活跃/最重要的成员来可视化成员之间的有形关系作为电子表格形式中无法立即显现的其他有用的连接或“网络”。
我现在不知道如何进一步进行，希望有人能为提出解决方案提供一个良好的开端。
编辑1：我被SQLite作为一个工具所吸引，但我对逐字复制我试图输入到此数据库的电子表格没有兴趣进入终端。
编辑2：如果可能的话，该数据库需要可供多个不同组织中的许多不同人员访问，因此不要寻找特定于操作系统或软件的内容。
编辑3：将SQLite视为后端，我对轻量级前端/数据库管理程序感兴趣，它将使我和其他人（非-techies）来执行查询，以定义实体（例如国会议员和为其提供资金的游说者）之间的价值网络。
I am having a hard time getting started with some way to visualize some data consisting largely of congressional members and their political affiliations. As such it is mostly text data and doesn't lend itself immediately to something like ManyEyes, Google Charts etc.
More to the point, I have spreadsheets of data on senators and representatives including their stance on a few relevant legislations and more importantly their membership in certain committees and caucuses.
As a spreadsheet, this data is not very informative, I am trying to visualize tangible relationships btw members in terms of most active/salient members across various legislative actions (bills, letters of support) and affiliations (again, committees and caucuses) as well as other useful connections or "networks" that aren't immediately apparent in spreadsheet form.
I am at a point where I don't know how to proceed further and was hoping someone could suggest a good start for coming up with a solution.
EDIT 1: I've been drawn to SQLite as a tool for this, but I have no interest in copying word for word the spreadsheets I am trying to input into this database into the terminal.
EDIT 2: If possible this database needs to be accessible to many different people across a number of different organizations, so not looking for something that is OS or software specific.
EDIT 3: Looking at SQLite as a backend, I am interested in a lightweight frontend / database management program that will allow me and others (non-techies) to perform queries that get at defining the value network between entities (congresspeople and the lobbyists that fund them, for example).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我会将数据放入 MySql 或 Postgres 中，并创建一个 Web 前端以允许您自己和其他人查看数据。您可以将 Excel 文档保存为 csv，然后将数据移动到数据库中会更容易。
Protovis 或 Flare 对于创建您提到的关联网络很有帮助。 矩阵图也可能很有趣。
以下是您可能感兴趣的各种政府可视化的一些链接：
I would put the data in MySql or Postgres and create a web frontend to allow yourself and others to view the data. You can save the Excel documents to csv and then it will be much easier to move the data into your db.
Protovis or Flare would be good for creating the association networks you mentioned. A matrix diagram may also be interesting.
Here are some links with various government visualizations that might be interesting to you:
看来这个问题是个无用的问题。
使用 SQLite 和 Firefox 插件作为编辑器。
如果发生任何有趣的事情，会报告回来。
Looks like this was a dud of a question.
Using SQLite with the firefox add-on as an editor.
Will report back if anything interesting happens.