Editing
Machine Learning/OmniscopeVisualization
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== How to visualize data in a SQLITE database using Omniscope == To get an immediate sense of what this tutorial allows you to do, see [http://swarmfinancial.com/screencasts/nb/omniscopeVisualization.swf the screencast]. Download the [http://www.visokio.com/omniscope Omniscope] Trial, which will be good for a few weeks. I have heard people say that they just create a new OSX user to install the program anew and to continue using Omniscope trial beyond its expiration date. Download the [http://www.zentus.com/sqlitejdbc/ Zentus] driver -- sqlitejdbc-v054.jar is the version that works on my OSX 10.5/10.6, your mileage may vary. Connect to Database -> JDBC database -> enter details: /path/to/sqlitejdbc-v054.jar org.sqlite.JDBC jdbc:sqlite:/path/to/dbKdd.dbev No authentication, click just next; then select table name -- in our case bridge or algebra. Click next in customize SQL; Then you can select the fields to exclude in your visualization bu unchecking them: In the KDD case, I chose to remove all fields that are not relevant in test data: all time/duration fields correct first attempt incorrects hints corrects Click next then finish. It'll import your data into an IOK file -- which you need to save; Once you've done the conversion into the IOK file you won't need the DB any more for omniscope (but can refresh if data changes). If necessary, delete the first row (right click) which may contain header information, not actual data. You can then format your data: Click Data -> Manage Fields. Select the proper data types; e.g. row,problemview fields are an Integer in our KDD data To slice and dice the data: * In the top left dropdown you can select Chart view instead of Bar view. This will give you histograms. Many other possible. * change filters on the right to narrow down the data you are looking at. * etc... Note: Many operations in Omniscope take a long time; expect to wait for a few minutes when you click certain things or make selections. This is annoying but it occurs when you deal with datasets greater than a few hundred MB. Save often, so that when your Omniscope hangs you can Force Quit it and open it again if necessary. Andy
Summary:
Please note that all contributions to Noisebridge are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see
Noisebridge:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
Not logged in
Talk
Contributions
Log in
Request account
Namespaces
Page
Discussion
English
Views
Read
Edit
View history
More
Search
Dig in!
Noisebridge
- Status: MOVED
- Donate
- ABOUT
- Accessibility
- Vision
- Blog
Manual
MANUAL
Visitors
Participation
Community Standards
Channels
Operations
Events
EVENTS
Guilds
GUILDS
- Meta
- Electronics
- Fabrication
- Games
- Music
- Library
- Neuro
- Philosophy
- Funding
- Art
- Crypto
- Documentation/Wiki
Wiki
Recent Changes
Random Page
Help
Categories
(Edit)
Tools
What links here
Related changes
Special pages
Page information