System and method for automated extraction and standardization of financial time-series data from semi-structured tabular input
AssigneeJPMorgan Chase Bank, N.A.
InventorsArmineh Nourbakhsh, Sameena Shah, Maria Manuela Veloso
Life of this patent
Estimating the term…
Abstract
A method and a system for extracting and formatting financial time-series data is provided. The method includes: receiving a first set of tabular data; segmenting the first set of tabular data into a plurality of cells; determining whether each respective cell is a header cell or a content cell; for each header cell, normalizing each of a time period and a metric associated therewith; for each content cell, determining one or more column header cells and one or more row header cells associated. therewith; and generating an output table based on a result thereof.
Claims22
A method for extracting and formatting financial time-series data, the method being implemented by at least one processor, the method comprising:
- receiving, by the at least one processor, a first set of tabular data;
- automatically segmenting, by the at least one processor, the first set of tabular data into a plurality of cells;
- automatically determining, by the at least one processor for each respective cell of the plurality of cells, whether the respective cell is a header cell or a content cell;
- for each respective cell determined to be a header cell, normalizing each of a time period and a metric associated with the respective header cell;
- for each respective cell determined to be a content cell, automatically determining, from among the plurality of cells determined to be header cells, at least one column header cell and at least one row header cell associated with the respective content cell;
- and
- automatically generating an output table based on a result of the determining of the corresponding at least one column header cell and the corresponding at least one row header cell associated with each respective content cell.
A computing apparatus for extracting and formatting financial time-series data, the computing apparatus comprising:
- a processor;
- a memory;
- and
- a communication interface coupled to each of the processor and the memory,
- wherein the processor is configured to:
- receive, via the communication interface, a first set of tabular data;
- automatically segment the first set of tabular data into a plurality of cells;
- automatically determine, for each respective cell of the plurality of cells, whether the respective cell is a header cell or a content cell;
- for each respective cell determined to be a header cell, normalize each of a time period and a metric associated with the respective header cell;
- for each respective cell determined to be a content cell, automatically determine, from among the plurality of cells determined to be header cells, at least one column header cell and at least one row header cell associated with the respective content cell;
- and
- automatically generate an output table based on a result of the determining of the corresponding at least one column header cell and the corresponding at least one row header cell associated with each respective content cell.
Dependencies are inferred from the claim text.