adamrossnelson/stataquickreference

A place to keep Stata code on quick reference.

stataquickreference's Issues

Add Stackbar To Basic Plotting

Will add stacked bar chart to basic plotting.

Examples here: http://www.talkstats.com/showthread.php/14977-Stacked-bar-charts-of-single-variables
And here: https://twitter.com/AdamRossNelson/status/808506523324448768

Or as generated by:

use http://www.stata-press.com/data/r15/nlsw88.dta
tab race, gen(raceind)
graph hbar (mean) raceind*, over(married) stack legend(order(1 "White" 2 "Black" 3 "No Data"))

Data Is Beautiful Scheme

A good place to look for guidance on schemes:

https://www.stata.com/meeting/12uk/vw_README.txt
http://www.stata.com/meeting/12uk/schemetalk.zip

Simple red and black styles:

http://tylervigen.com/spurious-correlations

With dark backgrounds:

http://tylervigen.com/page?new=TRUE

Also helpful will be help scheme entries and:

https://www.stata.com/meeting/portugal10/portugal10_rising.pdf

Add 'loop over var names' Stata to Pandas crosswalk

Some example code...

>>> vars
['yr2000', 'yr2001', 'yr2002', 'yr2003', 'yr2004', 'yr2005', 'yr2006', 'yr2007', 'yr2008', 'yr2009', 'yr2010', 'yr2011', 'yr2012', 'yr2013', 'yr2014', 'yr2015', 'yr2016', 'yr2017', 'yr2018', 'yr2019']
>>>

Also

>>> for i in range(2013,2019):
...    df_dict[i] = pd.read_stata('list_of_caids_numsub_{}.dta'.format(i))
...
>>> df_dict[2014].columns
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')

>>> for i in range(2013, 2019):
...    df_dict[i].columns
...
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')
Index(['ApplicantId', 'numSub', 'didSub', 'sessyr'], dtype='object')
>>> for i in range(2013, 2019):
...    df_dict[i].columns = [c if c == 'ApplicantId' else c + str(i) for c in df_dict[i].columns]
...
>>> for i in range(2013, 2019):
...    df_dict[i].columns
...
Index(['ApplicantId', 'numSub2013', 'didSub2013', 'sessyr2013'], dtype='object')
Index(['ApplicantId', 'numSub2014', 'didSub2014', 'sessyr2014'], dtype='object')
Index(['ApplicantId', 'numSub2015', 'didSub2015', 'sessyr2015'], dtype='object')
Index(['ApplicantId', 'numSub2016', 'didSub2016', 'sessyr2016'], dtype='object')
Index(['ApplicantId', 'numSub2017', 'didSub2017', 'sessyr2017'], dtype='object')
Index(['ApplicantId', 'numSub2018', 'didSub2018', 'sessyr2018'], dtype='object')
>>> df = df_dict[2013]
>>> for i in range(2014, 2019):
...    df = pd.merge(df, df_dict[i], how='outer')
...
>>> df.columns
Index(['ApplicantId', 'numSub2013', 'didSub2013', 'sessyr2013', 'numSub2014',
       'didSub2014', 'sessyr2014', 'numSub2015', 'didSub2015', 'sessyr2015',
       'numSub2016', 'didSub2016', 'sessyr2016', 'numSub2017', 'didSub2017',
       'sessyr2017', 'numSub2018', 'didSub2018', 'sessyr2018'],
      dtype='object')
>>>

Make facradar into package

Make facradar.do into ado package.

MacOS version for GetStataSchemes.do

This file needs a MacOS version.

Instead of copying files to "C:/ado/plus/s/..." the MaxOS file path would be "~/Library/Application Support/Stata/ado/s/..."

More guidance here:
https://www.stata.com/support/faqs/programming/personal-ado-directory/
Quick reference on finding library folder:
http://osxdaily.com/2011/07/22/access-user-library-folder-in-os-x-lion/