Elena-big-data - Revision history

Eosergi10 at 08:40, 8 December 2011

2011-12-08T08:40:15Z

← Older revision		Revision as of 08:40, 8 December 2011
Line 30:		Line 30:
	*Develop and document the model function you are exploring in the data		*Develop and document the model function you are exploring in the data
	*Develop a visualization to show the model/patterns in the data		*Develop a visualization to show the model/patterns in the data
			The full presentation can be viewwed here: http://prezi.com/1vstya3qtmwy/big-data-project/
	The following 3 graphs were used to recreate USA population profile (graps 1-3). From the first graph, it is visible that 10% of USA population are people born outside of US, 5 % of which obtained USA citizenship.The second shows where most of the immigrants come from, and the third - how many of those immigrants obtained USA citizenship.		The following 3 graphs were used to recreate USA population profile (graps 1-3). From the first graph, it is visible that 10% of USA population are people born outside of US, 5 % of which obtained USA citizenship.The second shows where most of the immigrants come from, and the third - how many of those immigrants obtained USA citizenship.
	[[File:pop_prof1.jpg\|200px\|thumb\|left\|graph 1]]		[[File:pop_prof1.jpg\|200px\|thumb\|left\|graph 1]]

Eosergi10 at 08:38, 8 December 2011

2011-12-08T08:38:28Z

← Older revision		Revision as of 08:38, 8 December 2011
Line 47:		Line 47:
	===== Results =====		===== Results =====
	Sometimes I got predictable and expected results from my visualisations, such that the percentage of Mexican immigrants exceeds any other in the USA, or that people have problems with finding jobs with a degree in arts and humanities. However, I was able to get sometimes even surprising for me information.		Sometimes I got predictable and expected results from my visualisations, such that the percentage of Mexican immigrants exceeds any other in the USA, or that people have problems with finding jobs with a degree in arts and humanities. However, I was able to get sometimes even surprising for me information.
	When comparing unemployment rate of different immigrantes in USA, I was able to see a particular pattern - the highest unemployment rate was related only to Latin American Countries, while European and Asian countries obtained quite low unemployment rate. It didn't depend on the size of the foreign population from that region in the US, since in the chart the countries were lined up by the exceeding immigration to US population. This graph made me think that I just visualised the concept of discrimination in USA. No other countries from another regions of the world showed the same pattern, and the differences between the unemployment rate ~~hugeky~~ varied, comparing to another range of countries.		When comparing unemployment rate of different immigrantes in USA, I was able to see a particular pattern - the highest unemployment rate was related only to Latin American Countries, while European and Asian countries obtained quite low unemployment rate. It didn't depend on the size of the foreign population from that region in the US, since in the chart the countries were lined up by the exceeding immigration to US population. This graph made me think that I just visualised the concept of discrimination in USA. No other countries from another regions of the world showed the same pattern, and the differences between the unemployment rate hugely varied, comparing to another range of countries.
	It was surprising for me to see from graph9, than overall number of women are seen to be involved in technical jobs and it ~~exceed~~ the percentage of men in that sphere enourmously. There are a lot of talks about the lack of women in science, and it was quite a discovery for me to see my results that brake the stereotypical opinion. Also, I was surprise to see that the number of men in agriculture exceeds the number of women, which I expected to be the opposite.		It was surprising for me to see from graph9, than overall number of women are seen to be involved in technical jobs and it exceeds the percentage of men in that sphere enourmously. There are a lot of talks about the lack of women in science, and it was quite a discovery for me to see my results that brake the stereotypical opinion. Also, I was surprise to see that the number of men in agriculture exceeds the number of women, which I expected to be the opposite.
	I never expected for Chinese to obtain such a small percentage of people who work in agriculture. Also, the fact that most of Chinese are involved in market,shop sales are in Hungary is very unpredictable. The chart also says, that the given results are the highest comparing to the rest of the countries. Does it mean that Hungary has better economical or social conditions for Chinese to have a high ration of involvement in that sphere, or perhaps this labour market doesn't have as much competition than anywhere in the world?		I never expected for Chinese to obtain such a small percentage of people who work in agriculture. Also, the fact that most of Chinese are involved in market,shop sales are in Hungary is very unpredictable. The chart also says, that the given results are the highest comparing to the rest of the countries. Does it mean that Hungary has better economical or social conditions for Chinese to have a high ration of involvement in that sphere, or, perhaps, this labour market doesn't have as much competition than anywhere else in the world?
	From graph5 I was able to see that most percent the immigrants in the US are involved in comouter/math science, managment and healthcare spheres. ~~The~~ graph ~~is helpful to know, for~~ example, if I am seeking to find a healthcare practitioner, I will receive most of the applications from Philippines citizens as foreigners.		From graph5 I was able to see that most percent of the immigrants in the US are involved in comouter/math science, managment and healthcare spheres. This graph can be used in everyday situations too. For example, if I am seeking to find a healthcare practitioner, I will know that I will receive most of the applications from Philippines citizens as foreigners.
	===== Tech Details =====		===== Tech Details =====
	* Node: as5		* Node: as5

Eosergi10 at 08:14, 8 December 2011

2011-12-08T08:14:28Z

← Older revision		Revision as of 08:14, 8 December 2011
Line 45:		Line 45:
	The last thing I compared was the number of males per particular occupation position vs population of women(graph9).		The last thing I compared was the number of males per particular occupation position vs population of women(graph9).
	[[File:Picture11.jpg\|200px\|thumb\|left\|graph 9]]		[[File:Picture11.jpg\|200px\|thumb\|left\|graph 9]]
			===== Results =====
			Sometimes I got predictable and expected results from my visualisations, such that the percentage of Mexican immigrants exceeds any other in the USA, or that people have problems with finding jobs with a degree in arts and humanities. However, I was able to get sometimes even surprising for me information.
			When comparing unemployment rate of different immigrantes in USA, I was able to see a particular pattern - the highest unemployment rate was related only to Latin American Countries, while European and Asian countries obtained quite low unemployment rate. It didn't depend on the size of the foreign population from that region in the US, since in the chart the countries were lined up by the exceeding immigration to US population. This graph made me think that I just visualised the concept of discrimination in USA. No other countries from another regions of the world showed the same pattern, and the differences between the unemployment rate hugeky varied, comparing to another range of countries.
			It was surprising for me to see from graph9, than overall number of women are seen to be involved in technical jobs and it exceed the percentage of men in that sphere enourmously. There are a lot of talks about the lack of women in science, and it was quite a discovery for me to see my results that brake the stereotypical opinion. Also, I was surprise to see that the number of men in agriculture exceeds the number of women, which I expected to be the opposite.
			I never expected for Chinese to obtain such a small percentage of people who work in agriculture. Also, the fact that most of Chinese are involved in market,shop sales are in Hungary is very unpredictable. The chart also says, that the given results are the highest comparing to the rest of the countries. Does it mean that Hungary has better economical or social conditions for Chinese to have a high ration of involvement in that sphere, or perhaps this labour market doesn't have as much competition than anywhere in the world?
			From graph5 I was able to see that most percent the immigrants in the US are involved in comouter/math science, managment and healthcare spheres. The graph is helpful to know, for example, if I am seeking to find a healthcare practitioner, I will receive most of the applications from Philippines citizens as foreigners.
	===== Tech Details =====		===== Tech Details =====
	* Node: as5		* Node: as5

Eosergi10 at 07:14, 8 December 2011

2011-12-08T07:14:24Z

← Older revision		Revision as of 07:14, 8 December 2011
Line 43:		Line 43:
	[[File:Picture10.jpg\|200px\|thumb\|left\|graph 7]]		[[File:Picture10.jpg\|200px\|thumb\|left\|graph 7]]
	[[File:Picture8.jpg\|200px\|thumb\|left\|graph 8]]		[[File:Picture8.jpg\|200px\|thumb\|left\|graph 8]]
			The last thing I compared was the number of males per particular occupation position vs population of women(graph9).
			[[File:Picture11.jpg\|200px\|thumb\|left\|graph 9]]
	===== Tech Details =====		===== Tech Details =====
	* Node: as5		* Node: as5

Eosergi10 at 07:11, 8 December 2011

2011-12-08T07:11:15Z

← Older revision		Revision as of 07:11, 8 December 2011
Line 22:		Line 22:
	Determening immigrants of which country occupy work in business (as an example) more than others in USA.		Determening immigrants of which country occupy work in business (as an example) more than others in USA.
	select coub,sum(number) from occupations where country='USA' and occupation='USA_02' and fborn=1 group by occupation,coub;		select coub,sum(number) from occupations where country='USA' and occupation='USA_02' and fborn=1 group by occupation,coub;
	Looking at unemployed ~~femail~~ immigrant population in USA. Later the result for each of the nation was divided by the total employed femaile population of that nation in USA.		Looking at unemployed female immigrant population in USA. Later the result for each of the nation was divided by the total employed femaile population of that nation in USA.
	select country,coub,sum(number) from labour_status where fborn=1 and lfs_lfs=2 and and sex=2 and country='USA' group by country,coub;		select country,coub,sum(number) from labour_status where fborn=1 and lfs_lfs=2 and and sex=2 and country='USA' group by country,coub;
	Viewing how many people of the particular field of study are unemployed		Viewing how many people of the particular field of study are unemployed
	select sum(number) from fields_study where field_edu=1 and lfs_lfs!=1;		select sum(number) from fields_study where field_edu=1 and lfs_lfs!=1;
	Viewing overall population of ~~femails~~ that work in agriculture (as example)		Viewing overall population of females that work in agriculture (as example)
	select max(sum) from (select coub,sum(number) from occuations where occupation>='60' and occupation<'70' and sex=2 group by coub) as p1;		select max(sum) from (select coub,sum(number) from occuations where occupation>='60' and occupation<'70' and sex=2 group by coub) as p1;
	*Develop and document the model function you are exploring in the data		*Develop and document the model function you are exploring in the data
Line 38:		Line 38:
	I referred again at USA profile and established which professions get occupied the most by which immigrants (graph 5).		I referred again at USA profile and established which professions get occupied the most by which immigrants (graph 5).
	[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]		[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]
	Next, I looked at employment statuses for the immigrants in USA, and compared the found unemployment rates with the average unemployment rate for the USA,2000 (graph 6)		Next, I looked at employment statuses for the total and female immigrants in USA, and compared the found unemployment rates with the average unemployment rate for the USA,2000 (graph 6)
	[[File:Picture6.jpg\|200px\|thumb\|left\|graph 6]]		[[File:Picture6.jpg\|200px\|thumb\|left\|graph 6]]
			My next step was to compare the popularity of fields of study and how many people with the particular field were currently unemployed (graph 7 - 8).
			[[File:Picture10.jpg\|200px\|thumb\|left\|graph 7]]
			[[File:Picture8.jpg\|200px\|thumb\|left\|graph 8]]

	===== Tech Details =====		===== Tech Details =====
	* Node: as5		* Node: as5

Eosergi10 at 07:05, 8 December 2011

2011-12-08T07:05:16Z

← Older revision		Revision as of 07:05, 8 December 2011
Line 39:		Line 39:
	[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]		[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]
	Next, I looked at employment statuses for the immigrants in USA, and compared the found unemployment rates with the average unemployment rate for the USA,2000 (graph 6)		Next, I looked at employment statuses for the immigrants in USA, and compared the found unemployment rates with the average unemployment rate for the USA,2000 (graph 6)
	[[File:~~Picture5~~.jpg\|200px\|thumb\|left\|graph 6]]		[[File:Picture6.jpg\|200px\|thumb\|left\|graph 6]]
	===== Tech Details =====		===== Tech Details =====
	* Node: as5		* Node: as5

Eosergi10 at 07:04, 8 December 2011

2011-12-08T07:04:55Z

← Older revision		Revision as of 07:04, 8 December 2011
Line 38:		Line 38:
	I referred again at USA profile and established which professions get occupied the most by which immigrants (graph 5).		I referred again at USA profile and established which professions get occupied the most by which immigrants (graph 5).
	[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]		[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]
			Next, I looked at employment statuses for the immigrants in USA, and compared the found unemployment rates with the average unemployment rate for the USA,2000 (graph 6)
			[[File:Picture5.jpg\|200px\|thumb\|left\|graph 6]]
	===== Tech Details =====		===== Tech Details =====
	* Node: as5		* Node: as5

Eosergi10 at 06:58, 8 December 2011

2011-12-08T06:58:56Z

← Older revision		Revision as of 06:58, 8 December 2011
Line 34:		Line 34:
	[[File:Picture2.jpg\|200px\|thumb\|left\|graph 2]]		[[File:Picture2.jpg\|200px\|thumb\|left\|graph 2]]
	[[File:Picture3.jpg\|200px\|thumb\|left\|graph 3]]		[[File:Picture3.jpg\|200px\|thumb\|left\|graph 3]]
	Next, I decided to focus on specifically one nation and determine which work positions they tempt to work most of all and in which countries (from the given OECD range). I particularly wanted to see if preferences for one occupation varied from other one, and ~~weather~~ some countries ~~were used~~ more that once (graph 4).		Next, I decided to focus on specifically one nation (Chinese) and determine which work positions they tempt to work most of all in and in which countries (from the given OECD range). I particularly wanted to see if preferences for one occupation varied from other one, and wether some countries appeared more that once (graph 4).
	[[File:Picture4.jpg\|200px\|thumb\|left\|graph 1]]		[[File:Picture4.jpg\|200px\|thumb\|left\|graph 4]]
			I referred again at USA profile and established which professions get occupied the most by which immigrants (graph 5).
			[[File:Picture5.jpg\|200px\|thumb\|left\|graph 5]]

	===== Tech Details =====		===== Tech Details =====

Eosergi10 at 06:47, 8 December 2011

2011-12-08T06:47:22Z

← Older revision		Revision as of 06:47, 8 December 2011
Line 31:		Line 31:
	*Develop a visualization to show the model/patterns in the data		*Develop a visualization to show the model/patterns in the data
	The following 3 graphs were used to recreate USA population profile (graps 1-3). From the first graph, it is visible that 10% of USA population are people born outside of US, 5 % of which obtained USA citizenship.The second shows where most of the immigrants come from, and the third - how many of those immigrants obtained USA citizenship.		The following 3 graphs were used to recreate USA population profile (graps 1-3). From the first graph, it is visible that 10% of USA population are people born outside of US, 5 % of which obtained USA citizenship.The second shows where most of the immigrants come from, and the third - how many of those immigrants obtained USA citizenship.
	[[File:pop_prof1.jpg\|200px\|thumb\|left\|~~alt text~~]]		[[File:pop_prof1.jpg\|200px\|thumb\|left\|graph 1]]
	[[File:Picture2.jpg\|200px\|thumb\|left\|~~alt text~~]]		[[File:Picture2.jpg\|200px\|thumb\|left\|graph 2]]
	[[File:Picture3.jpg\|200px\|thumb\|left\|~~alt text~~]]		[[File:Picture3.jpg\|200px\|thumb\|left\|graph 3]]
	Next, I decided to focus on specifically one nation and determine which work positions they tempt to work most of all and in which countries (from the given OECD range). I particularly wanted to see if preferences for one occupation varied from other one, and weather some countries were used more that once (graph 4).		Next, I decided to focus on specifically one nation and determine which work positions they tempt to work most of all and in which countries (from the given OECD range). I particularly wanted to see if preferences for one occupation varied from other one, and weather some countries were used more that once (graph 4).
	[[File:Picture4.jpg\|200px\|thumb\|left\|~~alt text~~]]		[[File:Picture4.jpg\|200px\|thumb\|left\|graph 1]]

	===== Tech Details =====		===== Tech Details =====

Eosergi10 at 06:44, 8 December 2011

2011-12-08T06:44:54Z

← Older revision		Revision as of 06:44, 8 December 2011
Line 30:		Line 30:
	*Develop and document the model function you are exploring in the data		*Develop and document the model function you are exploring in the data
	*Develop a visualization to show the model/patterns in the data		*Develop a visualization to show the model/patterns in the data
	The following 3 graphs were used to recreate USA population profile. From the first graph, it is visible that 10% of USA population are people born outside of US, 5 % of which obtained USA citizenship.The second shows where most of the immigrants come from, and the third - how many of those immigrants obtained USA citizenship.		The following 3 graphs were used to recreate USA population profile (graps 1-3). From the first graph, it is visible that 10% of USA population are people born outside of US, 5 % of which obtained USA citizenship.The second shows where most of the immigrants come from, and the third - how many of those immigrants obtained USA citizenship.
	[[File:pop_prof1.jpg\|200px\|thumb\|left\|alt text]]		[[File:pop_prof1.jpg\|200px\|thumb\|left\|alt text]]
	[[File:Picture2.jpg\|200px\|thumb\|left\|alt text]]		[[File:Picture2.jpg\|200px\|thumb\|left\|alt text]]
	[[File:Picture3.jpg\|200px\|thumb\|left\|alt text]]		[[File:Picture3.jpg\|200px\|thumb\|left\|alt text]]
	Next, I decided to focus on specifically one nation and determine which work positions they tempt to work most of all and in which countries (from the given OECD range). I particularly wanted to see if preferences for one occupation varied from other one, and weather some countries were used more that once.		Next, I decided to focus on specifically one nation and determine which work positions they tempt to work most of all and in which countries (from the given OECD range). I particularly wanted to see if preferences for one occupation varied from other one, and weather some countries were used more that once (graph 4).
	[[File:Picture4.jpg\|200px\|thumb\|left\|alt text]]		[[File:Picture4.jpg\|200px\|thumb\|left\|alt text]]