Topological data analysis utilizing spreadsheets

A non-transitory computer readable medium comprising instructions executable by a processor to perform a method, the method comprising:

• receiving data points from a spreadsheet;
• receiving a lens function identifier, a metric function identifier, and a resolution function identifier;
• mapping the data points from the spreadsheet to a reference space utilizing a lens function identified by the lens function identifier;
• generating a cover of the reference space using a resolution function identified by the resolution identifier;
• clustering the data points mapped to the reference space using the cover and a metric function identified by the metric function identifier to determine each node of a plurality of nodes of a graph, each node including at least one data point from the spreadsheet;
• generating a visualization depicting the nodes, the visualization including an edge between every two nodes that share at least one data point from the spreadsheet as a member;
• generating a translation data structure indicating location of the data points in the spreadsheet as well as membership of each node in the visualization;
• detecting a selection of at least one node in the visualization;
• determining the location of a first set of data points in the spreadsheet corresponding to one or more data points that are members of the at least one node selected in the visualization using the translation data structure;
• and
• providing a first command to a spreadsheet application interacting with the spreadsheet to provide a first visual identification of each of the first set of data points in the spreadsheet that correspond to the one or more data points that are members of the at least one node selected in the visualization.

A system comprising:

• one or more processors;
• and
• memory containing instructions executable by at least one of the one or more processors to:
• receive data points from a spreadsheet;
• receive a lens function identifier, a metric function identifier, and a resolution function identifier;
• map the data points from the spreadsheet to a reference space utilizing a lens function identified by the lens function identifier;
• generate a cover of the reference space using a resolution function identified by the resolution identifier;
• cluster the data points mapped to the reference space using the cover and a metric function identified by the metric function identifier to determine each node of a plurality of nodes of a graph, each node including at least one data point from the spreadsheet;
• generate a visualization depicting the nodes, the visualization including an edge between every two nodes that share at least one data point from the spreadsheet as a member;
• generate a translation data structure indicating location of the data points in the spreadsheet as well as membership of each node in the visualization;
• detect a selection of at least one node in the visualization;
• determine the location of a first set of data points in the spreadsheet corresponding to one or more data points that are members of the at least one node selected in the visualization using the translation data structure;
• and
• provide a first command to a spreadsheet application interacting with the spreadsheet to provide a first visual identification of each of the first set of data points in the spreadsheet that correspond to the one or more data points that are members of the at least one node selected in the visualization.