第2回：データの加工・整理

Size: px

Start display at page:

Download "第2回：データの加工・整理"

そよながだき
7 years ago
Views:

1 / 24

2 1. 2. Excel 3. Stata 4. Stata 5. Stata 2 / 24

3 1 cross section data e.g., time series data e.g., panel data e.g., / 24

4 micro data aggregate data 4 / 24

5 / 24

6 Excel Stata 13 6 / 24

7 Excel A B C D E 1 prefecture income expenditure male female 2 Hokkaido 227, , Aomori 233, , Okinawa 214, , Hokkaido 207, , Aomori 169, , Okinawa 144, , / 24

8 1 1. Excel consumption2009.xlsx 2018microdata1 2. A1 prefecture B1 income C1 expenditure D1 male E1 female 3. b134-2.xls B134-2 P11 BJ11 4. consumption2009.xlsx A2 8 / 24

9 5. consumption2009.xlsx A 2 Hokkaido, Aomori, Iwate, Miyagi, Akita, Yamagata, Fukushima, Ibaraki, Tochigi, Gumma, Saitama, Chiba, Tokyo, Kanagawa, Niigata, Toyama, Ishikawa, Fukui, Yamanashi, Nagano, Gifu, Shizuoka, Aichi, Mie, Shiga, Kyoto, Osaka, Hyogo, Nara, Wakayama, Tottori, Shimane, Okayama, Hiroshima, Yamaguchi, Tokushima, Kagawa, Ehime, Kochi, Fukuoka, Saga, Nagasaki, Kumamoto, Oita, Miyazaki, Kagoshima, Okinawa 6. consumption2009.xlsx A2 A48 A49 9 / 24

10 7. b134-2.xls B134-2 P37 BJ37 8. consumption2009.xlsx B2 9. b134-2.xls B134-2 P39 BJ consumption2009.xlsx C2 11. consumption2009.xlsx D2 D consumption2009.xlsx E2 E / 24

11 13. b134-2.xls B134-2 (2) P37 BJ consumption2009.xlsx B b134-2.xls B134-2 (2) P39 BJ consumption2009.xlsx C consumption2009.xlsx D49 D consumption2009.xlsx E49 E / 24

12 19. consumption2009.xlsx B17 C17 - missing value - Stata 20. consumption2009.xlsx 12 / 24

13 1 0 dummy variable male female 2 male 1 0 female / 24

14 Stata Stata Excel Ver. 13 xls xlsx 14 / 24

15 Stata Word 1 Stata 15 / 24

16 2 1. Stata File Log Begin microdata1 lecture smcl 3. File Import Excel spreadsheet (*.xls; *.xlsx) 4. Excel file: Browse microdata1 consumption2009.xlsx 6. Import first row as variable names OK 16 / 24

17 7. File Save as 2018microdata1 consumption2009.dta 8. Command list prefecture income expenditure male female Enter list more 17 / 24

18 Command generate ( )=( ) generate Data Create or change data Create new variable Variable name: Specify a value or an expression Specify a value or an expression Create / 24

19 income expenditure 1, / 24

20 3 1. Command generate income_th=income/1000 Enter 2. Command generate expenditure_th =expenditure/1000 Enter 3. Command list prefecture income income_th expenditure expenditure_th male female Enter list 20 / 24

21 Command summarize ( ) Enter number of observations (mean) (standard deviation) (minimum) (maximum) 21 / 24

22 Obs: n. Mean: x = 1 n x i. n i=1 Std. Dev.: 1 n sx = (x i x) 2. n 1 Min: min{xi }. Max: max{x i }. i=1 22 / 24

23 4 1. Command summarize income income_th expenditure expenditure_th male female Enter list 2. Edit Copy 3. Word summary docx 2018microdata1 23 / 24

24 5 Stata 1. File Log Close 2. Stata microdata1 lecture smcl 24 / 24

100sen_Eng_h1_4

100sen_Eng_h1_4 Sapporo 1 Hakodate Japan 5 2 3 Kanazawa 15 7 Sendai Kyoto Kobe 17 16 10 9 18 20 Hiroshima 11 8 32 31 21 28 26 19 Fukuoka 33 25 13 35 34 23 22 14 12 40 37 27 24 29 41 38 Tokyo 36 42 44 39 30 Nagoya Shizuoka