My Life DB

연도 인구 1966 120614 1967 121581 1968 117330 1969 117330 1970 116021 1971 115351 1972 116157 1973 117717 1974 118615 1975 115973 1976 115846 1977 117385 1978 117694 1979 117612 1980 116933 1981 117279 1982 116678 1983 124418 1984 121699 1985 117038 1986 122544 1987 124840 1988 125660 1989 128048 1990 122826 1991 136481 1992 146369 1993 164517 1994 178038 1995 187781 1996 203019 1997 149388 1998 155..

import sqlite3, os conn = sqlite3.connect('example.db')c = conn.cursor() com_te="" for row in c.execute('SELECT * FROM de_addr order by id desc'): for m in range(1,9):com_te = com_te + str(row[m])+","com_te=com_te+"\n" f=open("addr.csv","w")f.write(com_te)f.close c.close() print("CSV file export done.")

주소를 위도, 경도로 바꾸기 library(ggmap)p$addr