Extract Word

fantoonfantoon MemberPosts:2Contributor I
edited August 2020 inHelp

Hi All,

I am currently working on a project to analyze Federal Open Market Committee minutes for the past 20 years in order to determine how the stock market will act or react to the FOMC decision to either increase or decrease interest rate.

I have converted all Fed Mins to Text documents as well as my preprocessing included the following operators Transform cases, tokenize, Filter Stop words, stem porter, filter tokens by length, and generate N-Grams).

My struggle to come up with a process to extract only “Interest Rate” phrase from each meeting minutes as well as “interest rate % percentage” ( Numeric)

For example, Meeting December 2017:

Interest Rate

1%

I have attached a sample of the Fed meeting mintues.

I really appreciate it your help in advance. Thanks!

Tagged:

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:578Unicorn

    I didn't see any attachment for the example so I used your table. Possibly the Extract Information operator is the one you want?
























    Bring out the interest rate value using RegEx.













    sgenzer
  • fantoonfantoon MemberPosts:2Contributor I

    我附上了联邦政府会议纪要的竞争w. I would like to extract “federal funds

    Rate” in column and numerical value “1/4 to 1/2 percent” in column.

    Can you please send a screenshot of the process to extract one word and numerical value?

    Thank you for your help

Sign InorRegisterto comment.