how to import csv with codebook

[Paula de Souza Leao Spinola]

I have a csv with data and another one with the variables label (cobebook). Is there a way that I can import both of them together so that I can match the variables with the labels?

csv1

 
location_id,location_name,iso3,level,year,the_total_mean,the_total_lower,the_total_upper,ghes_total_mean,ghes_total_lower,ghes_total_upper,ppp_total_mean,ppp_total_lower,ppp_total_upper,oop_total_mean,oop_total_lower,oop_total_upper,dah_total,the_per_cap_mean,the_per_cap_lower,the_per_cap_upper,ghes_per_cap_mean,ghes_per_cap_lower,ghes_per_cap_upper,ppp_per_cap_mean,ppp_per_cap_lower,ppp_per_cap_upper,oop_per_cap_mean,oop_per_cap_lower,oop_per_cap_upper,dah_per_cap,ghes_per_the_mean,ghes_per_the_lower,ghes_per_the_upper,ppp_per_the_mean,ppp_per_the_lower,ppp_per_the_upper,oop_per_the_mean,oop_per_the_lower,oop_per_the_upper,dah_per_the_mean,dah_per_the_lower,dah_per_the_upper,the_per_gdp_mean,the_per_gdp_lower,the_per_gdp_upper,ghes_per_gdp_mean,ghes_per_gdp_lower,ghes_per_gdp_upper,ppp_per_gdp_mean,ppp_per_gdp_lower,ppp_per_gdp_upper,oop_per_gdp_mean,oop_per_gdp_lower,oop_per_gdp_upper,dah_per_gdp

1,Global,,Global,1995,4110686032,4073836462,4146378932,2311089207,2285743010,2337814797,844106455,822953215,874686521,941156281,933412927,948301030,14334089,721,715,728,406,401,410,148,144,154,165,164,166,3,0.562,0.556,0.566,0.205,0.201,0.211,0.229,0.226,0.231,0.003,0.003,0.004,0.073,0.072,0.074,0.041,0.041,0.042,0.015,0.015,0.016,0.017,0.017,0.017,0.001

1,Global,,Global,1996,4268753756,4220298470,4319801828,2394766722,2361639177,2434130400,875583605,852826662,898700859,983558616,975842850,992947620,14844814,738,729,747,414,408,421,151,147,155,170,169,172,3,0.561,0.557,0.565,0.205,0.200,0.210,0.230,0.228,0.233,0.003,0.003,0.004,0.073,0.072,0.074,0.041,0.040,0.042,0.015,0.015,0.015,0.017,0.017,0.017,0.001

1,Global,,Global,1997,4438254321,4394444999,4478086307,2488117221,2456020059,2518671891,897233397,869837792,926609850,1037787854,1029589428,1047640931,15115849,756,749,763,424,419,429,153,148,158,177,175,179,3,0.561,0.556,0.565,0.202,0.197,0.208,0.234,0.231,0.236,0.003,0.003,0.003,0.073,0.072,0.074,0.041,0.040,0.041,0.015,0.014,0.015,0.017,0.017,0.017,0.001

1,Global,,Global,1998,4618768329,4574499676,4666357350,2567139422,2536631780,2598067659,936888953,909625359,964499103,1097162673,1088425664,1105192934,17577281,777,769,785,432,427,437,158,153,162,184,183,186,3,0.556,0.550,0.561,0.203,0.197,0.209,0.238,0.235,0.240,0.004,0.004,0.004,0.074,0.074,0.075,0.041,0.041,0.042,0.015,0.015,0.016,0.018,0.018,0.018,0.001

1,Global,,Global,1999,4814451214,4774962981,4853426527,2663824674,2634645152,2692655208,981937498,961050055,1007971320,1150055646,1141227336,1158486526,18633396,799,793,806,442,437,447,163,160,167,191,189,192,4,0.553,0.549,0.557,0.204,0.200,0.208,0.239,0.237,0.241,0.004,0.004,0.004,0.075,0.074,0.075,0.041,0.041,0.042,0.015,0.015,0.016,0.018,0.018,0.018,0.001

1,Global,,Global,2000,5047553007,4999160494,5087294058,2809933980,2767230970,2843203942,1016069667,986229098,1048633096,1201104579,1188774924,1214012676,20444781,827,819,834,460,453,466,167,162,172,197,195,199,4,0.557,0.552,0.561,0.201,0.197,0.206,0.238,0.235,0.241,0.004,0.004,0.004,0.075,0.074,0.075,0.042,0.041,0.042,0.015,0.015,0.016,0.018,0.018,0.018,0.001

1,Global,,Global,2001,5311826675,5252120711,5357866249,2962625260,2923502938,3002738614,1068037056,1039785543,1090610916,1258777344,1243752106,1272874609,22387015,860,850,867,480,473,486,173,168,177,204,201,206,4,0.558,0.554,0.562,0.201,0.197,0.205,0.237,0.234,0.240,0.004,0.004,0.004,0.077,0.076,0.078,0.043,0.042,0.044,0.015,0.015,0.016,0.018,0.018,0.018,0.001

csv2

 
File:,IHME_RETROSPECTIVE_FINANCING_1995_2015_Y2018M04D10,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Variable:,year,location_id,location_name,iso3,level,the_total_mean,the_total_lower,the_total_upper,ghes_total_mean,ghes_total_lower,ghes_total_upper,ppp_total_mean,ppp_total_lower,ppp_total_upper,oop_total_mean,oop_total_lower,oop_total_upper,dah_total,the_per_cap_mean,the_per_cap_lower,the_per_cap_upper,ghes_per_cap_mean,ghes_per_cap_lower,ghes_per_cap_upper,ppp_per_cap_mean,ppp_per_cap_lower,ppp_per_cap_upper,oop_per_cap_mean,oop_per_cap_lower,oop_per_cap_upper,dah_per_cap,ghes_per_the_mean,ghes_per_the_lower,ghes_per_the_upper,ppp_per_the_mean,ppp_per_the_lower,ppp_per_the_upper,oop_per_the_mean,oop_per_the_lower,oop_per_the_upper,dah_per_the_mean,dah_per_the_lower,dah_per_the_upper,the_per_gdp_mean,the_per_gdp_lower,the_per_gdp_upper,ghes_per_gdp_mean,ghes_per_gdp_lower,ghes_per_gdp_upper,ppp_per_gdp_mean,ppp_per_gdp_lower,ppp_per_gdp_upper,oop_per_gdp_mean,oop_per_gdp_lower,oop_per_gdp_upper,dah_per_gdp

Label:,Year,Location ID,Location Name,ISO 3-digit Code,Location Category,Total Health Spending (thousands of 2017 purchasing power parity adjusted US Dollars),"Total Health Spending, Lower UI (thousands of 2017 purchasing power parity adjusted US Dollars)","Total Health Spending, Upper UI (thousands of 2017 purchasing power parity adjusted US Dollars)",Government Spending (thousands of 2017 purchasing power parity adjusted US Dollars),"Government Spending, Lower UI (thousands of 2017 purchasing power parity adjusted US Dollars)","Government Spending, Upper UI (thousands of 2017 purchasing power parity adjusted US Dollars)",Prepaid Private Spending (thousands of 2017 purchasing power parity adjusted US Dollars),"Prepaid Private Spending, Lower UI (thousands of 2017 purchasing power parity adjusted US Dollars)","Prepaid Private Spending, Upper UI (thousands of 2017 purchasing power parity adjusted US Dollars)",Out-of-Pocket Spending (thousands of 2017 purchasing power parity adjusted US Dollars),"Out-of-Pocket Spending, Lower UI (thousands of 2017 purchasing power parity adjusted US Dollars)","Out-of-Pocket Spending, Upper UI (thousands of 2017 purchasing power parity adjusted US Dollars)",Development Assistance for Health (thousands of 2017 purchasing power parity adjusted US Dollars),Total Health Spending per Capita (2017 purchasing power parity adjusted US Dollars),"Total Health Spending per Capita, Lower UI (2017 purchasing power parity adjusted US Dollars)","Total Health Spending per Capita, Upper UI (2017 purchasing power parity adjusted US Dollars)",Government Spending per Capita (2017 purchasing power parity adjusted US Dollars),"Government Spending per Capita, Lower UI (2017 purchasing power parity adjusted US Dollars)","Government Spending per Capita, Upper UI (2017 purchasing power parity adjusted US Dollars)",Prepaid Private Spending per Capita (2017 purchasing power parity adjusted US Dollars),"Prepaid Private Spending per Capita, Lower UI (2017 purchasing power parity adjusted US Dollars)","Prepaid Private Spending per Capita, Upper UI (2017 purchasing power parity adjusted US Dollars)",Out-of-Pocket Spending per Capita (2017 purchasing power parity adjusted US Dollars),"Out-of-Pocket Spending per Capita, Lower UI (2017 purchasing power parity adjusted US Dollars)","Out-of-Pocket Spending per Capita, Upper UI (2017 purchasing power parity adjusted US Dollars)",Development Assistance for Health Spending per Capita (2017 purchasing power parity adjusted US Dollars),Government Spending per Total Health Spending,"Government Spending per Total Health Spending, Lower UI","Government Spending per Total Health Spending, Upper UI",Prepaid Private Spending per Total Health Spending,"Prepaid Private Spending per Total Health Spending, Lower UI","Prepaid Private Spending per Total Health Spending, Upper UI",Out-of-Pocket Spending per Total Health Spending,"Out-of-Pocket Spending per Total Health Spending, Lower UI","Out-of-Pocket Spending per Total Health Spending, Upper UI",Development Assistance for Health per Total Health Spending,"Development Assistance for Health per Total Health Spending, Lower UI","Development Assistance for Health per Total Health Spending, Upper UI",Total Health Spending per Gross Domestic Product,"Total Health Spending per Gross Domestic Product, Lower UI","Total Health Spending per Gross Domestic Product, Upper UI",Government Spending per Gross Domestic Product,"Government Spending per Gross Domestic Product, Lower UI","Government Spending per Gross Domestic Product, Upper UI",Prepaid Private Spending per Gross Domestic Product,"Prepaid Private Spending per Gross Domestic Product, Lower UI","Prepaid Private Spending per Gross Domestic Product, Upper UI",Out-of-Pocket Spending per Gross Domestic Product,"Out-of-Pocket Spending per Gross Domestic Product, Lower UI","Out-of-Pocket Spending per Gross Domestic Product, Upper UI",Development Assistance for Health per Gross Domestic Product

Value Coding:,1995,160,Afghanistan,AFG,Country,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,1996,43,Albania,ALB,GBD Super Regions,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,1997,139,Algeria,DZA,Global,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,1998,74,Andorra,AND,World Bank Income Groups,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,1999,168,Angola,AGO,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,