Given a sample CSV file,
loan_purpose,loan_type,app_started,loan_amount,individual_joint,disains,credit_ins,fname,mname,lname,ssn,account,dob,email,home_ph,work,cell,years_residence,address,city,state,zip,employer,monthly_income,emp_status,jobtitle,emp_started_on,income_other,inco_borrower_other_src,own_rent,monthly_housing,ref_fname,ref_lname,ref_addr,ref_city,ref_state,ref_zip,ref_phone,ref_relation,co_borrower_fname,co_borrower_mname,co_borrower_lname,co_borrower_ssn,co_borrower_account,co_borrower_dob,co_borrower_email,co_borrower_home_ph,co_borrower_work,co_borrower_cell,co_borrower_years_residence,co_borrower_address,co_borrower_city,co_borrower_state,co_borrower_zip,co_borrower_employer,co_borrower_monthly_income,co_borrower_emp_status,co_borrower_jotitle,co_borrower_emp_started_on,co_borrower_income_other,co_borrower_inco_borrower_other_src,co_borrower_own_rent,co_borrower_monthly_housing,co_borrower_ref_fname,co_borrower_ref_lname,co_borrower_ref_addr,co_borrower_ref_city,co_borrower_ref_state,co_borrower_ref_zip,co_borrower_ref_phone,co_borrower_ref_relation "back rent",LG,05/31/2019,93204,1,SCD,SCL,Darth1,N,Williams1,934-65-8244,,05/31/1964,ubqmgr1@jelzfyvindp.com,742-166-9837,896-318-4211,568-745-4491,4,"18297 Noname Road","Some Town",MA,27532,Target,2082,2,Refinisher,05/31/2017,139,"Organ Sales",1,3362,Darth1,Smith1,"40280 Harms Way","Good Intent",TX,06943,141-841-4118,6,Susan1,T,Jones1,987-31-6949,,05/31/1976,xcuisltyhj1@ncfbxkjp.com,858-143-8972,584-464-8945,273-982-4787,6,"02557 Laughter Lane",Nothing,WY,93747,Chevron,1553,1,Fixer,05/31/2008,170,"Hobby Trading",2,2165,John1,Johnson1,"87783 Third Street","Some Town",TX,37269,844-685-7513,4 "Lotto Ticket Investment",OC,05/31/2019,97828,3,SCD,JCL,John2,C,Skywalker2,277-77-7639,,05/31/1964,dxfrenivawo2@zyxfauqwc.com,581-552-5934,673-258-5512,195-135-2518,6,"62092 Andunder","San Francisco",MS,56886,"Assad's Camel Rehumping",3146,5,"Visionary Development",05/31/2017,500,Tips,1,3158,Howard2,Jones2,"09763 Goa Way","Dog Town",ND,98168,192-841-6354,5,Robert2,G,Addams2,215-51-4271,,05/31/1986,unaigvwfyq2@ivfgaozyher.com,594-557-1164,411-196-4357,395-399-6414,9,"25987 Andover",Peculiar,WA,73156,"Pizza Hut",724,1,CEO,05/31/2006,182,"Shares Interest",3,2412,Susan2,Smith2,"68043 78th",Toast,LA,54923,232-851-5371,6 Remodel,UT,05/31/2019,431084,1,,JCL,Mary3,R,Smith3,112-67-8991,,05/31/1972,drzcwegpyjk3@ctlqeupar.com,556-752-4112,558-422-4291,466-368-9533,1,"99774 Andover",Hazardville,NC,55405,Hilton,4218,1,"Listener of the Universe",05/31/2006,116,"Child Support",3,1068,Howard3,Smith3,"31902 Second Street","Some Town",AZ,85753,111-355-9448,6,Leia3,Q,Williams3,657-19-1168,,05/31/1986,eagyhrfb3@ayrshfdjxlqio.com,678-963-9956,874-771-6879,183-546-3385,4,"20793 Second Street",Anywhere,KS,75147,Wal-Mart,1950,6,"Clock Watcher",05/31/2015,477,"Yard Sale",2,1257,Joe3,Johnson3,"01455 Oddville Avenue",Desperation,CT,30628,211-793-8696,5 "Open Ice Cream Shop",UT,05/31/2019,82291,3,no_CD,JCL,Mary4,E,Addams4,321-95-7285,,05/31/1986,dopuflrzxb4@hswolcvndjfey.com,427-924-5668,297-997-3553,338-397-2193,8,"55984 Hard to Find Drive",Gogogogo,NE,06296,"Assad's Camel Rehumping",4362,2,Refinisher,05/31/2012,276,Tips,2,2339,Howard4,Smith4,"81757 78th",Seattle,RI,62293,766-392-8494,4,Robert4,Q,Skywalker4,331-39-9371,,05/31/1958,xezrbasyqn4@ajsthfpmz.com,432-162-5344,124-774-7447,829-673-6212,3,"54624 Third Street",Nameless,HI,24531,Starbucks,2573,1,Worker,05/31/2014,238,"Newspaper Delivery",1,1453,Leia4,Jones4,"38766 Third Street","New York",UT,69162,582-213-1941,4 "New Car",RV,05/31/2019,235374,3,no_CD,SCL,Robert5,T,McDonald5,816-61-2612,,05/31/1965,yftjbedsgn5@stdnixkhw.com,467-996-9923,731-426-2262,774-749-8479,9,"66190 That Street",Accident,ID,05060,Target,2337,1,Peon,05/31/2009,116,"Selling Stuff",3,1685,Jean5,Johnson5,"62442 First Street","Good Intent",OK,72246,414-743-1213,6,Susan5,H,Williams5,449-69-7976,,05/31/1976,ankjge5@ktfcdijzwrsx.com,515-458-5413,955-481-7137,779-128-9885,6,"38084 Andunder",Miami,MA,99270,Nordstrom's,2426,2,Busboy,05/31/2005,532,"Selling Stuff",1,2955,Susan5,McDonald5,"71080 Oddville Avenue",Embarrassment,CT,80839,327-579-4484,3 Remodel,SS,05/31/2019,231221,3,no_CD,JCL,Mary6,N,Jones6,454-21-1475,,05/31/1973,kzldcwhvgjp6@iyuwvarncq.com,712-134-6558,214-965-8953,814-254-5182,2,"90008 212th",Imalone,TN,51758,"Assad's Camel Rehumping",3003,5,Servant,05/31/2010,573,"Hobby Trading",3,1432,Howard6,Jones6,"02835 Main Street","San Francisco",OK,80909,964-838-2628,2,Darth6,R,Smith6,941-58-4921,,05/31/1973,xmvrab6@cltveowd.com,468-253-4756,116-495-2452,445-331-6849,2,"52697 Third Street","Good Intent",MO,36425,Outback,4138,5,Legend,05/31/2016,205,"Selling Stuff",3,2821,Joe6,Skywalker6,"97550 78th","Dog Town",MS,39045,419-729-7414,2 "Lotto Ticket Investment",HE,05/31/2019,493531,3,no_CD,,Joe7,C,Smith7,585-27-2849,,05/31/1987,vtrae7@xudzhmqgfe.com,672-158-1126,369-484-4392,854-386-2254,5,"58578 Boring Road",Accident,SD,17458,AutoZone,3544,5,Servant,05/31/2012,180,"Car Washing",2,2643,Susan7,McDonald7,"49612 Crooks Road",Miami,GA,96075,367-726-9487,2,Howard7,M,Williams7,625-74-6268,,05/31/1955,clgizqrj7@bhvwunmgpj.com,111-853-3499,994-223-4739,826-831-7858,4,"43998 That Street",Anytown,SD,40841,Starbucks,3861,6,Dishwasher,05/31/2008,310,"Car Washing",2,1945,Mary7,Skywalker7,"28572 Third Street","San Francisco",RI,67070,364-167-3732,3 "Open Ice Cream Shop",UL,05/31/2019,239846,3,no_CD,no_CL,Mary8,S,Johnson8,156-59-7143,,05/31/1959,isgyklo8@wkxyhrnbl.com,165-468-8922,968-131-4193,521-815-9765,8,"86832 Toe Jam Hill","Some Town",AZ,82296,Target,1478,6,"Head Mopper Upper",05/31/2008,589,"Organ Sales",2,1900,Joe8,Addams8,"58476 Third Street",Accident,ND,39015,229-146-8273,5,Robert8,Y,Addams8,647-71-3281,,05/31/1954,xheitbykq8@qkapgcjtilxnr.com,844-786-4984,748-213-2219,493-855-6343,6,"41788 This Street",Nothing,MA,96939,Albertson's,3188,1,Dishwasher,05/31/2014,445,"Hobby Trading",1,3294,Darth8,Smith8,"66200 Main Street",Anytown,CA,21436,552-575-1794,3 "Because I Can",OD,05/31/2019,16451,1,SCD,SCL,Susan9,R,Addams9,773-22-1724,,05/31/1979,ipjlocybqg9@crvbtfe.com,283-966-8865,178-213-8348,185-848-9597,9,"51057 Noname Road",Nowhere,SD,50465,"Ace Hardware",4952,5,Cook,05/31/2013,413,"Hobby Trading",1,834,Leia9,McDonald9,"89472 Goa Way",Somewhere,WY,90742,944-392-9724,6,Mary9,D,Skywalker9,336-87-9241,,05/31/1958,lxenygjbp9@tvapfsqgz.com,227-862-6547,418-846-6157,268-384-8658,6,"62482 Andunder","New York",KY,63907,Mobil,2850,6,"Listener of the Universe",05/31/2010,486,Panhandling,1,2209,Mary9,Jones9,"04550 Third Street",Anytown,KS,04783,635-581-5496,5 "Fur Coat",SC,05/31/2019,161729,3,no_CD,no_CL,John10,M,Johnson10,569-45-2251,,05/31/1978,estub10@vbsnzraux.com,885-574-3336,994-939-9757,758-162-1133,6,"43295 This Street","Dog Town",NC,10023,"Ace Hardware",3865,2,Maid,05/31/2012,53,"Yard Work",2,2697,Leia10,Williams10,"41507 This Street",Somewhere,MN,29867,992-776-4361,4,Howard10,P,Addams10,676-85-7996,,05/31/1980,mpaysbjh10@jnsqtguzmbl.com,473-582-1554,817-944-2175,319-847-6831,1,"33968 That Street",Miami,SD,41708,Starbucks,3860,5,Waiter,05/31/2005,424,"Shares Interest",2,839,Jean10,Skywalker10,"81191 That Street","New York",WI,01148,839-496-7929,6 "Pay off spouse",SS,05/31/2019,206336,3,,JCL,Mary11,D,Smith11,992-59-1223,,05/31/1961,lhvqy11@wxygjeaoc.com,562-649-6428,172-799-7624,127-992-1592,6,"20720 78th",Mystic,FL,50320,Nordstrom's,4276,5,Maid,05/31/2005,551,"Shares Interest",1,1684,Jean11,McDonald11,"33264 Harms Way","New York",WY,86377,949-958-5385,2,Howard11,E,Addams11,492-13-8656,,05/31/1962,eubjwyax11@ucjadkpwg.com,912-898-7753,254-219-4819,852-827-2127,7,"58962 Noname Road",Peculiar,VA,87526,Target,806,5,"Project Manager",05/31/2017,294,"Car Washing",3,3465,Robert11,McDonald11,"07183 Boring Road",Embarrassment,VT,96506,412-461-4351,4 "Pay off spouse",UT,05/31/2019,464368,3,no_CD,,Susan12,B,Addams12,682-76-5176,,05/31/1961,sqawyh12@zotedpbj.com,233-939-1251,843-351-2272,683-565-4884,7,"86359 Laughter Lane","Some Town",KS,04160,Wal-Mart,4081,1,Waiter,05/31/2006,327,"Yard Sale",2,893,Joe12,Jones12,"42052 Noname Road",Imalone,WI,15856,837-966-5899,4,Darth12,V,Johnson12,923-28-9534,,05/31/1972,qmdkzuoe12@rkjhbvtfmu.com,721-588-1357,831-948-2532,223-345-4557,4,"93416 Second Street","San Francisco",FL,16550,Outback,3659,1,Engineer,05/31/2017,149,"Child Support",1,3446,Howard12,Williams12,"96170 Goa Way",Somewhere,GA,68205,285-869-5829,1 "Fur Coat",UT,05/31/2019,40146,1,no_CD,SCL,Susan13,N,Smith13,545-68-3333,,05/31/1969,aeioxtuk13@uhmzpeli.com,782-649-4362,195-927-3945,456-289-8293,6,"24403 First Street",Somewhere,RI,32320,Target,4479,1,"Clock Watcher",05/31/2015,531,"Shares Interest",2,2258,Robert13,Skywalker13,"05635 Second Street",Mystic,KY,36399,536-591-6517,2,Darth13,O,Jones13,494-57-8738,,05/31/1974,vpazbt13@nywghsjd.com,687-783-6611,788-728-8666,658-376-1357,5,"60532 Booger Hollow Road",Seattle,MO,81836,Bi-Mart,3975,1,"Visionary Development",05/31/2017,41,Tips,2,2924,Robert13,Williams13,"47017 This Street",Imalone,CO,58474,442-714-7754,4 House,HE,05/31/2019,314509,1,SCD,,Darth14,A,McDonald14,592-61-1325,,05/31/1959,gomplza14@oucdrmqnbjv.com,868-767-1768,777-697-7743,675-385-5632,1,"51769 That Street","San Diego",MA,74085,Wendy's,2196,5,Fixer,05/31/2018,170,"Newspaper Delivery",3,3193,Howard14,Smith14,"02143 Noname Road",Desperation,WY,15045,645-337-7789,5,John14,E,Williams14,822-73-9294,,05/31/1966,zfeiyabsrtq14@ayuomnq.com,453-551-7844,245-588-5645,175-686-7618,9,"70969 Main Street",Desperation,NE,27030,Nordstrom's,1627,5,Minion,05/31/2008,195,"Yard Work",3,1034,Mary14,McDonald14,"69490 Harms Way",Toast,HI,13878,194-341-8891,1
We parse it into an associative array like so.
Array
(
[errors] => Array
(
[0] =>
The data length is incorrect, please check the CSV file.
The columns in the header MUST match the columns in the data rows.
)
[data] => Array
(
)
)
Here is a broken version, with only one line missing a column (took out "Mary8," from line 9.)
Array
(
[errors] => Array
(
[0] =>
The data length is incorrect, please check the CSV file.
The columns in the header MUST match the columns in the data rows.
)
[data] => Array
(
)
)