Mittwoch, 14. Juli 2010

Macroeconomy: 2004-2007

next Step:

http://pwt.econ.upenn.edu/

sheets, drawings, statistical functions & dbase + pivot & chart

1.download data file.csv
2.import data with openoffice calc
3.upload in local dbase
4.graphs
Eingestellt von um

6 Kommentare:

  1. D®14. Juli 2010 um 11:38

    csv und xls file upgeloadet

    AntwortenLöschen
  2. D®16. Juli 2010 um 05:21

    Dieser Kommentar wurde vom Autor entfernt.

    AntwortenLöschen
  3. D®17. Juli 2010 um 15:08

    Dieser Kommentar wurde vom Autor entfernt.

    AntwortenLöschen
  4. D®17. Juli 2010 um 15:11

    1.country
    2.countryisocode
    3.year
    4.POP
    5.XRAT
    6.PPP
    7.cgdp
    8.cc
    9.cg
    10.ci
    11.p
    12.pc
    13.pg
    14.pi
    15.openc
    16.cgnp
    17.y
    18.rgdpl
    19.rgdpch
    20.rgdpeqa
    21.rgdpwok

    NEW Variables:
    Currency_Unit
    yEKS
    yCPDW
    rgdptt
    openk
    kc
    kg
    ki
    rgdpl2wok
    rgdpl2pe
    rgdpl2te
    rgdpl2th
    grgdpch
    grgdpl2
    rgdpl2

    create table macroeconomy (auto_increment,
    country text,
    isocode text,
    year int(5),
    POP blob,
    XRAT blob,
    Currency_Unit blob,
    ppp blob,
    cgdp blob,
    cc blob,
    cg blob,
    ci blob,
    p blob,
    pc blob,
    pg blob,
    pi blob,
    openc blob,
    cgnp blob,
    y blob,
    yEKS blob,
    yCPDW blob,
    rgdpl blob,
    rgdpl2 blob,
    rgdpch blob,
    rgdpeqa blob,
    rgdpwok blob,
    rgdpl2wok blob,
    rgdpl2pe text,
    rgdpl2te text,
    rgdpl2th text,
    rgdptt blob,
    openk blob,
    kc blob,
    kg blob,
    ki blob,
    grgdpch blob,
    grgdpl2 blob);

    upload csv
    create access dbase
    select isocode new_table

    AntwortenLöschen
  5. D®29. November 2010 um 07:45

    $mysqlsum = "SELECT `country` , `isocode` , SUM( PPP ) FROM `basic_me_data_full` WHERE `country` = 'italy' GROUP BY 'PPP'"; $FEHLER: YEAR! Real Gross Domestic Product per Capita Relative to the United States $mysqlmax = "SELECT `country` , `isocode` , year , MAX( POP ) FROM `basic_me_data_full` WHERE `country` = 'italy' GROUP BY 'POP'"; //58147.73437 $mysqlmin = "SELECT `country` , `isocode` , year , MIN( y ) FROM `basic_me_data_full` WHERE `country` = 'italy' GROUP BY 'y'"; //37.056842803955 $mysqlavg = "SELECT `country` , `isocode` , AVG( XRAT ) FROM `basic_me_data_full` WHERE `year` > '2000' AND `country` = 'russia' GROUP BY 'XRAT'"

    AntwortenLöschen
  6. D®29. November 2010 um 07:58

    SELECT * FROM `basic_me_data_full` WHERE country = 'italy' AND `pop` LIKE '58147.%' //2007

    SELECT * FROM `basic_me_data_full` WHERE country = 'italy' AND y LIKE '37.%' //1950

    //Government Share of Real Gross Domestic Product per Capita, current price!
    mysqlmin = "SELECT country, year, MIN( cg ) FROM `basic_me_data_full` WHERE `country` = 'italy' GROUP BY cg"; //1999

    AntwortenLöschen

Abonnieren Kommentare zum Post (Atom)