查看“数据清洗,抽取”的源代码
←
数据清洗,抽取
跳转至:
导航
,
搜索
因为以下原因,您没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
== 建表语句 == create database 库名; create table test3( ListingKey string , ListingNumber int, ListingCreationDate TIMESTAMP, CreditGrade string, Term int, LoanStatus string, ClosedDate TIMESTAMP, BorrowerAPR float, BorrowerRate float, LenderYield float, EstimatedEffectiveYield float, EstimatedLoss float, EstimatedReturn float, ProsperRating(numeric) int, ProsperRating (Alpha) string, ProsperScore int, ListingCategory (numeric) int, BorrowerState string, Occupation string, EmploymentStatus string, EmploymentStatusDuration int, IsBorrowerHomeowner string, CurrentlyInGroup string, GroupKey string, DateCreditPulled TIMESTAMP, CreditScoreRangeLower int, CreditScoreRangeUpper int, FirstRecordedCreditLine TIMESTAMP, CurrentCreditLines int, OpenCreditLines int, TotalCreditLinespast7years int, OpenRevolvingAccounts int, OpenRevolvingMonthlyPayment int, InquiriesLast6Months int, TotalInquiries int, CurrentDelinquencies int, AmountDelinquent int, DelinquenciesLast7Years int, PublicRecordsLast10Years int, PublicRecordsLast12Months int, RevolvingCreditBalance int, BankcardUtilization float, AvailableBankcardCredit int, TotalTrades int, TradesNeverDelinquent (percentage) float, TradesOpenedLast6Months int, DebtToIncomeRatio float, IncomeRange string, IncomeVerifiable string, StatedMonthlyIncome double, LoanKey string, TotalProsperLoans int, TotalProsperPaymentsBilled int, OnTimeProsperPayments int, ProsperPaymentsLessThanOneMonthLate int, ProsperPaymentsOneMonthPlusLate int, ProsperPrincipalBorrowed int, ProsperPrincipalOutstanding double, ScorexChangeAtTimeOfListing int, LoanCurrentDaysDelinquent int, LoanFirstDefaultedCycleNumber int, LoanMonthsSinceOrigination int, LoanNumber int, LoanOriginalAmount int, LoanOriginationDate TIMESTAMP, LoanOriginationQuarter string, MemberKey string, MonthlyLoanPayment float, LP_CustomerPayments double, LP_CustomerPrincipalPayments double, LP_InterestandFees double, LP_ServiceFees double, LP_CollectionFees double, LP_GrossPrincipalLoss double, LP_NetPrincipalLoss double, LP_NonPrincipalRecoverypayments double, PercentFunded double, Recommendations int, InvestmentFromFriendsCount int, InvestmentFromFriendsAmount double, Investors int )row format delimited fields terminated by ',';
返回至
数据清洗,抽取
。
导航菜单
个人工具
登录
命名空间
页面
讨论
变种
视图
阅读
查看源代码
查看历史
更多
搜索
导航
首页
最近更改
随机页面
帮助
工具
链入页面
相关更改
特殊页面
页面信息