Stata: Reshaping Data using World Bank Open Data Sets

[@davidzhang5306]

It is really of great help to my graduation thesis, finally getting to a start. Thanks a lot!

[@anesubangani2244]

I swear this video helped me. Thank you. Nice and straightforward

[@eswatinimyhome6859]

Can I just say I have been stuck on this and you just helped . honestly thank you.

[@cassiewright5481]

Thank you very much for this insightful and extremely helpful video! Doing God's work truly!

[@rachelmaya8757]

you are an absolute legend, thank you so much for this!

[@hasanieltsbangla]

Sir, amazing ...gratitude

[@ritubhatt3092]

In my dataset, there's no data from 1960 to 1988 in the same world bank co2 dataset. How's that possible?

[@annablinova6208]

Exactly what I needed to do! Thanks a lot!

[@NaokoToda-cf2ec]

This video helped me so much! Thank you.

[@MuhammadAsif-ci8yy]

Good job sir. Thanks 👍

[@USAmedu-wz5op]

Thanks for this. What if the date should be monthly? For instance, I am looking for a way to convert a j=4 to 29Jan1986.

[@kevinreyesmessi10]

Thank you so much. Clutch af.

[@monkynutss711]

Thank you!

[@petraszepesi106]

How would we go about this same issue if we had multiple variables of interest? (Hence our data would already be wide and long) Thank you for any advice!

[@toddr.yarbroughph.d.478]

Hmmm, you may be able to use multiple stubs? I can try this later to see. Otherwise I may just extract into separate data sets. I’m sure there is a more efficient way, but when in doubt I just divide and conquer!

[@lubin509]

hi Petra, were you able to figure this out? I am in a similar situation whith a lot of variables and your experience might save me a lot of time. Thanks.

[@noahk5959]

@@lubin509 Hi were you able to find a solution?

[@romniyepez5206]

Thank Todd, nice vid! How would I be able deal with quarters instead years? Thanks in advance...

[@toddr.yarbroughph.d.478]

It really shouldn't be any different. Just treat each column (wide form) as a "time period." It doesn't matter if its annual or quarterly or daily even.

[@scholarlyanalyst7700]

@@toddr.yarbroughph.d.478 Question. I have limited knowledge of computers. I can do quite a bit in Excel. I can do QuickBooks. But I really don't have much experience beyond that. How long would it take me to independently become proficient in Stata?

[@bazejmakowski2613]

Thank you

[@vladimiri555]

Great! Thanks a lot!

[@georgepaily3276]

could you share the next part of this video ? it helps a lot .. thanks a lot

[@toddr.yarbroughph.d.478]

What particularly did you have in mind?

[@mariagulzar1778]

how do you do the opposite? because I want to calculate averages for each year but my data looks like what you have at the end result.

[@toddr.yarbroughph.d.478]

try: reshape wide var, i(panelvar) j(timevar) OR you can also just use a collapse command to get average for years. Be sure to save data set first though, as collapse changes it. collapse (mean) varname, by(timevar)

[@madhumitachaudhary6270]

Is there a way we can do this using python or excel power query?

[@toddr.yarbroughph.d.478]

See link. In my few forays into Python I've found this very useful: www.danielmsullivan.com/pages/tutorial_stata_to_python.html

[@neelamkhan7896]

I need bank loans data guide me plz

[@toddr.yarbroughph.d.478]

Where/when?