fred_as_dataframe

EconDataReader

Up to date remote economic data access for ruby, using Polars dataframes.

This package will fetch economic and financial information from the Federal Reserve Economic Database, and return the results as a Polars Dataframe. You will need an API key that can be fetched from the FRED website at https://fredaccount.stlouisfed.org/apikeys .

Installation

Add this line to your application's Gemfile:

gem 'fred_as_dataframe'

And then execute:

$ bundle install

Or install it yourself as:

$ gem install fred_as_dataframe

Configuration

Some data sources will require the specification of an API key. These keys should be provided as part of a configuration file, e.g., config/fred_as_dataframe.rb

FredAsDataframe::Client.configure do |config|
  config.fred_api_key = '1234567890ABCDEF'
    OR
  config.fred_api_key = File.read(File.join('','home', 'user', '.fred_api_key.txt'))
end

Usage

Consider the following transcript.

3.1.2 :001 > a = FredAsDataframe::Client.new('UNRATE')
 => #<FredAsDataframe::Client:0x0000000105f1dbb8 @api_key="1234567890ABCDEF", @tag="UNRATE"> 
3.1.2 :002 > b = a.fetch
 => 
shape: (919, 2)                                                    
...                                                                
3.1.2 :003 > b
 => 
shape: (919, 2)                                                    
┌────────────┬────────┐                                            
│ Timestamps ┆ UNRATE │                                            
│ ---        ┆ ---    │                                            
│ date       ┆ f64    │                                            
╞════════════╪════════╡                                            
│ 1948-01-01 ┆ 3.4    │                                            
│ 1948-02-01 ┆ 3.8    │                                            
│ 1948-03-01 ┆ 4.0    │                            
│ 1948-04-01 ┆ 3.9    │                            
│ 1948-05-01 ┆ 3.5    │
│ …          ┆ …      │
│ 2024-03-01 ┆ 3.8    │
│ 2024-04-01 ┆ 3.9    │
│ 2024-05-01 ┆ 4.0    │
│ 2024-06-01 ┆ 4.1    │
│ 2024-07-01 ┆ 4.3    │
└────────────┴────────┘ 
3.1.2 :004 > a = FredAsDataframe::Client.new('AAA')
 => #<FredAsDataframe::Client:0x0000000106077d38 @api_key="1234567890ABCDEF", @tag="AAA"> 
3.1.2 :005 > b = a.fetch
 => 
shape: (1_267, 2)        
...                      
3.1.2 :006 > b
 => 
shape: (1_267, 2)        
┌────────────┬──────┐    
│ Timestamps ┆ AAA  │    
│ ---        ┆ ---  │    
│ date       ┆ f64  │    
╞════════════╪══════╡    
│ 1919-01-01 ┆ 5.35 │    
│ 1919-02-01 ┆ 5.35 │
│ 1919-03-01 ┆ 5.39 │
│ 1919-04-01 ┆ 5.44 │
│ 1919-05-01 ┆ 5.39 │
│ …          ┆ …    │
│ 2024-03-01 ┆ 5.01 │
│ 2024-04-01 ┆ 5.28 │
│ 2024-05-01 ┆ 5.25 │
│ 2024-06-01 ┆ 5.13 │
│ 2024-07-01 ┆ 5.12 │
└────────────┴──────┘ 

Documentation

TBD

Contributing

Others are welcome to contribute to the project.

The following conventions are intended for this project.

• Different sources are intended to reside in different classes.
• API keys (if needed) should be able to be set in the single configuration file.
• Series should be able to be identified via a single unique string, provided in the constructor.
• When fetched, the dataset may be filtered based on optional (hash) arguments.
• Output should be provided in a consistent DataFrame format (currently Polars::DataFrame).

Bug reports and pull requests are welcome on GitHub at https://github.com/bmck/fred_as_dataframe.

License

The gem is available as open source under the terms of the MIT License.