Take the attached file with many worksheets and turn it into one sheet with data on each pair of countries by year
The database is attached. I want you to do the following:
Create a list of data that measures the total number of treaties signed/ratified between two countries for each year. For example, take the countries of Algeria and Argentina in 1964 for worksheet Chapter I-5a in the attached data. They would not receive a score on this worksheet for the years up to 1966. From 1966 to the end of the time horizon, they would be scored as a 2. This is because they both have signed the treaty by 1966 and Argentina had not signed the treaty previously even though Algeria had signed it in 1964-5. The score between Algeria and Albania would be 2 from 1964 ot the end of the time horizon.
Add this score up with the score for Algeria and Argentina for all of the other treaties in the worksheet for every year available. Do this for all possible pairs of countries for this data for all possible years.
This should create a dataset that is quite large. If it is in list form (what I require), then it should stretch out probably to 500,000,000 rows. I need the file to be saved as a csv format.
If this is not clear, please let me know.
Also, I would like you to send me the excel commands that you have used to create this dataset so that I can follow your steps to check for accuracy.