The NSF file format contains results from the NSF (National Science Foundation) Award Database, which contains information on grants given out by the NSF, including how much money was awarded, and who are the beneficiaries of the grants.
To get NSF award data, perform a query on The NSF Award Database, download the CSV format by clicking the csv icon in the "Export Options" box at the bottom of the screen, and rename the extension to ".nsf". (Due to unusual issues with the NSF csv format, it is not possible to read in the raw .csv file.)
Basic statistics as well as the evolving co-PI networks as well as the geospatial coverage of certain research topics can be determined. To extract co-authorship (really co-investigatorship), choose the "All Investigators" column when utilizing the Extract Co-Occurrence Network from Table algorithm.
When an NSF csv file is read, the following actions are performed:
Convert NSF file into a table Marks NSF file as "pre-2014" or "current" depending on format of headers Handle duplicate columns Replace '\"' with '""' (more standard method of escaping quotes in csv files) Normalize CO-PI column (handle excessive spaces in names) If it is a "current" format NSF: Normalize dollar amounts (go from strings to floats) Else if it is a "pre-2014" format NSF: Normalize PI names (put it in "first name first" format with no comma Create "All Investigators" Column (merge CO-PI and Primary PI column)
"NSF" files are really comma-separated value files, but because they are horribly formatted, require special processing by Network Workbench. Thus, in order to get Network Workbench to treat them correctly, the extension must be changed to ".nsf".