core.dicts

Factiva dictionaries with an optimised structure for visualisation.

Note: Dictionaries content not necessarily match exactly the current taxonomies.

Dictionaries

Define basic dictionaries of Hierarchies adn Taxonomies.

factiva.core.dicts.countries_list() → DataFrame

Read a list of official countries.

Reads a list of official countries with several additional fields that are helpful in data merges. All contries have the Factiva Code along with other identifiers.

Returns

DataFrame

Return type

A Pandas DataFrame

factiva.core.dicts.industries_hierarchy() → DataFrame

Read the Dow Jones Industry hierarchy CSV file.

Reads the Dow Jones Industry hierarchy CSV file and returns its content as a Pandas DataFrame. The root node has the fcode indroot and an empty parent.

Returns

DataFrame –

• ind_fcodestring

  Industry Factiva Code

• namestring

  Name of the Industry

• parentstring

  Factiva Code of the parent Industry

Return type

A Pandas DataFrame with the columns:

factiva.core.dicts.regions_hierarchy() → DataFrame

Read the Dow Jones Regions hierarchy CSV file.

Reads the Dow Jones Regions hierarchy CSV file and returns its content as a Pandas DataFrame. The root node has the fcode WORLD and an empty parent.

Names containng an asterisk denote nodes not officially in the hierarchy, but that help balancing and reading the structure. Level balancing is quite useful specially for visualising data.

Returns

DataFrame –

• namestring

  Name of the region node

• reg_fcodestring

  Factiva Code of the region

• parentstring

  Factiva Code of the parent region

• levelint

  Level number of the node

Return type

A Pandas DataFrame with the columns: