Skip to main content
27 votes

Can I build my own curated data function?

Update: Template Notebook I finally got around to finishing my curated data template notebook. You can see it here Currently it only supports single-type data paclets, but a template for multi-type ...
b3m2a1's user avatar
  • 46.9k
21 votes
Accepted

Difference between = and Ctrl + =

= can only be entered at the beginning of a cell and then interprets the entire cell content as a free-form WolframAlpha query. By contrast, CTRL-= can be used to create an inline WolframAlpha ...
WReach's user avatar
  • 69.1k
19 votes
Accepted

What are the benefits of Entity Classes for Databases?

Preamble As was already hinted in the comments, the new functionality is a much higher level. It is basically a compiler from entity query language to SQL, specialized to a given SQL dialect of the ...
Leonid Shifrin's user avatar
14 votes
Accepted

How to get the expression of a special function?

reps = Entity["MathematicalFunction", "Gamma"][ "IntegralRepresentations"] reps[[2]][z] EDIT:...
Bob Hanlon's user avatar
  • 160k
13 votes

Dataset function and related gadgets not ideal for large datasets

Why would you limit yourself to Database-like operations as J. M. nicely put it, when you can have true out-of-core SQL? In version 12 we have introduced integration of SQL-backed databases into the ...
Carlo's user avatar
  • 1,181
12 votes
Accepted

How can I use Mathematica to sort the US Congressional Districts by Perimeter÷Area

The US congressional districts are available as geographic entities in the form Entity["USCongressionalDistrict", "Illinois:District7"] As such, in principle you ...
Emilio Pisanty's user avatar
12 votes
Accepted

Is it possible to restrict the arguments for a function to a specific entity type?

As pointed out by Kuba in comments, when we make a function definition the pattern variables are not restricted to be simple x_head. So you can create a definition ...
Jason B.'s user avatar
  • 68.9k
12 votes
Accepted

How to do a database query on substrings?

I am one of the developers for the new relational database connectivity features. Very soon, a rather extensive tutorial will be added to the current documentation (via documentation paclet update), ...
Leonid Shifrin's user avatar
11 votes
Accepted

How can I get the time zone of a US ZIP code?

TimeZoneOffset[Entity["ZIPCode", "94402"]] -8.
kglr's user avatar
  • 398k
11 votes
Accepted

How to manipulate date in SQL via the EntityFramework?

The issue here is that there are restrictions upon the form of EntityFunction definitions when an entity store is backed by a relational data source. In order to ...
WReach's user avatar
  • 69.1k
11 votes

When looking at a chemical's bond lengths, which bonds do they represent?

There must be a better way, but here is a first pass. This method is based on [Experimental] functions, two of which are new in MMA 12, BondList and ...
LouisB's user avatar
  • 12.6k
10 votes
Accepted

Change units in PlanetData["Earth", "Diameter"] from miles to km

You can use the UnitSystem option of EntityProperty, ...
Jason B.'s user avatar
  • 68.9k
10 votes
Accepted

How do I find the list of values for an EntityProperty qualifier?

You can discover available qualifiers and values for a property like this: EntityValue[ EntityProperty["Country", "ExternalBalance"], "QualifierValues"] I did ...
M.R.'s user avatar
  • 31.6k
8 votes

How to turn a colour entity into a colour directive?

FromEntity and ToEntity can do the conversion. ...
8 votes
Accepted

How to take top 10 built-in function

Here are at least two ways: ...
J. M.'s missing motivation's user avatar
8 votes

How to take top 10 built-in function

Not An Answer Here's a cute way to look at what we like vs. what WRI likes: ...
8 votes

How can I filter an EntityClass by _not_ having a property?

Alternative solution with FilteredEntityClass and EntityFunction The code For the sake of documenting this one more time on ...
Leonid Shifrin's user avatar
8 votes
Accepted

Exporting results containing Entities to JSON?

You can use "ConversionFunction" / "ConversionRules" for ...
Kuba's user avatar
  • 137k
8 votes

What procedures do you take to find the right Entity?

Edits: cleaning and added a function under the EntityClassList section to search for classes. I will add stuff here as I learn to use entities. Outline Practical ...
userrandrand's user avatar
  • 5,937
7 votes
Accepted

How to import data about mountain and then plot it?

GeoElevationData has elevation data for the whole world. If you know the position (I hope I interpreted correctly the Wikipedia data from your link): ...
jose's user avatar
  • 6,393
7 votes

How can I use Mathematica to sort the US Congressional Districts by Perimeter÷Area

First (update: I guess the missing ones should be deleted), ...
Michael E2's user avatar
  • 237k
7 votes

How to add city markers to a map of Germany?

Entities are not meant to be typed directly. There is no way to guess the correct format. Instead, type Ctrl-=, type the name of the city in any form you like: N├╝rnberg or Nuremberg will both work, ...
Szabolcs's user avatar
  • 236k
7 votes

How to add city markers to a map of Germany?

Using an external API ...
rhermans's user avatar
  • 36.7k
7 votes
Accepted

How to convert entity to string?

Every Entity should have a "Name" property that returns a string, If you have city defined ...
Jason B.'s user avatar
  • 68.9k
7 votes
Accepted

How can I filter an EntityClass by _not_ having a property?

You can use the operator UnequalTo for this purpose: EntityList @ EntityClass["Country", "Continent"->UnequalTo["Europe"]] ...
Carl Woll's user avatar
  • 131k
6 votes
Accepted

How can I define geographic regions and new entities?

Since release of Wolfram Language 11 users can define their own entities with: EntityStore $EntityStores Example: ...
Vitaliy Kaurov's user avatar
6 votes

Plots of United States states with non-standard labels

GeoMarkers gets the job done. Here's a plot of sales taxes: ...
C. E.'s user avatar
  • 70.8k
6 votes

How to turn a colour entity into a colour directive?

ent is an Entity of "Color" you can investigate its properties. EntityProperties["Color"] ...
Edmund's user avatar
  • 42.4k
6 votes
Accepted

Cases and Entity

You need to specify the levelspec as {0} using the third argument of Cases: ...
kglr's user avatar
  • 398k
6 votes

Generate the complement of the Earth's land mass polygons

The answer is almost there in the OP. The "Ocean" Entity is used there but only the "Oceans"...
Edmund's user avatar
  • 42.4k

Only top scored, non community-wiki answers of a minimum length are eligible