Forked from alebusi/OECD International Student Assessment 2012.csv
Last active
August 29, 2015 14:17
-
-
Save FrieseWoudloper/e68d29dec15f818945e4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
country | subject | gender | value | |
---|---|---|---|---|
Australia | math | boys | 510 | |
Australia | math | girls | 498 | |
Australia | reading | boys | 495 | |
Australia | reading | girls | 530 | |
Australia | science | boys | 524 | |
Australia | science | girls | 519 | |
Austria | math | boys | 517 | |
Austria | math | girls | 494 | |
Austria | reading | boys | 471 | |
Austria | reading | girls | 508 | |
Austria | science | boys | 510 | |
Austria | science | girls | 501 | |
Belgium | math | boys | 520 | |
Belgium | math | girls | 509 | |
Belgium | reading | boys | 493 | |
Belgium | reading | girls | 525 | |
Belgium | science | boys | 507 | |
Belgium | science | girls | 503 | |
Brazil | math | boys | 401 | |
Brazil | math | girls | 383 | |
Brazil | reading | boys | 394 | |
Brazil | reading | girls | 425 | |
Brazil | science | boys | 406 | |
Brazil | science | girls | 404 | |
Canada | math | boys | 523 | |
Canada | math | girls | 513 | |
Canada | reading | boys | 506 | |
Canada | reading | girls | 541 | |
Canada | science | boys | 527 | |
Canada | science | girls | 524 | |
Chile | math | boys | 436 | |
Chile | math | girls | 411 | |
Chile | reading | boys | 430 | |
Chile | reading | girls | 452 | |
Chile | science | boys | 448 | |
Chile | science | girls | 442 | |
Czech Republic | math | boys | 505 | |
Czech Republic | math | girls | 493 | |
Czech Republic | reading | boys | 474 | |
Czech Republic | reading | girls | 513 | |
Czech Republic | science | boys | 509 | |
Czech Republic | science | girls | 508 | |
Denmark | math | boys | 507 | |
Denmark | math | girls | 493 | |
Denmark | reading | boys | 481 | |
Denmark | reading | girls | 512 | |
Denmark | science | boys | 504 | |
Denmark | science | girls | 493 | |
Estonia | math | boys | 523 | |
Estonia | math | girls | 518 | |
Estonia | reading | boys | 494 | |
Estonia | reading | girls | 538 | |
Estonia | science | boys | 540 | |
Estonia | science | girls | 543 | |
Finland | math | boys | 517 | |
Finland | math | girls | 520 | |
Finland | reading | boys | 494 | |
Finland | reading | girls | 556 | |
Finland | science | boys | 537 | |
Finland | science | girls | 554 | |
France | math | boys | 499 | |
France | math | girls | 491 | |
France | reading | boys | 483 | |
France | reading | girls | 527 | |
France | science | boys | 498 | |
France | science | girls | 500 | |
Germany | math | boys | 520 | |
Germany | math | girls | 507 | |
Germany | reading | boys | 486 | |
Germany | reading | girls | 530 | |
Germany | science | boys | 524 | |
Germany | science | girls | 524 | |
Greece | math | boys | 457 | |
Greece | math | girls | 449 | |
Greece | reading | boys | 452 | |
Greece | reading | girls | 502 | |
Greece | science | boys | 460 | |
Greece | science | girls | 473 | |
Hungary | math | boys | 482 | |
Hungary | math | girls | 473 | |
Hungary | reading | boys | 468 | |
Hungary | reading | girls | 508 | |
Hungary | science | boys | 496 | |
Hungary | science | girls | 493 | |
Iceland | math | boys | 490 | |
Iceland | math | girls | 496 | |
Iceland | reading | boys | 457 | |
Iceland | reading | girls | 508 | |
Iceland | science | boys | 477 | |
Iceland | science | girls | 480 | |
Indonesia | math | boys | 377 | |
Indonesia | math | girls | 373 | |
Indonesia | reading | boys | 382 | |
Indonesia | reading | girls | 410 | |
Indonesia | science | boys | 380 | |
Indonesia | science | girls | 383 | |
Ireland | math | boys | 509 | |
Ireland | math | girls | 494 | |
Ireland | reading | boys | 509 | |
Ireland | reading | girls | 538 | |
Ireland | science | boys | 524 | |
Ireland | science | girls | 520 | |
Israel | math | boys | 472 | |
Israel | math | girls | 461 | |
Israel | reading | boys | 463 | |
Israel | reading | girls | 507 | |
Israel | science | boys | 470 | |
Israel | science | girls | 470 | |
Italy | math | boys | 494 | |
Italy | math | girls | 476 | |
Italy | reading | boys | 471 | |
Italy | reading | girls | 510 | |
Italy | science | boys | 495 | |
Italy | science | girls | 492 | |
Japan | math | boys | 545 | |
Japan | math | girls | 527 | |
Japan | reading | boys | 527 | |
Japan | reading | girls | 551 | |
Japan | science | boys | 552 | |
Japan | science | girls | 541 | |
Korea | math | boys | 562 | |
Korea | math | girls | 544 | |
Korea | reading | boys | 525 | |
Korea | reading | girls | 548 | |
Korea | science | boys | 539 | |
Korea | science | girls | 536 | |
Luxembourg | math | boys | 502 | |
Luxembourg | math | girls | 477 | |
Luxembourg | reading | boys | 473 | |
Luxembourg | reading | girls | 503 | |
Luxembourg | science | boys | 499 | |
Luxembourg | science | girls | 483 | |
Mexico | math | boys | 420 | |
Mexico | math | girls | 406 | |
Mexico | reading | boys | 411 | |
Mexico | reading | girls | 435 | |
Mexico | science | boys | 418 | |
Mexico | science | girls | 412 | |
Netherlands | math | boys | 528 | |
Netherlands | math | girls | 518 | |
Netherlands | reading | boys | 498 | |
Netherlands | reading | girls | 525 | |
Netherlands | science | boys | 524 | |
Netherlands | science | girls | 520 | |
New Zealand | math | boys | 507 | |
New Zealand | math | girls | 492 | |
New Zealand | reading | boys | 495 | |
New Zealand | reading | girls | 530 | |
New Zealand | science | boys | 518 | |
New Zealand | science | girls | 513 | |
Norway | math | boys | 490 | |
Norway | math | girls | 488 | |
Norway | reading | boys | 481 | |
Norway | reading | girls | 528 | |
Norway | science | boys | 493 | |
Norway | science | girls | 496 | |
Poland | math | boys | 520 | |
Poland | math | girls | 516 | |
Poland | reading | boys | 497 | |
Poland | reading | girls | 539 | |
Poland | science | boys | 524 | |
Poland | science | girls | 527 | |
Portugal | math | boys | 493 | |
Portugal | math | girls | 481 | |
Portugal | reading | boys | 468 | |
Portugal | reading | girls | 508 | |
Portugal | science | boys | 488 | |
Portugal | science | girls | 490 | |
Russia | math | boys | 481 | |
Russia | math | girls | 483 | |
Russia | reading | boys | 455 | |
Russia | reading | girls | 495 | |
Russia | science | boys | 484 | |
Russia | science | girls | 489 | |
Slovak Republic | math | boys | 486 | |
Slovak Republic | math | girls | 477 | |
Slovak Republic | reading | boys | 444 | |
Slovak Republic | reading | girls | 483 | |
Slovak Republic | science | boys | 475 | |
Slovak Republic | science | girls | 467 | |
Slovenia | math | boys | 503 | |
Slovenia | math | girls | 499 | |
Slovenia | reading | boys | 454 | |
Slovenia | reading | girls | 510 | |
Slovenia | science | boys | 510 | |
Slovenia | science | girls | 519 | |
Spain | math | boys | 492 | |
Spain | math | girls | 476 | |
Spain | reading | boys | 474 | |
Spain | reading | girls | 503 | |
Spain | science | boys | 500 | |
Spain | science | girls | 493 | |
Sweden | math | boys | 477 | |
Sweden | math | girls | 480 | |
Sweden | reading | boys | 458 | |
Sweden | reading | girls | 509 | |
Sweden | science | boys | 481 | |
Sweden | science | girls | 489 | |
Switzerland | math | boys | 537 | |
Switzerland | math | girls | 524 | |
Switzerland | reading | boys | 491 | |
Switzerland | reading | girls | 527 | |
Switzerland | science | boys | 518 | |
Switzerland | science | girls | 512 | |
Turkey | math | boys | 452 | |
Turkey | math | girls | 444 | |
Turkey | reading | boys | 453 | |
Turkey | reading | girls | 499 | |
Turkey | science | boys | 458 | |
Turkey | science | girls | 469 | |
United Kingdom | math | boys | 500 | |
United Kingdom | math | girls | 488 | |
United Kingdom | reading | boys | 487 | |
United Kingdom | reading | girls | 512 | |
United Kingdom | science | boys | 521 | |
United Kingdom | science | girls | 508 | |
United States | math | boys | 484 | |
United States | math | girls | 479 | |
United States | reading | boys | 482 | |
United States | reading | girls | 513 | |
United States | science | boys | 497 | |
United States | science | girls | 498 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Country | Math girls | Math boys | Reading girls | Reading boys | Science girls | Science boys | |
---|---|---|---|---|---|---|---|
Australia | 498 | 510 | 530 | 495 | 519 | 524 | |
Austria | 494 | 517 | 508 | 471 | 501 | 510 | |
Belgium | 509 | 520 | 525 | 493 | 503 | 507 | |
Brazil | 383 | 401 | 425 | 394 | 404 | 406 | |
Canada | 513 | 523 | 541 | 506 | 524 | 527 | |
Chile | 411 | 436 | 452 | 430 | 442 | 448 | |
Czech Republic | 493 | 505 | 513 | 474 | 508 | 509 | |
Denmark | 493 | 507 | 512 | 481 | 493 | 504 | |
Estonia | 518 | 523 | 538 | 494 | 543 | 540 | |
Finland | 520 | 517 | 556 | 494 | 554 | 537 | |
France | 491 | 499 | 527 | 483 | 500 | 498 | |
Germany | 507 | 520 | 530 | 486 | 524 | 524 | |
Greece | 449 | 457 | 502 | 452 | 473 | 460 | |
Hungary | 473 | 482 | 508 | 468 | 493 | 496 | |
Iceland | 496 | 490 | 508 | 457 | 480 | 477 | |
Indonesia | 373 | 377 | 410 | 382 | 383 | 380 | |
Ireland | 494 | 509 | 538 | 509 | 520 | 524 | |
Israel | 461 | 472 | 507 | 463 | 470 | 470 | |
Italy | 476 | 494 | 510 | 471 | 492 | 495 | |
Japan | 527 | 545 | 551 | 527 | 541 | 552 | |
Korea | 544 | 562 | 548 | 525 | 536 | 539 | |
Luxembourg | 477 | 502 | 503 | 473 | 483 | 499 | |
Mexico | 406 | 420 | 435 | 411 | 412 | 418 | |
Netherlands | 518 | 528 | 525 | 498 | 520 | 524 | |
New Zealand | 492 | 507 | 530 | 495 | 513 | 518 | |
Norway | 488 | 490 | 528 | 481 | 496 | 493 | |
Poland | 516 | 520 | 539 | 497 | 527 | 524 | |
Portugal | 481 | 493 | 508 | 468 | 490 | 488 | |
Russia | 483 | 481 | 495 | 455 | 489 | 484 | |
Slovak Republic | 477 | 486 | 483 | 444 | 467 | 475 | |
Slovenia | 499 | 503 | 510 | 454 | 519 | 510 | |
Spain | 476 | 492 | 503 | 474 | 493 | 500 | |
Sweden | 480 | 477 | 509 | 458 | 489 | 481 | |
Switzerland | 524 | 537 | 527 | 491 | 512 | 518 | |
Turkey | 444 | 452 | 499 | 453 | 469 | 458 | |
United Kingdom | 488 | 500 | 512 | 487 | 508 | 521 | |
United States | 479 | 484 | 513 | 482 | 498 | 497 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import csv | |
with open('OECD International Student Assessment 2012 - Transposed.csv', 'wb') as destfile: | |
writer = csv.writer(destfile) | |
writer.writerow(['country', 'subject', 'gender', 'value']) | |
with open('OECD International Student Assessment 2012.csv', 'rb') as sourcefile: | |
for d in csv.DictReader(sourcefile): | |
country = d.pop('Country') | |
for variable, value in sorted(d.items()): | |
i = variable.find(" ") | |
row = [country, variable[0:i].lower(), variable[i+1:].lower(), value] | |
writer.writerow(row) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment