Reputation
5,444
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 9 54
Newest
 Nice Answer
Impact
~52k people reached

2d
awarded  Nice Answer
Aug
23
comment best practices for saving Datasets and TemporalData to a SQL database
@LeonidShifrin, maybe in Russia, but here it's not 2005 anymore. Are you going to WTC in Oct?
Aug
22
awarded  Electorate
Aug
22
comment How does Dataset compare to DataFrame in pandas?
@M.R. Interestingly, Dataset provides an internal type system and spreadsheet-like formatting, but Query works on (nested) Associations and Lists even w/o Dataset wrapper.
Aug
22
comment How does Dataset compare to DataFrame in pandas?
Agree w/ Leonid. It's likely to benefit the community. As of 2013 Rexer report, Mathematica isn't even in the top 10 systems for data analysis.
Aug
21
comment best practices for saving Datasets and TemporalData to a SQL database
@LeonidShifrin, see also Google Cloud Storage JSON API googlecloudplatform.blogspot.com/2014/05/…
Aug
21
comment best practices for saving Datasets and TemporalData to a SQL database
@LeonidShifrin, there's APIs for using JSON as storage (eg lawnchair, Mongo) and BSON variant for binary: "a computer data interchange format used mainly as a data storage and network transfer format in the MongoDB database." The network is increasingly the memory - literally in NDN if not Internet.
Aug
21
comment best practices for saving Datasets and TemporalData to a SQL database
@LeonidShifrin, "JSON is similar to other data formats like XML - if you need to transmit more data, you just send more data. There's no inherent size limitation to the overall JSON request itself. " (stackoverflow.com/questions/1262376/…). JSON is as or more relevant in the web age the formats you selected.
Aug
21
comment best practices for saving Datasets and TemporalData to a SQL database
@LeonidShifrin, the elephant in the room is JSON.
Aug
21
comment best practices for saving Datasets and TemporalData to a SQL database
You've heard of NoSQL? Free your mind and your data like marklogic. In our studies we manage ~GB scale data, mostly temporal, stored in ~1k CSV files or Google gsheets. By letting the filesystem (eg Google Drive) do the work, a 1 line Query, the directory tree can be efficiently reconstructed as nested Associations. We routinely use Mathematica, R, and Python to access and analyze this without any DBMS.
Aug
17
comment Modifying the built in graphic format of colors
I edited to emphasize that I'm looking to apply Graphics like options but to the box format if possible.
Aug
17
revised Modifying the built in graphic format of colors
added 752 characters in body
Aug
17
comment Convert .csv Dataset and store in Databin
@ElArchitect, Re SemanticImport and related functions are not ready for prime time, nor do most M.SE users seem to consider them part Mathematic: eg I asked how to improve performance on recognizing dates from contracts, mathematica.stackexchange.com/questions/79241/…, you can see by the votes how popular.
Aug
14
comment Modifying the built in graphic format of colors
In fact I would prefer to apply operators eg form[verticalRectangle] to Red rather than modify the built in. I should rephrase or ask a separate Q? By built in I meant operate directly on the box rather than creating Graphics. Doable?
Aug
13
comment Modifying the built in graphic format of colors
@bills, That works, eg Table[Graphics[{Red, Rectangle[]}, AspectRatio -> 2, ImageSize -> 10], {5}] // Row
Aug
13
asked Modifying the built in graphic format of colors
Aug
5
comment Why doesn't Rationalize work for 0. in Interval?
What's the transitive closure? This is a disaster waiting to happen in temporal queries or real time systems.
Aug
5
comment Why doesn't Rationalize work for 0. in Interval?
@Guesswhoitis., most positive values of 2nd parameters seem to work, though note above counterexample. But I want to know why this issue is Interval specific.
Aug
5
comment Why doesn't Rationalize work for 0. in Interval?
@belisarius, try this: Interval[{0., 1.}] // Map[Rationalize[#, 0.0000000000000001] &, #, {2}] &
Aug
5
asked Why doesn't Rationalize work for 0. in Interval?