Aug 23, 2023
Loading...
seen from Australia
seen from China
seen from Malaysia
seen from Syria
seen from China
seen from United States
seen from Malaysia
seen from Romania
seen from United States
seen from United States
seen from United States
seen from United States
seen from Germany
seen from Chile
seen from Ukraine
seen from China
seen from China
seen from Germany
seen from Malaysia
seen from United States
Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.
Free to watch • No registration required • HD streaming
Ever had to manually edit dusty, messy, years-old information from some obsolete software? I once worked for a company that stored paperwork offsite for 60 years. Materials were indexed in a document table. Most records had a box number, storage date, storage vendor receipt number, and a rough idea of...
Here’s some more technical writing for Zapier, featuring a much-beloved cataloguer/metadata tool in the library world, but useful for anyone who just wants their data clean, dammit.
OpenRefine - for cleaning dirty data
Some useful tutorial and presentation on OpenRefine. How many times, clients use Excel for business, so many inconsistency in data.
http://openrefine.org/
http://enipedia.tudelft.nl/wiki/OpenRefine_Tutorial
https://evanwill.github.io/clean-your-data/1-about.html
Data analysis is tricky! But, with these 5 free online data analysis tools, you’ll be able to clean up, search, share, extract, and convert data with ease.
M4 - OpenRefine tutorial from European Journalism Centre on Vimeo
https://player.vimeo.com/video/91728445 December 06, 2015 at 10:02PM
Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.
Free to watch • No registration required • HD streaming
using row.index()
“0000”[0,4-row.index.length()] + row.index
explanation
Filtering a Time Bracket in OpenRefine
Herve posted a nice explanation with sample data so that you too can filter data down to a set of consecutive moments in time, i.e. all data with timestamps falling within 10 minutes of a noteable timestamp.
The basic flow is:
Star the needed time event
Custom Text Facet > if(value.slice(11) == "16:00:00", "True", "False")
Star all Rows
Convert to Epoc Time
Date Column > Edit cells > Common transformation > To date
Edit Column > Add Column > value.datePart("time").slice(0,10)
New Column > Edit cells -> Common Transform -> To number
Create a custom text facet with a boolean
In the Epoch column a second is 1, 15 minuts is 900 seconds.
Take the Epoc value converted from 16:00:00. Add and subtract 900 to get your range.
e.g. and((1444743900 < value),(value < 1444745700))
Note that time zones will affect the actual epoc value
