pandas+seaborn折线图笔记

1. pandas增加列操作

diff_data['ds'] = diff_data["ds"].map(lambda ds: str(ds)[4:6]+str(ds)[6:8]) #格式转换
diff_data['day'] = diff_data["ds"].map(lambda ds: str(ds)[6:8]) #增加列
diff_data.loc[:, 'ds_day'] = diff_data["ds"].map(lambda ds: str(ds)[6:8]) #增加列

2. pandas子数据集

diff_data.loc[diff_data.union_active_type == 11,['day','record_miss_rate','log_miss_rate']] #子数据集

3. 数据集拼接

d_rm_lm_dr=pd.concat([drm,dlm,ddr],ignore_index=True) #数据集按行拼接，并忽略序号

折线图全量代码

import pandas as pd
import matplotlib
import matplotlib.pyplot as plt
import seaborn as sns

plt.style.use('ggplot')
# matplotlib.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['font.family'] = ['Arial Unicode MS']
matplotlib.rcParams['axes.unicode_minus']=False

#----------------------1---------------------

diff_data_ori = pd.read_csv('all_diff_info.csv')
diff_data=diff_data_ori[diff_data_ori['union_active_type'] < 20]

# diff_data["ds"] = diff_data["ds"].map(lambda ds: str(ds)[4:6]+str(ds)[6:8]) #格式转换
# diff_data['day'] = diff_data["ds"].map(lambda ds: str(ds)[6:8]) #增加列
# diff_data.loc[:, 'ds_day'] = diff_data["ds"].map(lambda ds: str(ds)[6:8]) #增加列

diff_data=diff_data.copy()
diff_data['day'] = diff_data["ds"].map(lambda ds: str(ds)[6:8])


diff_data

#----------------------2---------------------

#新数据集：record_miss_rate
drm=diff_data.loc[:,['day','union_active_type']]
drm=drm.copy()
#增加列
drm['rate'] = diff_data['record_miss_rate'].map(lambda record_miss_rate: record_miss_rate)
drm['info_name'] = "少发"
# drm


#新数据集：log_miss_rate
dlm=diff_data.loc[:,['day','union_active_type']]
dlm=dlm.copy()
dlm['rate'] = diff_data['log_miss_rate'].map(lambda log_miss_rate: log_miss_rate)
dlm['info_name'] = "多发"
# dlm


#新数据集：diff_rate
ddr=diff_data.loc[:,['day','union_active_type']]
ddr=ddr.copy()
ddr['rate'] = diff_data['diff_rate'].map(lambda diff_rate: diff_rate)
ddr['info_name'] = "错误率"
# ddr

#数据集拼接
d_rm_lm_dr=pd.concat([drm,dlm,ddr],ignore_index=True) #数据集按行拼接，并忽略序号
d_rm_lm_dr


#----------------------3---------------------

#新数据集：diou
diou=diff_data.loc[:,['day','union_active_type']]
diou=diou.copy()
#增加列
diou['rate'] = diff_data['iou'].map(lambda iou: iou)
diou['info_name'] = "iou"
# diou


#新数据集：correct_in_log
dcl=diff_data.loc[:,['day','union_active_type']]
dcl=dcl.copy()
dcl['rate'] = diff_data['correct_in_log'].map(lambda correct_in_log: correct_in_log)
dcl['info_name'] = "进度准确率"
# dcl


#新数据集：correct_in_send
dcs=diff_data.loc[:,['day','union_active_type']]
dcs=dcs.copy()
dcs['rate'] = diff_data['correct_in_send'].map(lambda correct_in_send: correct_in_send)
dcs['info_name'] = "发奖准确率"
# dcs


#新数据集：valid_rate
dvr=diff_data.loc[:,['day','union_active_type']]
dvr=dvr.copy()
dvr['rate'] = diff_data['valid_rate'].map(lambda valid_rate: valid_rate)
dvr['info_name'] = "有效率"
# dvr



#数据集拼接
d_iou_cl_cs_vr=pd.concat([diou,dcl,dcs,dvr],ignore_index=True) #数据集按行拼接，并忽略序号
d_iou_cl_cs_vr


#----------------------4---------------------

#数据集拼接
d_small_rate=d_rm_lm_dr.copy()
d_small_rate['rate_flag'] = "s"
# d_small_rate

#数据集拼接
d_big_rate=d_iou_cl_cs_vr.copy()
d_big_rate['rate_flag'] = "b"
# d_big_rate


#数据集拼接
d_diff_all=pd.concat([d_small_rate,d_big_rate],ignore_index=True) #数据集按行拼接，并忽略序号
d_diff_all


#----------------------5---------------------

sns.relplot(data=d_diff_all, x="day", y="rate", hue="info_name", col="union_active_type", row="rate_flag",kind="line")
plt.ylim(0,1.1) #设置y轴范围

最终结果：

 输入数据示例

"union_active_type","full_join_cnt","has_log_cnt","log_cnt","record_miss_rate","has_record_cnt","record_cnt","log_miss_rate","inner_join_cnt","iou","valid_cnt","valid_rate","diff_cnt","diff_rate","total_log_money","total_send_money","only_log_money","only_send_money","equal_money","correct_in_log","correct_in_send","total_money_diff","ds"
"11","1025","2","990","0.00202020202020202","35","1023","0.03421309872922776","988","0.9639024390243902","988","1.0","4","0.004048582995951417","17852.0","18300.0","20.0","411.0","17768.0","0.9964109466128309","0.9932360668567276","-57.0","20211015"
"15","8892","2219","8164","0.2718030377266046","728","6673","0.10909635845946351","5945","0.668578497525866","5945","1.0","99","0.016652649285113542","142633.0","123404.0","32320.0","11431.0","106002.0","0.9609202904462756","0.9466746447804382","-1660.0","20211015"
"1","19744","134","19243","0.0069635711687366835","501","19610","0.025548189699133094","19109","0.9678383306320908","19109","1.0","466","0.02438641477837668","626100.0800000001","646233.0800000001","2688.0","12290.0","606605.0800000001","0.9730403042558944","0.9568762545684701","-10531.0","20211015"
"2","3074","6","3055","0.0019639934533551553","19","3068","0.006192959582790091","3049","0.9918672739102147","3049","1.0","128","0.041980977369629385","45713.31999999999","46828.92","23.0","154.0","42331.719999999994","0.9264920884773843","0.9069478855025354","-984.6","20211015"
"3","145","0","138","0.0","7","145","0.04827586206896552","138","0.9517241379310345","138","1.0","0","0.0","7560.0","7987.0","0.0","427.0","7560.0","1.0","1.0","0.0","20211015"
"9","4728","15","4682","0.0032037590773173856","46","4713","0.00976023764056864","4667","0.987098138747885","4667","1.0","26","0.005571030640668524","87095.5","88002.5","204.0","520.0","86011.5","0.9898724271073696","0.9831852084702655","-591.0","20211015"
"14","4907","303","4557","0.06649111257406189","350","4604","0.07602085143353605","4254","0.8669248013042592","4239","0.9964739069111425","139","0.032790752535975465","239462.1899999999","247539.6299999998","17012.1","23454.550000000007","216299.83999999997","0.9723522251665535","0.9652576601708609","-1703.6700000000003","20211015"
"11","910","12","856","0.014018691588785047","54","898","0.060133630289532294","844","0.9274725274725275","844","1.0","13","0.015402843601895734","13176.0","14023.0","95.0","716.0","12828.0","0.9806589710266799","0.9640039077177426","-226.0","20211016"
"15","8833","2485","8126","0.3058085158749692","707","6348","0.11137366099558917","5641","0.6386278727499151","5641","1.0","86","0.015245523843290197","159250.0","130232.0","41606.0","12529.0","113615.0","0.9657526095678488","0.9652685148212026","-59.0","20211016"
"1","21714","25","21377","0.0011694812181316369","337","21689","0.015537830236525428","21352","0.983328728009579","21352","1.0","516","0.024166354439865118","826010.8","846051.6","675.0","9162.8","805932.0","0.9764898117832765","0.9630096614986364","-11553.0","20211016"
"2","1828","2","1825","0.001095890410958904","3","1826","0.0016429353778751369","1823","0.9972647702407003","1823","1.0","23","0.012616566099835436","15735.48","15799.48","4.0","8.0","15523.48","0.9867781035223641","0.98302882313754","-60.0","20211016"
"3","214","0","200","0.0","14","214","0.06542056074766354","200","0.9345794392523364","200","1.0","0","0.0","10332.0","11130.0","0.0","798.0","10332.0","1.0","1.0","0.0","20211016"
"9","3928","5","3891","0.0012850167052171678","37","3923","0.009431557481519245","3886","0.9893075356415478","3886","1.0","34","0.008749356664951106","81000.0","81965.0","92.0","443.0","79824.0","0.9866020665447175","0.9791712666519468","-614.0","20211016"
"14","4863","326","4403","0.07404042698160346","460","4537","0.10138858276394093","4077","0.838371375694016","4075","0.9995094432180525","184","0.04515337423312883","243586.40000000008","260478.67000000007","21457.649999999998","36183.97","213188.17000000004","0.959750460037253","0.9504824233474977","-2163.75","20211016"
"11","628","14","608","0.023026315789473683","20","614","0.03257328990228013","594","0.945859872611465","594","1.0","4","0.006734006734006734","9122.0","9119.0","155.0","205.0","8831.0","0.9848332775733244","0.9906888041283375","53.0","20211017"
"15","7816","2369","7209","0.3286170065196282","607","5447","0.11143748852579402","4840","0.6192425793244627","4840","1.0","71","0.014669421487603305","142650.0","114634.0","38534.0","10190.0","100923.0","0.9693322832225595","0.9662881544176783","-328.0","20211017"
"1","20009","48","19736","0.0024321037697608433","273","19961","0.013676669505535794","19688","0.983957219251337","19688","1.0","424","0.021535960991466884","740616.8","755162.8","1430.0","7495.0","723099.0000000001","0.9782358126524988","0.9671394167302645","-8481.0","20211017"
"2","1768","1","1763","0.0005672149744753262","5","1767","0.0028296547821165816","1762","0.996606334841629","1762","1.0","23","0.013053348467650397","15085.2","15127.2","2.0","17.0","14921.2","0.9892595735652912","0.9874918928935421","-27.0","20211017"
"3","153","0","147","0.0","6","153","0.0392156862745098","147","0.9607843137254902","147","1.0","1","0.006802721088435374","7188.0","7559.0","0.0","366.0","7173.0","0.9979131886477463","0.997219518976783","-5.0","20211017"
"9","3737","8","3695","0.002165087956698241","42","3729","0.011263073209975865","3687","0.9866202836499867","3687","1.0","29","0.007865473284513154","75155.0","75915.0","140.0","415.0","74419.0","0.9920549223488636","0.985682119205298","-485.0","20211017"
"14","4234","227","3928","0.05779022403258656","306","4007","0.07636635887197404","3701","0.8741143127066604","3688","0.9964874358281546","130","0.03524945770065076","216435.56999999995","216014.99999999997","15833.900000000007","14102.790000000003","193155.90999999995","0.9628828613440755","0.9566331327857784","-1059.6600000000003","20211017"
"11","703","11","670","0.016417910447761194","33","692","0.0476878612716763","659","0.9374110953058321","659","1.0","11","0.01669195751138088","11450.0","11878.0","100.0","504.0","11095.0","0.9775330396475771","0.9754703710216283","-24.0","20211018"
"15","7979","2524","7409","0.3406667566473208","570","5455","0.10449129239230064","4885","0.6122321092868781","4885","1.0","55","0.011258955987717503","135663.0","111272.0","37680.0","12242.0","95854.0","0.9782717410162988","0.9679289104311825","-1047.0","20211018"
"1","19585","18","19246","0.0009352592746544737","339","19567","0.017325088158634434","19228","0.9817717641051825","19228","1.0","385","0.02002288329519451","602191.6","618453.6","473.0","7592.0","589113.6","0.9790516696675157","0.964397827593026","-9143.0","20211018"
"2","2394","0","2377","0.0","17","2394","0.007101086048454469","2377","0.9928989139515455","2377","1.0","76","0.03197307530500631","32722.68","33442.68","0.0","90.0","30878.68","0.94364764744208","0.9258230523004448","-630.0","20211018"
"3","72","1","69","0.014492753623188406","3","71","0.04225352112676056","68","0.9444444444444444","68","1.0","0","0.0","4178.0","4300.0","61.0","183.0","4117.0","1.0","1.0","0.0","20211018"
"9","3844","7","3810","0.001837270341207349","34","3837","0.008861089392754757","3803","0.9893340270551508","3803","1.0","22","0.00578490665264265","69830.0","70553.0","82.0","435.0","69079.0","0.9904083271204909","0.9851821215665022","-370.0","20211018"
"14","4015","326","3728","0.08744635193133048","287","3689","0.0777988614800759","3402","0.8473225404732254","3382","0.9941211052322163","90","0.026611472501478415","180676.98999999993","185878.72999999992","18397.54","22766.510000000002","157984.24999999988","0.9735320769203984","0.9685617055546174","-559.0899999999989","20211018"
"11","726","21","697","0.03012912482065997","29","705","0.04113475177304964","676","0.931129476584022","676","1.0","7","0.010355029585798817","11842.0","12042.0","210.0","432.0","11450.0","0.984353507565337","0.9862187769164513","22.0","20211019"
"15","8611","2761","7976","0.34616349047141426","635","5850","0.10854700854700855","5215","0.6056207176866798","5215","1.0","41","0.007861936720997123","148708.0","115799.0","44635.0","11204.0","102624.0","0.9860770805107953","0.9811558869926861","-522.0","20211019"
"1","21192","22","20838","0.0010557635089739898","354","21170","0.016721776098252244","20816","0.9822574556436391","20816","1.0","390","0.018735588009223675","645466.6","662605.6","837.0","7999.0","631135.6","0.9790670487362044","0.9641448772438286","-9977.0","20211019"
"2","2541","2","2523","0.0007927070947284979","18","2539","0.0070894052776683735","2521","0.9921290830381739","2521","1.0","37","0.014676715589051963","27463.88","27722.48","4.0","104.0","27020.28","0.9839911900561837","0.9783405893445258","-158.6","20211019"
"3","83","0","75","0.0","8","83","0.0963855421686747","75","0.9036144578313253","75","1.0","0","0.0","4544.0","5032.0","0.0","488.0","4544.0","1.0","1.0","0.0","20211019"
"9","3998","7","3969","0.001763668430335097","29","3991","0.00726634928589326","3962","0.9909954977488744","3962","1.0","17","0.004290762241292277","77451.0","77815.0","95.0","315.5","76922.5","0.9943960390919903","0.9925547906760689","-143.5","20211019"
"14","4273","381","4075","0.09349693251533742","198","3892","0.050873586844809866","3694","0.8644980107652703","3684","0.9972929074174337","112","0.03040173724212812","197099.74000000002","181742.52000000008","24989.510000000006","9358.85","166742.9799999999","0.9688150437077441","0.9672782810575957","78.27999999999966","20211019"
"1006","2","0","0","0.0","2","2","1.0","0","0.0","\N","\N","\N","\N","0.0","50.0","0.0","50.0","\N","\N","\N","\N","20211019"
"11","987","23","926","0.024838012958963283","61","964","0.06327800829875518","903","0.9148936170212766","903","1.0","38","0.042081949058693245","14177.0","14608.0","235.0","568.0","13381.0","0.9597618706067996","0.9530626780626781","-98.0","20211020"
"15","8942","2693","8197","0.32853482981578624","745","6249","0.11921907505200832","5504","0.6155222545291881","5504","1.0","52","0.00944767441860465","139888.0","114600.0","39282.0","13284.0","98700.0","0.9810548078643421","0.9741797939121165","-710.0","20211020"
"1","22464","17","22021","0.0007719903728259389","443","22447","0.01973537666503319","22004","0.979522792022792","22004","1.0","459","0.02085984366478822","726523.96","745671.96","514.0","9047.0","712130.9600000001","0.980883182373972","0.966748343689033","-10615.0","20211020"
"2","2707","6","2673","0.002244668911335578","34","2701","0.012587930396149574","2667","0.9852234946435168","2667","1.0","71","0.02662167229096363","29503.320000000003","30042.320000000003","15.0","196.0","28744.32","0.9747696715174007","0.963077525135427","-358.0","20211020"
"3","92","1","85","0.011764705882352941","7","91","0.07692307692307693","84","0.9130434782608695","84","1.0","0","0.0","5153.0","5519.0","61.0","427.0","5092.0","1.0","1.0","0.0","20211020"
"9","4226","16","4201","0.0038086169959533444","25","4210","0.0059382422802850355","4185","0.9902981542830099","4185","1.0","29","0.006929510155316607","82660.0","83134.0","193.0","272.0","81419.0","0.9872918864515503","0.9825855036084091","-395.0","20211020"
"14","5903","1094","5665","0.19311562224183584","238","4809","0.049490538573508006","4571","0.7743520243943758","4556","0.9967184423539707","119","0.026119402985074626","258487.66000000003","229906.32000000007","41556.92","13039.250000000002","210794.07000000012","0.9717113858552276","0.9719966705871945","5.199999999999534","20211020"
"11","1352","31","1296","0.023919753086419752","56","1321","0.04239212717638153","1265","0.9356508875739645","1265","1.0","39","0.0308300395256917","20422.0","21116.0","344.0","642.0","19674.0","0.9798784739515888","0.9609260525544593","-396.0","20211021"
"15","8871","2655","8154","0.32560706401766004","717","6216","0.11534749034749035","5499","0.6198850185999324","5499","1.0","54","0.009819967266775777","143685.0","117466.0","40234.0","13207.0","101264.0","0.9788595566983402","0.9712734632022175","-808.0","20211021"
"1","21518","10","21152","0.00047276853252647505","366","21508","0.017016923935279895","21142","0.9825262570870898","21142","1.0","409","0.019345378866710814","681974.46","700134.46","302.0","8117.0","667762.46","0.9795943054527977","0.9649503063116356","-10345.0","20211021"
"2","2796","1","2771","0.00036088054853843375","25","2795","0.008944543828264758","2770","0.9907010014306151","2770","1.0","63","0.022743682310469315","30793.440000000002","31214.64","2.0","139.0","30142.239999999998","0.9789162182736499","0.969963611368905","-284.2","20211021"
"3","75","0","71","0.0","4","75","0.05333333333333334","71","0.9466666666666667","71","1.0","0","0.0","4269.0","4451.0","0.0","182.0","4269.0","1.0","1.0","0.0","20211021"
"9","4458","5","4427","0.00112943302462164","31","4453","0.006961598922075006","4422","0.9919246298788694","4422","1.0","20","0.004522840343735866","86786.0","87556.5","45.0","417.5","85948.0","0.9908578411593134","0.9863321819162487","-398.0","20211021"
"14","6204","1114","5894","0.18900576857821513","310","5090","0.060903732809430254","4780","0.7704706640876854","4766","0.997071129707113","129","0.027066722618548048","260303.93","239819.17999999993","46739.44000000001","26054.75999999999","207066.18000000005","0.9695721418855731","0.9686653185782746","52.940000000000595","20211021"
"11","672","31","631","0.0491283676703645","41","641","0.06396255850234009","600","0.8928571428571429","600","1.0","16","0.02666666666666667","11840.899999999998","12063.899999999998","549.0","648.0","11017.899999999998","0.9757348187638927","0.9651363449224327","-124.0","20211022"
"15","9078","2609","8352","0.3123802681992337","726","6469","0.11222754676147782","5743","0.6326283322317691","5743","1.0","63","0.010969876371234547","150799.0","122312.0","42472.0","13022.0","106420.0","0.982395893913798","0.9737395919114283","-963.0","20211022"
"1","21988","2","21601","0.00009258830609693995","387","21986","0.01760211043391249","21599","0.9823085319265054","21599","1.0","422","0.019537941571369045","674612.16","695041.16","40.0","8403.0","661646.16","0.9808382249276342","0.9636023724635403","-12066.0","20211022"
"2","2763","0","2732","0.0","31","2763","0.011219688744118711","2732","0.9887803112558813","2732","1.0","85","0.031112737920937043","31971.7","32553.7","0.0","155.0","30948.700000000004","0.9680029526112156","0.9552451178596674","-427.0","20211022"
"3","128","0","123","0.0","5","128","0.0390625","123","0.9609375","123","1.0","0","0.0","6224.0","6529.0","0.0","305.0","6224.0","1.0","1.0","0.0","20211022"
"9","4690","0","4647","0.0","43","4690","0.009168443496801706","4647","0.9908315565031983","4647","1.0","26","0.005595007531740908","92900.0","93971.0","0.0","572.0","92100.0","0.9913885898815931","0.9860919281791025","-499.0","20211022"
"14","6316","1092","5973","0.18282270215971874","343","5224","0.06565849923430321","4881","0.7727992400253325","4839","0.9913952059004303","138","0.02851828890266584","271485.61000000004","252403.71000000008","41492.98999999999","20720.809999999998","225100.02999999994","0.9787271869853906","0.9715867247863346","-786.6399999999993","20211022"
"1006","2","0","0","0.0","2","2","1.0","0","0.0","\N","\N","\N","\N","0.0","0.0","0.0","0.0","\N","\N","\N","\N","20211022"
"11","629","38","601","0.0632279534109817","28","591","0.047377326565143825","563","0.8950715421303657","563","1.0","25","0.04440497335701599","11139.819999999996","11399.819999999996","545.0","663.0","10058.819999999996","0.949409239609545","0.9368528111675524","-142.0","20211023"
"15","8466","2545","7816","0.3256141248720573","650","5921","0.1097787535889208","5271","0.6226080793763289","5271","1.0","79","0.014987668374122557","148669.0","119279.0","41484.0","11197.0","104905.0","0.9787283668423753","0.9706056512647805","-897.0","20211023"
"1","22119","5","21691","0.00023051034991471118","428","22114","0.0193542552229357","21686","0.9804240698042407","21686","1.0","386","0.017799501982846074","702564.1","722831.4","103.0","9850.3","690076.1","0.9823691304756946","0.9678743237373333","-10520.0","20211023"
"2","1532","0","1527","0.0","5","1532","0.0032637075718015664","1527","0.9967362924281984","1527","1.0","24","0.015717092337917484","14694.8","14779.8","0.0","17.0","14413.8","0.9808775893513352","0.9763594981981738","-68.0","20211023"
"3","183","0","177","0.0","6","183","0.03278688524590164","177","0.9672131147540983","177","1.0","1","0.005649717514124294","7841.0","8105.0","0.0","254.0","7836.0","0.9993623262338988","0.9980894153611005","-10.0","20211023"
"9","3519","0","3485","0.0","34","3519","0.00966183574879227","3485","0.9903381642512077","3485","1.0","23","0.006599713055954089","68733.0","69673.0","0.0","463.0","68003.0","0.9893791919456447","0.9825603236526513","-477.0","20211023"
"14","5929","440","5583","0.07881067526419487","346","5489","0.06303516123155402","5143","0.8674312700286726","5126","0.9966945362628816","182","0.035505267264923916","284561.82999999996","274760.49","28926.549999999996","19029.46","246815.06999999995","0.9654968985501531","0.9651354002680079","-472.57999999999953","20211023"
"1006","2","0","0","0.0","2","2","1.0","0","0.0","\N","\N","\N","\N","0.0","0.0","0.0","0.0","\N","\N","\N","\N","20211023"
"11","466","40","456","0.08771929824561403","10","426","0.023474178403755867","416","0.8927038626609443","416","1.0","13","0.03125","7374.0","6937.0","570.0","125.0","6544.0","0.9617871840094062","0.9606576629477392","-8.0","20211024"
"15","7232","2398","6701","0.3578570362632443","531","4834","0.10984691766652875","4303","0.5949944690265486","4303","1.0","53","0.012316988147803859","124111.0","96242.0","39651.0","10983.0","83579.0","0.9895690267582288","0.9802953353898122","-799.0","20211024"
"1","21488","4","21186","0.00018880392712168414","302","21484","0.014056972630795011","21182","0.9857594936708861","21182","1.0","352","0.0166178831082995","658460.7999999999","676492.7999999999","130.0","7403.0","645936.7999999999","0.9811735984401763","0.9653962741623022","-10759.0","20211024"
"2","1641","0","1636","0.0","5","1641","0.0030469226081657527","1636","0.9969530773918343","1636","1.0","27","0.01650366748166259","14920.92","15029.92","0.0","14.0","14604.92","0.9788216812368138","0.9726290497019163","-95.0","20211024"
"3","174","0","170","0.0","4","174","0.022988505747126436","170","0.9770114942528736","170","1.0","2","0.011764705882352941","7269.0","7538.0","0.0","244.0","7234.0","0.9951850323290686","0.9917740608719495","-25.0","20211024"
"9","3240","0","3219","0.0","21","3240","0.006481481481481481","3219","0.9935185185185185","3219","1.0","16","0.004970487729108419","64955.5","65491.5","0.0","276.0","64510.5","0.9931491559606191","0.9891896865009085","-260.0","20211024"
"14","5268","375","4987","0.07519550832163625","281","4893","0.05742898017576129","4612","0.8754745634016705","4586","0.9943625325238509","166","0.03619712167466201","265716.11","252731.34","27214.009999999995","12210.94","230903.69000000015","0.9681411190928725","0.9600170713170282","-489.39999999999986","20211024"
"11","463","63","435","0.14482758620689656","28","400","0.07","372","0.8034557235421166","372","1.0","12","0.03225806451612903","7417.0","6834.0","1030.0","406.0","6169.0","0.9658681697197432","0.959707529558183","-41.0","20211025"
"15","8048","2995","7474","0.4007225046829007","574","5053","0.11359588363348506","4479","0.5565357852882704","4479","1.0","31","0.006921187765126144","132733.0","96580.0","48718.0","11965.0","83359.0","0.9921918704993156","0.9851562961649826","-600.0","20211025"
"1","20128","1","19811","0.000050477007722982184","317","20127","0.01574998757887415","19810","0.9842011128775835","19810","1.0","284","0.014336193841494194","508589.5","523537.5","30.0","7109.0","500721.5","0.9845878407541301","0.9695853346591058","-7869.0","20211025"
"2","2494","1","2457","0.000407000407000407","37","2493","0.014841556357801846","2456","0.9847634322373697","2456","1.0","158","0.06433224755700326","24958.06","25484.06","1.0","106.0","23427.059999999998","0.9386947020201898","0.9231225712288487","-421.0","20211025"
"3","70","0","66","0.0","4","70","0.05714285714285714","66","0.9428571428571428","66","1.0","0","0.0","3618.0","3842.0","0.0","224.0","3618.0","1.0","1.0","0.0","20211025"
"9","3769","0","3746","0.0","23","3769","0.006102414433536747","3746","0.9938975855664632","3746","1.0","15","0.00400427122263748","61478.5","62031.5","0.0","270.0","61021.5","0.9925665069902486","0.9880184257182872","-283.0","20211025"
"14","5478","899","5089","0.1766555315386127","389","4579","0.08495304651670671","4190","0.764877692588536","4161","0.9930787589498806","104","0.024993991828887285","244916.95000000007","254764.1400000001","35086.880000000005","44712.20000000001","204524.94999999987","0.9747170650993912","0.9736875079563644","484.35999999999916","20211025"
"11","549","48","510","0.09411764705882353","39","501","0.07784431137724551","462","0.8415300546448088","462","1.0","14","0.030303030303030304","9239.0","9119.0","776.0","680.0","8128.0","0.9604159281578637","0.9631472923332148","24.0","20211026"
"15","9431","3349","8747","0.3828741282725506","684","6082","0.11246300559026635","5398","0.5723677234651681","5398","1.0","44","0.008151167098925528","147748.0","106924.0","53384.0","11823.0","93319.0","0.9889258615573736","0.9812620266874166","-737.0","20211026"
"1","20157","0","19816","0.0","341","20157","0.016917199980155777","19816","0.9830828000198443","19816","1.0","313","0.015795316915623737","505065.39999999997","522455.19999999995","0.0","7476.8","495692.39999999997","0.9814420073123203","0.9625498855874344","-9913.0","20211026"
"2","2867","0","2846","0.0","21","2867","0.007324729682595047","2846","0.992675270317405","2846","1.0","88","0.030920590302178495","25704.64","26151.64","0.0","104.0","24443.64","0.9509427091762421","0.9384205248536912","-343.0","20211026"
"3","76","0","73","0.0","3","76","0.039473684210526314","73","0.9605263157894737","73","1.0","0","0.0","4036.0","4204.0","0.0","168.0","4036.0","1.0","1.0","0.0","20211026"
"9","4056","0","4039","0.0","17","4056","0.004191321499013806","4039","0.9958086785009862","4039","1.0","10","0.0024758603614756128","64221.5","64606.0","0.0","192.5","63925.5","0.9953909516283488","0.9924239483959107","-192.0","20211026"
"14","5719","944","5510","0.17132486388384754","209","4775","0.0437696335078534","4566","0.7983913271550971","4533","0.992772667542707","126","0.027796161482461945","264798.6799999999","245003.39999999994","34724.79","14271.89","224942.54000000012","0.9776969477066705","0.974910362264782","377.64000000000055","20211026"
"11","415","58","401","0.14463840399002495","14","357","0.0392156862745098","343","0.8265060240963855","343","1.0","15","0.043731778425655975","6242.0","5556.0","822.0","177.0","5030.0","0.9280442804428044","0.9351180516824689","41.0","20211027"
"15","10356","3441","9680","0.3554752066115702","676","6915","0.0977584960231381","6239","0.6024526844341445","6239","1.0","54","0.008655233210450393","165186.0","123180.0","53726.0","11203.0","110173.0","0.9884532567737305","0.9838895487466176","-517.0","20211027"
"1","20598","2","20251","0.0000987605550343193","347","20596","0.01684793163721111","20249","0.9830566074376152","20249","1.0","314","0.015506938614252556","508077.3","523909.3","15.0","7661.0","499678.3","0.9834980867503847","0.9679030420051746","-8186.0","20211027"
"2","2645","0","2621","0.0","24","2645","0.009073724007561436","2621","0.9909262759924385","2621","1.0","79","0.03014116749332316","23711.739999999998","24125.939999999995","0.0","108.5","22746.24","0.9592817735012278","0.9470717944959999","-305.7","20211027"
"3","98","0","94","0.0","4","98","0.04081632653061224","94","0.9591836734693877","94","1.0","0","0.0","5186.0","5410.0","0.0","224.0","5186.0","1.0","1.0","0.0","20211027"
"9","4070","0","4044","0.0","26","4070","0.0063882063882063885","4044","0.9936117936117936","4044","1.0","11","0.0027200791295746785","62923.0","63403.5","0.0","305.5","62673.0","0.996026890008423","0.9932644457827506","-175.0","20211027"
"14","5142","770","4899","0.1571749336599306","243","4372","0.05558096980786825","4129","0.8029949436017114","4087","0.9898280455316057","127","0.031074137509175433","253201.87","239744.47999999998","30509.27","16822.47","215621.08999999985","0.9682454199196554","0.9672489943904591","467.2100000000016","20211027"
"11","492","48","437","0.10983981693363844","55","444","0.12387387387387387","389","0.790650406504065","389","1.0","9","0.02313624678663239","7261.0","10085.0","820.0","3642.0","6239.0","0.9686384101847539","0.9683377308707124","-2.0","20211028"
"15","9971","3216","9241","0.34801428416838004","730","6755","0.1080680977054034","6025","0.6042523317621101","6025","1.0","54","0.008962655601659751","157776.0","120708.0","49138.0","11529.0","107430.0","0.9888805022183766","0.983980435798093","-541.0","20211028"
"1","20643","0","20297","0.0","346","20643","0.016761129680763456","20297","0.9832388703192365","20297","1.0","286","0.014090752327930237","524355.7","539973.7","0.0","7966.0","516181.69999999995","0.9844113451994514","0.9702523102579155","-7652.0","20211028"
"2","2796","0","2727","0.0","69","2796","0.02467811158798283","2727","0.9753218884120172","2727","1.0","81","0.0297029702970297","25097.76","26063.46","0.0","612.0","24171.559999999998","0.9630963081964287","0.9497121186760995","-353.7","20211028"
"3","88","0","75","0.0","13","88","0.14772727272727273","75","0.8522727272727273","75","1.0","0","0.0","4122.0","5202.0","0.0","1080.0","4122.0","1.0","1.0","0.0","20211028"
"9","4413","1","4390","0.00022779043280182233","23","4412","0.005213055303717135","4389","0.9945615227736234","4389","1.0","14","0.003189792663476874","69609.0","70114.0","5.0","277.0","69357.0","0.996451353370496","0.9931268525280296","-233.0","20211028"
"14","5491","838","5320","0.1575187969924812","171","4653","0.0367504835589942","4482","0.8162447641595337","4432","0.9888442659526997","162","0.03655234657039711","277473.42000000016","254809.49000000002","34327.200000000004","11513.499999999998","235426.6200000001","0.9682512029181451","0.9676551594623491","977.4099999999999","20211028"
"11","433","52","401","0.12967581047381546","32","381","0.08398950131233596","349","0.8060046189376443","349","1.0","13","0.03724928366762178","6203.0","5760.0","851.0","364.0","5112.0","0.9551569506726457","0.9473684210526315","-44.0","20211029"
"15","9971","3289","9106","0.3611904238963321","865","6682","0.12945225980245437","5817","0.5833918363253435","5817","1.0","85","0.014612343132198728","158763.0","123005.0","51391.0","14649.0","105829.0","0.9856294005886078","0.9766787256820112","-984.0","20211029"
"1","23275","2","22678","0.00008819119851838787","597","23273","0.02565204314011945","22676","0.9742642320085929","22676","1.0","524","0.02310813194566943","600047.7","625192.3","15.0","11098.6","585026.7","0.9749913629707181","0.9526668324394142","-14061.0","20211029"
"2","2846","0","2728","0.0","118","2846","0.04146170063246662","2728","0.9585382993675334","2728","1.0","129","0.04728739002932551","25465.699999999997","26327.299999999996","0.0","367.5","24084.800000000003","0.945774119698261","0.9277729412399174","-494.1","20211029"
"3","185","0","174","0.0","11","185","0.05945945945945946","174","0.9405405405405406","174","1.0","4","0.022988505747126436","7308.0","7954.0","0.0","616.0","7268.0","0.9945265462506842","0.9904606159716544","-30.0","20211029"
"9","4603","0","4524","0.0","79","4603","0.01716271996524006","4524","0.9828372800347599","4524","1.0","21","0.004641909814323607","73786.0","75000.0","0.0","877.0","73248.0","0.9927086439161901","0.9881952970063274","-337.0","20211029"
"14","5594","842","5226","0.16111748947569843","368","4752","0.07744107744107744","4384","0.7836968180193064","4370","0.9968065693430657","363","0.08306636155606408","261567.07999999996","246304.25999999998","35358.869999999995","18496.4","206310.70000000007","0.9120389573835543","0.9056346870560132","-1606.2099999999996","20211029"
"11","304","2","294","0.006802721088435374","10","302","0.033112582781456956","292","0.9605263157894737","292","1.0","8","0.0273972602739726","4912.0","5017.0","23.0","113.0","4744.0","0.9703415831458376","0.967373572593801","-15.0","20211030"
"15","9370","3141","8645","0.3633314054366686","725","6229","0.11639107400866913","5504","0.5874066168623265","5504","1.0","60","0.010901162790697675","157066.0","118657.0","52894.0","14002.0","102800.0","0.9868294743309143","0.9822750943576514","-483.0","20211030"
"1","26769","1","26337","0.00003796939666628697","432","26768","0.016138673042438732","26336","0.9838245732003437","26336","1.0","492","0.018681652490886998","788334.8","813566.6","5.0","10189.8","770361.8","0.9772075088370374","0.9589047132055595","-15047.0","20211030"
"2","2421","1","2401","0.00041649312786339027","20","2420","0.008264462809917356","2400","0.9913258983890955","2400","1.0","83","0.034583333333333334","24860.92","25167.92","3.0","72.0","23192.92","0.9330193354874422","0.9241709409338251","-238.0","20211030"
"3","254","0","243","0.0","11","254","0.04330708661417323","243","0.9566929133858267","243","1.0","4","0.01646090534979424","11185.0","11854.0","0.0","559.0","11100.0","0.9924005364327224","0.9827357237715804","-110.0","20211030"
"9","7280","0","7233","0.0","47","7280","0.006456043956043956","7233","0.9935439560439561","7233","1.0","13","0.0017973178487487903","93302.0","94108.0","0.0","598.0","92928.0","0.9959915114359821","0.993776066730831","-208.0","20211030"
"14","5652","457","5285","0.08647114474929045","367","5195","0.07064485081809432","4828","0.854210898796886","4801","0.9944076222038111","214","0.04457404707352635","310668.68000000005","298577.7700000001","32284.309999999998","18998.030000000002","266392.1799999999","0.9569221864000477","0.952830773789259","-616.6799999999996","20211030"
"1006","28","0","0","0.0","28","28","1.0","0","0.0","\N","\N","\N","\N","0.0","130.0","0.0","130.0","\N","\N","\N","\N","20211030"
"11","340","1","329","0.00303951367781155","11","339","0.032448377581120944","328","0.9647058823529412","328","1.0","8","0.024390243902439025","6241.0","6444.0","15.0","173.0","6073.0","0.9754256344362351","0.968426088343167","-45.0","20211031"
"15","7544","2833","6947","0.4078019288901684","597","4711","0.126724686902993","4114","0.5453340402969247","4114","1.0","42","0.010209042294603793","136221.0","104198.0","44831.0","12217.0","90176.0","0.9867162709267973","0.9803763820789076","-591.0","20211031"
"1","22980","1","22634","0.00004418132013784572","346","22979","0.015057226163018408","22633","0.9848999129677981","22633","1.0","354","0.015640878363451596","715162.8","733781.6","12.0","8118.8","702861.8","0.982816211629771","0.968579070058435","-10512.0","20211031"
"2","1941","0","1927","0.0","14","1941","0.0072127769191138585","1927","0.9927872230808862","1927","1.0","91","0.04722366372599896","20904.2","21261.2","0.0","44.0","18637.2","0.8915528936768687","0.8784005429557151","-313.0","20211031"
"3","226","0","217","0.0","9","226","0.03982300884955752","217","0.9601769911504425","217","1.0","4","0.018433179723502304","7944.0","8369.0","0.0","325.0","7854.0","0.9886706948640483","0.9763799104922924","-100.0","20211031"
"9","4471","1","4442","0.00022512381809995497","29","4470","0.006487695749440716","4441","0.99329009170208","4441","1.0","22","0.004953839225399685","74864.0","75672.0","16.0","369.0","74170.0","0.9909416417272339","0.9849541186938103","-455.0","20211031"
"14","5153","406","4822","0.08419742845292409","331","4747","0.06972824942068676","4416","0.8569765185328935","4369","0.9893568840579711","203","0.046463721675440606","292851.9700000002","284822.7200000002","27872.78","20288.199999999997","253299.20000000004","0.9559211045969304","0.9575279627021829","1029.139999999999","20211031"
"1006","29","0","0","0.0","29","29","1.0","0","0.0","\N","\N","\N","\N","0.0","80.0","0.0","80.0","\N","\N","\N","\N","20211031"
"11","404","1","393","0.002544529262086514","11","403","0.02729528535980149","392","0.9702970297029703","392","1.0","5","0.012755102040816327","8439.0","8685.0","8.0","183.0","8321.0","0.9869529118728502","0.9787108915549283","-71.0","20211101"
"15","7052","2396","6461","0.37084042717845533","591","4656","0.12693298969072164","4065","0.5764322178105502","4065","1.0","47","0.011562115621156211","117349.0","90760.0","38488.0","11463.0","77819.0","0.9867868781780601","0.9813612116473511","-436.0","20211101"
"1","19954","0","19658","0.0","296","19954","0.01483411847248672","19658","0.9851658815275133","19658","1.0","345","0.017550106826737206","542756.6","559817.6","0.0","7337.0","531762.6000000001","0.9797441431389321","0.9625000407254121","-9724.0","20211101"
"2","2699","0","2659","0.0","40","2699","0.014820303816228233","2659","0.9851796961837718","2659","1.0","106","0.03986461075592328","35999.68","36517.68","0.0","103.0","33750.68","0.9375272224641997","0.9268426909147629","-415.0","20211101"
"3","146","0","138","0.0","8","146","0.0547945205479452","138","0.9452054794520548","138","1.0","0","0.0","6324.0","6788.0","0.0","464.0","6324.0","1.0","1.0","0.0","20211101"
"9","4733","0","4708","0.0","25","4733","0.005282062117050497","4708","0.9947179378829495","4708","1.0","23","0.004885301614273577","72219.0","72978.0","0.0","307.0","71618.0","0.9916780902532575","0.985510038392206","-452.0","20211101"
"14","5665","839","5276","0.15902198635329795","389","4826","0.080605055946954","4437","0.7832303618711386","4419","0.9959432048681541","149","0.03371803575469563","276066.92000000004","281598.2800000001","35603.64","38967.23000000001","233091.68000000005","0.9693441759590072","0.9606836388005574","-1395.16","20211101"
"1006","56","0","0","0.0","56","56","1.0","0","0.0","\N","\N","\N","\N","0.0","240.0","0.0","240.0","\N","\N","\N","\N","20211101"
"11","454","0","434","0.0","20","454","0.04405286343612335","434","0.9559471365638766","434","1.0","18","0.041474654377880185","9919.0","10462.0","0.0","350.0","9568.0","0.9646133682830931","0.9462025316455697","-193.0","20211102"
"15","7947","2528","7345","0.3441797140912185","602","5419","0.11109060712308544","4817","0.6061406820183717","4817","1.0","57","0.011833091135561552","126773.0","99539.0","38747.0","11019.0","86679.0","0.9846977029514007","0.9792024401265251","-494.0","20211102"
"1","19288","1","18975","0.00005270092226613966","313","19287","0.016228547726447867","18974","0.98372044794691","18974","1.0","284","0.014967850743122168","504510.0","519864.0","20.0","7179.0","495772.0","0.9827191817479038","0.9670109326389499","-8195.0","20211102"
"2","2748","0","2690","0.0","58","2748","0.021106259097525473","2690","0.9788937409024745","2690","1.0","102","0.0379182156133829","29115.760000000002","29632.76","0.0","126.0","27473.260000000002","0.9435872530890487","0.9310835889809659","-391.0","20211102"
"3","156","0","148","0.0","8","156","0.05128205128205128","148","0.9487179487179487","148","1.0","2","0.013513513513513514","5643.0","6008.0","0.0","345.0","5613.0","0.9946836788942052","0.9911707575490023","-20.0","20211102"
"9","5673","0","5637","0.0","36","5673","0.006345848757271285","5637","0.9936541512427287","5637","1.0","19","0.0033705871917686712","86295.0","86981.0","0.0","399.0","85811.0","0.9943913320586361","0.9910951467972557","-287.0","20211102"
"14","5490","764","5249","0.14555153362545248","241","4726","0.05099449851883199","4485","0.8169398907103825","4470","0.9966555183946488","129","0.028859060402684565","267343.18999999994","253383.75000000015","32949.9","19432.59","226622.03000000006","0.966845211311297","0.9686723929900579","740.919999999999","20211102"
"1006","69","0","0","0.0","69","69","1.0","0","0.0","\N","\N","\N","\N","0.0","480.0","0.0","480.0","\N","\N","\N","\N","20211102"