I have an excel data set in the format having first Column as Date, and following Columns have daily returns of different companies number around 500 to 600. Each column is labelled with individual company name. The worksheet contains one year of daily returns data. I want to transform this data set into cross sectional format showing first column for Company Name, Second for Date and Third for Returns.
Kindly guide about the code.
Related Posts with Changing structure of Data set
Is it possible to "zoom in" a region of a map using grmap?Dear all, I am plotting age-standardised incidence rates of a certain health condition onto a map o…
Interpretation of marginal effects in churdle model with a log-transformed dependent variableHey, I run a double hurdle model (more specifically, the 'churdle' command) and use a probit model …
Is there any method to statistically compare the coefficients in 2 tobit model ?Hello, I'm Dahye Yim. I need some helps to interpret the coefficients in 2 Tobit models. model 1 :…
loop between dates variables long formatHow to make a loop between the variable date2 and date1 to check if there is a difference of more th…
Calculating average years of education across different occupation codesHello everyone, I have a question that I hope you guys can help me. Below is an example of a panel …
Subscribe to:
Post Comments (Atom)
0 Response to Changing structure of Data set
Post a Comment