i want to insert the 2 csv into a database lifespan.csvRef_Date,GEO,SEX,AGE,Vector,Coordinate,Value1992/1994,Canada,Both sexes,At birth,v52302196,1.1.1,78.01993/1995,Canada,Both sexes,At birth,v52302196,1.1.1,78.01994/1996,Canada,Both sexes,At birth,v52302196,1.1.1,78.2popolationtest.csvplace,population,lat,lon St. John's (N.L.),208.4,47.5605413, -52.71283150000001 Halifax (N.S.),408.7,44.6488625, -63.5753196 Moncton (N.B.)[1],144.9,46.1013902, -64.8213793 Saint John (N.B.),127.9,45.2733153, -66.0633081 Saguenay, 160.2,48.4280529, -71.0684923 Quebec (Que.),791.9,46.8273212, -71.2349247=============its always shows error ,i cant understand why Ref Date GEO1992/1994 CanadaSEXAGEVectorCoordinate ValueBoth sexes At birthv523021961.1.1781993/1995 CanadaBoth sexes At birthv523021961.1.1781994/1996 CanadaBoth sexes At birthv523021961.1.178.21995/1997 CanadaBoth sexes At birthv523021961.1.178.41996/1998 CanadaBoth sexes At birthv523021961.1.178.61997/1999 CanadaBoth sexes At birthv523021961.1.178.81998/2000 CanadaBoth sexes At birthv523021961.1.1791999/2001 CanadaBoth sexes At birthv523021961.1.179.344470 C placeSt. John's (IHalifax (N.Spopulation latlon208.4 47.56054 -52.7128408.7 44.64886 -63.5753Moncton (I144.9 46.10139 -64.8214Saint John127.9 45.27332 -66.0633SaguenayQuebec (C160.2 48.42805 -71.0685791.9 46.82732 -71.2349

Approach: 1- Don't import any CSV files directly. 2- First, create a database, inside the…

Answered: i want to insert the 2 csv into a…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

i want to insert the 2 csv into a database

lifespan.csv

Ref_Date,GEO,SEX,AGE,Vector,Coordinate,Value
1992/1994,Canada,Both sexes,At birth,v52302196,1.1.1,78.0
1993/1995,Canada,Both sexes,At birth,v52302196,1.1.1,78.0
1994/1996,Canada,Both sexes,At birth,v52302196,1.1.1,78.2

popolationtest.csv

place,population,lat,lon St. John's (N.L.),208.4,47.5605413, -52.71283150000001 Halifax (N.S.),408.7,44.6488625, -63.5753196 Moncton (N.B.)[1],144.9,46.1013902, -64.8213793 Saint John (N.B.),127.9,45.2733153, -66.0633081 Saguenay, 160.2,48.4280529, -71.0684923 Quebec (Que.),791.9,46.8273212, -71.2349247

=============

its always shows error ,i cant understand why