flâneur

Assignment 3: Merging Spreadsheets (CS 2110 Fall 2024)

courses.cis.cornell.edu · 4,566 words · saved by 1 readers

Everywhere you look, data are organized into tables. In sports, tables are used to summarize athletes’ performance: rows correspond to players, and columns correspond to “stats” such as shots, penalties, and goals. In finance, bank statements are tables of transactions, each showing a debit/credit amount and the account’s remaining balance. In science labs, you might write down tables of measurements taken during an experiment. Sometimes it would be useful to combine information that is spread across multiple tables. To take an example from economics, if we had a spreadsheet listing the Gross Domestic Product (GDP) of all 50 US states, and another spreadsheet containing median income of the residents of those states, it would be useful if we could easily generate a single spreadsheet containing both kinds of information for each state—whether or not the two tables list the states in the same order. Spreadsheet programs like Microsoft Excel are used to accomplish that kind of table merg

Assignment 3: Merging Spreadsheets (CS 2110 Fall 2024) Assignment 3: Merging Spreadsheets Everywhere you look, data are organized into tables . In sports, tables are used to summarize athletes’ performance : rows correspond to players, and columns correspond to “stats” such as shots, penalties, and goals. In finance, bank statements are tables of transactions, each showing a debit/credit amount and the account’s remaining balance. In science labs, you might write down tables of measurements taken during an experiment. Sometimes it would be useful to combine information that is spread across mu

related reading