Daily log

[SawyerMcFarland]

10/25

• I updated our wiki, adding literature review and data.

• Arya is updating it with the casual diagram and hypothesis.

• As a group we need to:

• [x] 1. Create a Stata do-file on one of our data sets. -Arya

• [x] 2. Narrow down our hypothesis.- Sawyer

• [x] 3. Testability of hypothesis. -Logan

[kbuzard]

@ecn310/international-trade-policy If you want to highlight tasks, you can use the "task list" feature. For example,

• [x] Task 1
• [x] Task 2

They can then be checked off when they're completed.

[aryar5]

10/31/2023

1. Sawyer revised our hypothesis, made it more concise and focused on volume of exports.
2. Logan narrowed down our variable for hypothesis testing, we will focus on the volume of trade
3. Arya opened a Stata do file for the data.

[kbuzard]

@ecn310/international-trade-policy Here is my feedback on your documentation:

1. The structure of the master documentation on the wiki looks good, and everything is there that I was hoping for
2. I don't see any do-file in your repo. I see the task for it, and it's checked off, but I don't see the do-file.
3. There isn't any substance to any of the task issues. I didn't mean for this to be a complicated way of making to-do lists, but rather to be a place where you keep track of all the work related to each task and communicate about it. I'm not sure we learn much from what you have on these issues so far.
4. There aren't any posts to this daily log about what you did in class yesterday, either on your data or on your documentation.

[aryar5]

11/1/2023

• Worked on descriptive statistics
• Tried it with 2 variables on our us_h6 dataset
• Need to upload more data

[aryar5]

11/3/2023

• Sawyer revised our Wiki before class, because the task list was not very comprehensive and had no detail
• Arya and Logan worked on descriptive statistics
• Logan is attempting to see if we could use R for all our data- not confirmed but it is an idea
• Still need more data in the one drive

[SawyerMcFarland]

11/08/2023

• Look at OEC data for more specific 'value' data between countries at different year, for example before tariffs and after.
• Logan, Arya and Sawyer completed Descriptive Statistics Exercises with different data sets looking at the "value" variable.
• Arya uploaded US International Trade in Goods and Services data from OECD
• Logan uploaded R version of the data.

[lefaulk]

11/10/2023

• Completed project needs assignment.
• Looked at excel data, got a better idea of what data we need and what data we can use.
• We need to figure out it if it's better to narrow down products or to just look at exports as a whole. @kbuzard
• I manipulated some of the excel files (not the data itself) so that it could work and be imported into R. I will comment about this on the Wiki.

[aryar5]

11/12/2023

Project Assignment Review

• Reviewed the recently completed descriptive statistics exercise and assessed the next steps for the assignment.

  Data Exploration

• Logan examined Excel data to gain a clearer understanding of necessary and usable data. Noted potential areas for improvement.
• Sawyer engaged in a discussion with Professor Buzard about whether it's more effective to narrow down products or analyze exports as a whole. Discussed potential approaches and considerations.
  • Made adjustments to some Excel files (structure, not data) to enhance compatibility for importing into R. Documented changes for reference, to be included in the project Wiki.
  • Arya investigated OEC data to identify specific 'value' data between countries at different years, particularly focusing on periods before and after tariffs.

    Descriptive Statistics Exercises

• Logan, Arya, and Sawyer- completing Descriptive Statistics Exercises using different data sets. Analyzed the "value" variable for insights.

  Data Uploads

• Arya uploaded US International Trade in Goods and Services data from OECD for team reference.
• Logan uploaded the R version of the data, ensuring accessibility and compatibility for further analysis.

  Next Steps:

• Coordinate with the team to integrate individual findings and insights.
• Further explore specific 'value' data in OEC for comprehensive analysis.
• Discuss and plan the next stages of the project.

  Challenges:

• None significant. Coordination with team members was effective.

  Notes

• Documentation of Excel file changes is available on the project Wiki for transparency and future reference.
• Team collaboration proved beneficial for diverse insights and skill sets.

[aryar5]

Arya uploaded data on "Trade in goods: Exports, Percentage change, previous period, Q1 2008 – Q3 2023" extracted from OECD. Located in One Drive on 11/15/2023

[SawyerMcFarland]

We need to:

• [ ] get data on Chinese exports to US --HS6 code for each product (prior to Tariffs and after Tariffs)

• [ ] Then same product level HS6 exports from EU to US (prior to Tariffs and after Tariffs)

• [x] US Tariff changes on Chinese products --@kbuzard will send us this.

Find products China previously exported to US. and the same products that the EU then exports to US after Tariffs.

[aryar5]

17th November'23

• Worked on creating a LaTeX Editor Overleaf for our project
• Going to start compiling the Lit Review and insert it- Arya
• Will start data analysis to test the hypothesis.

[kbuzard]

@ecn310/international-trade-policy I'm sorry for the delay in getting you feedback on your documentation and project process. Here are my thoughts:

1. On your post above ("We need to")
   • You don't mean to be linking to #1, #2, and #3, right? Github takes the #-number syntax to be citing that number issue/discussion/etc. Using numbered lists is a lot better. I'm going to ignore those links unless you tell me otherwise.
   • Please make a separate issue for each task, and keep all the details about each task on those issue threads (like this one: #8 -- see what I did there?!?! I only typed #8 and Github automatically makes a fancy link. Note: I'm wrapping the # sign stuff in backticks to prevent it from inserting the link when I want to describe to you what's going on)
   • I linked to where I think you should start looking for the data on U.S. tariff increases on Chinese imports in #8 ; I don't think it has all the detail, but if you go to their paper that's cited on that page (search of "Journal of Policy Modeling") and figure out where they describe their data, my guess is it will lead you to the right place. If it doesn't, let me know and I'll look somewhere else.
2. On your 11/12 post, I still don't see the documentation for "Made adjustments to some Excel files (structure, not data) to enhance compatibility for importing into R. Documented changes for reference, to be included in the project Wiki." Am I missing it, or is it not there yet?
   • I see a line that says "Logan uploaded the R version of the data, ensuring accessibility and compatibility for further analysis." Is this what you're referring to? That's a good summary entry for the wiki, but where are the details about what was actually done? See next point that explains something similar in more detail.
3. The 11/12 post says "Arya uploaded US International Trade in Goods and Services data from OECD for team reference" and "Logan uploaded the R version of the data, ensuring accessibility and compatibility for further analysis." Where is your documentation that says where this data came from, when it was downloaded, where specifically (with file name) it was saved? You have a lot of files in the OneDrive folder, but nothing I can find easily that says what the files mean. There should be something on the wiki that explains what each file in the folder means (it can be a link to something else--another wiki page, a discussion, issue, a text file in the OneDrive folder--there are lots of options for how to do this)
   • Except for the US H6 data, all these files are small enough to be put on Github, and you could then explain the files in the main readme for the repo.
   • You have two choices for how to keep your files
     1. Put them on Github with good commit messages that explain what they are (and that list described above)
     2. Keep them in OneDrive and keep VERY detailed documentation about every change that is made to them. Github keeps that kind of documentation in the commit messages and using the "diffs" where you can see the changes due to each commit. You have to do this by hand if you're not using Github.
4. If you started something on Overleaf, it should be added to the wiki
5. You have a pretty complicated project in terms of the data needs. I'm happy to help you figure out how to manage all of it, but your documentation will have to be clearer for me to be able to help.
   • There is no documentation check this coming Saturday because of the break. However, I think you need to get these issues cleared up before we get back from break so that I can help you make progress toward the final report. I'm going to give you a 1 out of 2 for the documentation check score for this past week. I will change that to a 2 if you address these issues (and notify me!) by this coming Saturday.
6. You REALLY need to have all three pieces of the data ready for merging and analysis before our first class back from break next Wednesday. Please let me know if you need any help with this by tagging me on an issue in Github.

[aryar5]

@kbuzard Hello Professor Buzard, I hope you had a good Thanksgiving Break. I have added a section to our wiki titled 'Data' which has detailed explanations about each dataset. I have uploaded the small files to our GitHub main repo as well. We have chosen our 3 datasets to merge but we will need help to do so this Wednesday. Please ket me know if the data in the Wiki is sufficient, Thank you so much.

[kbuzard]

I have added a section to our wiki titled 'Data' which has detailed explanations about each dataset.

@aryar5 The ones listed on the wiki don't seem to be product-level data. Which are the three datasets that you're planning to merge? I'd like to take a look at them to make sure it looks like it's going to work.

I have uploaded the small files to our GitHub main repo as well

I don't see any data files in the repo. Where did you put the files?

[SawyerMcFarland]

11/27

• Our group met over zoom to discuss our data and how we would like to approach finishing our research project. Arya created a google doc and shared it with me and Logan so that we can write in it and she can upload it to the latex document(the latex document will not allow me nor Logan to access it).

[aryar5]

12/1/23

• Have 2 datasets for merging, finalizing the 3rd. Professor Buzard gave us data on EU-US Trade, we need to finalize the data set for China-US from WITS.
• All located on One Drive
• Need to draft the Analysis section on LaTeX, Logan and Arya have access to the document.
• Need to put it on the GitHub repo
• By December 6th, we need to have a presentation ready talking about our hypothesis.

[kbuzard]

@ecn310/international-trade-policy This is a good post from yesterday, but there's no post from Wednesday. In particular, there's nothing that says where to find the plan you made on Wednesday. There's also no record of Arya's visit to office hours on Wednesday, or anything else that anyone might have done outside of class.

• I went looking for the plan and found it as a separate page on your wiki. It's fine to keep it like that, but please add a link to the main page. You'll also have to update the plan as you go along and get things done, and if deadlines need to change.
  • I reorganized your wiki so that your main page with the summary is at the top and therefore is what shows up when you click on "wiki" at the top of the page. Bottom line: It has to be called "Home".
• You don't have any connection between your wiki and your task documentation. You don't need a link to each task on the wiki, but you should have an entry that tells how you're doing your task documentation (that is, using issues) and then a link to the issues page.
• There are a lot of outstanding tasks on the plan; they should be converted into task issues (maybe not a separate issue for each one; there may be ways to group them together that make sense and prevent an overwhelming number of open issues).
  • For instance, you have the presentation coming up in less than a week. There should be a an issue for that task that says who's responsible for it, what the plan is for getting it pulled together, where the presentation file lives, etc.

[aryar5]

11/29/2023- Wed

• Arya went to Professor Buzzard's office hours, asked for help getting product level data
• Professor Buzard searched and gave data for US-EU trade, product level, using this to merge with our other data set
• Sawyer, Logan and Arya made a detailed plan on steps to complete the project ahead of the deadline
• Arya gave team members overview of document on LaTeX

[aryar5]

@ecn310/international-trade-policy @kbuzard

• I fixed the daily log, I forgot to post it but this our log from Wednesday the 29th of November
• Thank you for reorganizing our Wiki! I added the plan in the Issues page as well, I created a new Issue called 'Plan for Final Project'
• Fixed the task list and updated it with what we need to do, also in Issues, checked off all the completed tasks.

[kbuzard]

@aryar5 I suggest you only have one copy of the plan on your repo; it can be in the issue you just created or on the wiki. The key thing I was asking for is that you add a link to that plan (whichever one you want to keep) on the top wiki page.

Thanks for adding the log from Wednesday!

[aryar5]

Thank you Professor! Would it be possible to have our documentation check grade revised?

---

From: Kristy Buzard @.> Sent: 02 December 2023 04:54 PM To: ecn310/course-project-international-trade-policy @.> Cc: Arya Rajesh @.>; Mention @.> Subject: Re: [ecn310/course-project-international-trade-policy] Daily log (Issue #4)

@aryar5https://github.com/aryar5 I suggest you only have one copy of the plan on your repo; it can be in the issue you just created or on the wiki. The key thing I was asking for is that you add a link to that plan (whichever one you want to keep) on the top wiki page.

Thanks for adding the log from Wednesday!

— Reply to this email directly, view it on GitHubhttps://github.com/ecn310/course-project-international-trade-policy/issues/4#issuecomment-1837263192, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCIDRFXSBXRL37SBMXWV3D3YHOPSDAVCNFSM6AAAAAA6P3RN72VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZXGI3DGMJZGI. You are receiving this because you were mentioned.Message ID: @.***>

[kbuzard]

Yes, I will revise it once you've decided which copy of the plan to keep, deleted the one one, and added a link to remaining plan on the main wiki page (the one under "home").

[aryar5]

All done! https://github.com/ecn310/course-project-international-trade-policy/issues/10 this is the link, we decided to keep the one on Issues

---

From: Kristy Buzard @.> Sent: 02 December 2023 06:59 PM To: ecn310/course-project-international-trade-policy @.> Cc: Arya Rajesh @.>; Mention @.> Subject: Re: [ecn310/course-project-international-trade-policy] Daily log (Issue #4)

Yes, I will revise it once you've decided which copy of the plan to keep, deleted the one one, and added a link to remaining plan on the main wiki page (the one under "home").

— Reply to this email directly, view it on GitHubhttps://github.com/ecn310/course-project-international-trade-policy/issues/4#issuecomment-1837284400, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCIDRFUHY4HHI3EWBI7WCZTYHO6FXAVCNFSM6AAAAAA6P3RN72VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZXGI4DINBQGA. You are receiving this because you were mentioned.Message ID: @.***>

[kbuzard]

All done! #10 this is the link, we decided to keep the one on Issues

Great! Now the link needs to be added to the main wiki page, that is, (here)

[aryar5]

Thank you professor, could you check our wiki and let me know if you can see the link? I put it in there.

---

From: Kristy Buzard @.> Sent: 02 December 2023 07:41 PM To: ecn310/course-project-international-trade-policy @.> Cc: Arya Rajesh @.>; Mention @.> Subject: Re: [ecn310/course-project-international-trade-policy] Daily log (Issue #4)

All done! #10https://github.com/ecn310/course-project-international-trade-policy/issues/10 this is the link, we decided to keep the one on Issues

Great! Now the link needs to be added to the main wiki page, that is, (herehttps://github.com/ecn310/course-project-international-trade-policy/wiki)

— Reply to this email directly, view it on GitHubhttps://github.com/ecn310/course-project-international-trade-policy/issues/4#issuecomment-1837293838, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BCIDRFVLLSYXGTN4TAH3O4DYHPDB3AVCNFSM6AAAAAA6P3RN72VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZXGI4TGOBTHA. You are receiving this because you were mentioned.Message ID: @.***>

[SawyerMcFarland]

12/04

Today we met in Bird library and discussed which exported products we wanted to focus on; Food, Capital goods and textiles. We have made 3/6 graphs and are finishing up analysis, orignally we had wanted to have this done by yesterday however we are on our way and allowed enough flexibility in our planner to still get this in on time for presentations on Wednesday.

[aryar5]

12/04

Started our data testing and here are some of the results

• Examining trade data on food, capital goods, and textiles- these sectors represent major components of global trade between the United States and the rest of the world.
• The post-2018 decrease in trade shows tariff implementation. The US-China dataset shows a decline, while the US-EU dataset reveals an increase.
• We selected these datasets because they help us understand a broader shift in trends. Despite focusing on different sectors, they all point towards similar changes, emphasizing the interconnected impact of tariffs on international commerce.

[kbuzard]

Thank you professor, could you check our wiki and let me know if you can see the link?

Yes, I see it. It looks great.

To streamline things, you could also move the Overleaf link from it's own wiki page to be on this main wiki page.

[aryar5]

Logan provided some code for R to get figures from Data

install.packages('ggplot2') library(ggplot2) install.packages('dplyr') library(dplyr) install.packages('tidyverse') library(tidyverse) df<- read.csv('United States Product Imports from China.csv')

Filter the data according to the given conditions

clothing

filtered_df3 <- df %>% filter(Reporter.Name == "United States", Partner.Name == "China", Product.Group == " Capital goods")

Textiles

filtered_df4 <- df %>% filter(Reporter.Name == "United States", Partner.Name == "China", Product.Group == "Textiles and Clothing")

Select the time range from 2017 to 2021

capital goods

time_range_df2 <- filtered_df2 %>%

select(X2017:X2021)

textiles

time_range_df2 <- filtered_df3 %>% select(X2017:X2021)

Convert the data from wide to long format for plotting

long_df2 <- pivot_longer(time_range_df2, cols = X2017:X2021, names_to = "Year", values_to = "Value")

textiles

long_df2 <- pivot_longer(time_range_df2, cols = X2017:X2021, names_to = "Year", values_to = "Value")

Adjust the Year variable to be a simple year format (e.g., 2017)

long_df2$Year <- sub("x", "", long_df$Year)

Create the visual comparison

ggplot(long_df2, aes(x = Year, y = Value, group = 1)) + geom_line() + geom_point() + labs(title = "Textile Volume United States and China (2017-2021)", x = "Year", y = "Trade Volume") + theme_minimal()

library(ggplot2) library(dplyr)

df2 <- read.csv('data-17844025.csv')

Filter the data according to the given conditions

food

filtered_df2 <- df2 %>% filter(REPORTER_LAB == 'European Union - 27 countries (AT, BE, BG, CY, CZ, DE, DK, EE, ES, FI, FR, GR, HR, HU, IE, IT, LT, LU, LV, MT, NL, PL, PT, RO, SE, SI, SK)', PARTNER == 'US', PRODUCT_LAB == 'Hams, shoulders and cuts thereof of swine, salted, in brine, dried or smoked, with bone in', PERIOD_LAB %in% c('Jan.-Dec. 2017', 'Jan.-Dec. 2018', 'Jan.-Dec. 2019', 'Jan.-Dec. 2020', 'Jan.-Dec. 2021'))

Create the visual

ggplot(filtered_df2, aes(x = PERIOD_LAB, y = INDICATOR_VALUE, group = 1)) + geom_line() + geom_point() + labs(title = "Indicator Value Over Time", x = "PERIOD", y = "TRADE VOLUME") + theme_minimal()

Batteries

filtered_df2 <- df2 %>% filter(REPORTER_LAB == 'European Union - 27 countries (AT, BE, BG, CY, CZ, DE, DK, EE, ES, FI, FR, GR, HR, HU, IE, IT, LT, LU, LV, MT, NL, PL, PT, RO, SE, SI, SK)', PARTNER == 'US', PRODUCT_LAB == '', PERIOD_LAB %in% c('Jan.-Dec. 2017', 'Jan.-Dec. 2018', 'Jan.-Dec. 2019', 'Jan.-Dec. 2020', 'Jan.-Dec. 2021'))

Create the visual

ggplot(filtered_df2, aes(x = PERIOD_LAB, y = INDICATOR_VALUE, group = 1)) + geom_line() + geom_point() + labs(title = "Indicator Value Over Time", x = "PERIOD", y = "TRADE VOLUME") + theme_minimal()

The R code performs a series of operations on our two datasets. Firstly, it imports and filters data from the 'United States Product Imports from China.csv' file, focusing on two product groups: "Capital goods" and "Textiles and Clothing," specifically examining trade between the United States and China. The time range from 2017 to 2021 for the "Textiles and Clothing" group is then selected, and the data is reshaped from wide to long format using the pivot_longer function. Subsequently, a line plot is generated using ggplot2 to visualize the trade volume over the years (2017-2021) for the "Textiles and Clothing" category. Moving on to another dataset ('data-17844025.csv'), the code filters information related to two distinct product categories: "Hams, shoulders, and cuts thereof of swine" (Food) and (Batteries). Two identical sets of code create line plots for trade volume over time using ggplot2 for both the "Hams, shoulders, and cuts thereof of swine" and the Batteries category.

[aryar5]

12/08

• worked on documentation, should be done by 9pm today
• will data store it on GitHub
• Arya worked on analysis section
• need more specific data, descriptive statistics so we will generate that for our datasets
• instructions for documentation @kbuzard could you help us make our repo public?
• You can put your documentation plan wherever it makes sense for your team; just tell me where it is
• List all the pieces that your project requires in a plan that says where each piece will be stored and how each piece will relate to the whole
• Github? OneDrive?
• Can it all go in a data appendix? Do you need several
• documents? Are all the files in one folder, or many?
• Create a timeline of the tasks required to get the documentation / data / replication package completed

[kbuzard]

@ecn310/international-trade-policy

1. I've just made your repo public
2. I think your documentation is going well.
3. The r code above seems like it compares "apples to oranges" in that the US-China data is really aggregated, and the US-EU data is very disaggregated. Make sure that if you're pairing these two types of data that what you're showing is at the same level of detail; otherwise, it doesn't tell us much.

[aryar5]

12/12/2023

• Sawyer, Arya and Logan worked on creating report
• We need to push it on to LaTeX
• Need to create a README
• All our work is on google docs and GitHub, need to structure it

[SawyerMcFarland]

12/13

• This morning we finalized our conclusion, abstract and introduction.
• We are currently finishing our documentation to send to Dylan.
• Our report is near complete, will hopefully have our first draft in by tonight.

[SawyerMcFarland]

12/16

Arya and I met over zoom and made a plan for what to get done by today. Logan will contact Dylan to fix aggregate. Dylan looked over our documentation.

[SawyerMcFarland]

1218

• we met over zoom and went over Dylan's feedback on documentation correcting the mistakes. We are currently polishing the final draft of the project and documentation for submission tomorrow.