|
|
| 第1行： |
第1行： |
| | | | |
| − | ==数据清洗==
| |
| − | 导入另一个表
| |
| − |
| |
| − | insert into table test select LoanStatus,BorrowerRate,ProsperScore,Occupation,EmploymentStatus,IsBorrowerHomeowner,CreditScoreRangeLower,CreditScoreRangeUpper,IncomeRange form perop;
| |
| − |
| |
| − | 导入后的数据示例
| |
| − |
| |
| − | Completed,0.158,,Other,Self-employed,TRUE,640,659,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.092,7,Professional,Employed,FALSE,680,699,"$50,000-74,999"
| |
| − |
| |
| − | Completed,0.275,,Other,Not available,FALSE,480,499,Not displayed
| |
| − |
| |
| − | Current,0.0974,9,Skilled Labor,Employed,TRUE,800,819,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.2085,4,Executive,Employed,TRUE,680,699,"$100,000+"
| |
| − |
| |
| − | Current,0.1314,10,Professional,Employed,TRUE,740,759,"$100,000+"
| |
| − |
| |
| − | Current,0.2712,2,Sales - Retail,Employed,FALSE,680,699,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.2019,4,Laborer,Employed,FALSE,700,719,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.0629,9,Food Service,Employed,TRUE,820,839,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.0629,11,Food Service,Employed,TRUE,820,839,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.2489,7,Fireman,Employed,FALSE,640,659,"$75,000-99,999"
| |
| − |
| |
| − | Completed,0.1325,,Waiter/Waitress,Full-time,FALSE,640,659,"$1-24,999"
| |
| − |
| |
| − | Past Due (1-15 days),0.1435,4,Sales - Retail,Employed,FALSE,680,699,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.1034,8,Construction,Employed,TRUE,740,759,"$50,000-74,999"
| |
| − |
| |
| − | Current,0.0949,8,Computer Programmer,Employed,FALSE,740,759,"$100,000+"
| |
| − |
| |
| − | Defaulted,0.3177,5,Other,Other,TRUE,700,719,"$50,000-74,999"
| |
| − |
| |
| − | Current,0.2809,4,Professional,Full-time,TRUE,640,659,"$75,000-99,999"
| |
| − |
| |
| − | Chargedoff,0.125,,Professional,Not available,TRUE,760,779,Not displayed
| |
| − |
| |
| − | Current,0.0974,7,Sales - Commission,Employed,FALSE,740,759,"$75,000-99,999"
| |
| − |
| |
| − | Current,0.2225,8,Laborer,Employed,FALSE,680,699,"$25,000-49,999"
| |
| − |
| |
| − | Current,0.1314,7,Retail Management,Employed,TRUE,660,679,"$50,000-74,999"
| |
| − |
| |
| − | Completed,0.2075,,Professional,Full-time,FALSE,620,639,"$25,000-49,999"
| |
