{"columns":[{"alerts":[{"code":"long_tail","level":"info","message":"500 singleton categories"}],"column":"title","extras":{"singletons":500,"top_values":[["1989_Tiananmen_Square_protests_and_massacre",1],[".xxx",1],["Wikipedia:Featured_pictures",1],["Dhurandhar",1],["Avatar:_Fire_and_Ash",1],["Nicol\u00e1s_Maduro",1],["Stranger_Things",1],["Marty_Supreme",1],["Stranger_Things_season_5",1],["List_of_highest-grossing_Indian_films",1],["Bruce_Lee",1],["Heated_Rivalry",1],["Venezuela",1],["One_Battle_After_Another",1],["Donald_Trump",1],["ChatGPT",1],["Brigitte_Bardot",1],["Pluribus_(TV_series)",1],["The_Housemaid_(2025_film)",1],["Google_Chrome",1]]},"kind":"categorical","n":500,"n_null":0,"n_unique":500,"null_rate":0.0,"stats":{"cardinality":500,"entropy":8.965784284662087,"entropy_ratio":1.0,"top_rate":0.002,"top_value":"1989_Tiananmen_Square_protests_and_massacre"}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+10.44"},{"code":"outliers","level":"warn","message":"10.2% rows beyond 1.5 IQR"}],"column":"total_views","extras":{"histogram":{"counts":[449,27,13,4,1,1,1,2,0,1,0,0,0,0,0,0,0,0,0,0,0,1],"edges":[76451.0,1158889.6818181819,2241328.3636363638,3323767.045454546,4406205.7272727275,5488644.409090909,6571083.090909092,7653521.772727273,8735960.454545455,9818399.136363637,10900837.818181818,11983276.5,13065715.181818184,14148153.863636365,15230592.545454547,16313031.227272728,17395469.90909091,18477908.590909094,19560347.272727273,20642785.954545457,21725224.636363637,22807663.31818182,23890102.0]},"sample":[23890102.0,10074568.0,8273254.0,7842126.0,6851540.0,5663212.0,4470347.0,3654173.0,3645501.0,3577606.0,3417919.0,3171066.0,3081219.0,2869637.0,2840889.0,2818925.0,2638867.0,2513230.0,2430411.0,2413933.0,2403611.0,2376580.0,2374505.0,2265364.0,2235116.0,2032615.0,2002303.0,1989974.0,1910229.0,1802926.0,1783743.0,1720189.0,1719259.0,1654936.0,1642374.0,1618528.0,1609970.0,1587757.0,1513734.0,1456712.0,1434792.0,1411319.0,1333987.0,1279994.0,1276887.0,1219862.0,1212261.0,1204500.0,1187311.0,1185555.0,1169570.0,1156590.0,1142743.0,1128346.0,1087604.0,1081549.0,1071947.0,1067580.0,1066496.0,1038968.0,1022169.0,990318.0,981683.0,981156.0,977637.0,974194.0,958781.0,951502.0,949308.0,941111.0,932325.0,929799.0,924573.0,917735.0,903123.0,899150.0,880491.0,878545.0,862828.0,833403.0,832799.0,832394.0,819343.0,818422.0,812322.0,810706.0,798303.0,797549.0,797125.0,793113.0,790230.0,761478.0,756729.0,749773.0,725442.0,725353.0,718169.0,717781.0,695668.0,685621.0,682633.0,681172.0,635998.0,629550.0,626544.0,624334.0,615470.0,611555.0,609399.0,608934.0,606610.0,601289.0,595366.0,593367.0,591728.0,582969.0,582015.0,574874.0,574342.0,568874.0,568104.0,567735.0,564945.0,553148.0,539568.0,533776.0,529890.0,528452.0,520260.0,519823.0,508981.0,500562.0,500411.0,494524.0,483554.0,483360.0,482481.0,474293.0,471334.0,468645.0,467169.0,466549.0,466132.0,462502.0,445037.0,444606.0,443786.0,437496.0,436329.0,431623.0,426178.0,425534.0,424520.0,423676.0,423277.0,418251.0,413002.0,412486.0,410704.0,398263.0,396310.0,392847.0,388830.0,388366.0,387955.0,386181.0,378488.0,375646.0,366514.0,363582.0,362701.0,359465.0,358935.0,351281.0,350920.0,348614.0,347345.0,347176.0,340266.0,337376.0,336945.0,329152.0,326003.0,324113.0,314886.0,313217.0,311870.0,309162.0,307993.0,304762.0,303211.0,298173.0,297685.0,293316.0,290103.0,289576.0,288831.0,288749.0,288288.0,288039.0,286822.0,284402.0,283380.0,282330.0,281422.0,277745.0,275791.0,275284.0,271177.0,271007.0,269573.0,269502.0,268881.0,265897.0,264918.0,264894.0,262648.0,260858.0,258559.0,252526.0,251794.0,250762.0,250006.0,249666.0,243180.0,242003.0,241160.0,239793.0,239658.0,238968.0,238477.0,236408.0,236290.0,234688.0,233090.0,232024.0,230698.0,230257.0,229270.0,228978.0,227070.0,227043.0,223781.0,223326.0,220651.0,220136.0,219113.0,217253.0,214587.0,214425.0,211705.0,209661.0,208260.0,207277.0,206606.0,206501.0,206263.0,205891.0,205457.0,205216.0,203441.0,202881.0,201215.0,201192.0,200766.0,200487.0,199894.0,192658.0,191180.0,187204.0,186274.0,183921.0,183439.0,183025.0,182690.0,181967.0,177450.0,176816.0,176787.0,175944.0,174125.0,173999.0,173730.0,173165.0,172848.0,168450.0,167789.0,167663.0,167604.0,167158.0,166812.0,166754.0,166701.0,166689.0,166154.0,165781.0,165585.0,163335.0,162235.0,161319.0,161190.0,160265.0,160044.0,159709.0,159341.0,158959.0,158142.0,157878.0,157288.0,156350.0,154113.0,153698.0,153274.0,151311.0,150996.0,150806.0,150430.0,150191.0,149819.0,149747.0,148666.0,148600.0,147820.0,146357.0,146113.0,146016.0,145106.0,142155.0,141847.0,141197.0,140784.0,140325.0,140133.0,139899.0,139423.0,139202.0,138694.0,138667.0,138531.0,136264.0,135980.0,134590.0,133815.0,132802.0,132130.0,132120.0,132023.0,131808.0,129698.0,129065.0,128320.0,127217.0,126043.0,126040.0,123629.0,123308.0,123110.0,122119.0,121917.0,121889.0,121608.0,121448.0,120761.0,120733.0,120475.0,120103.0,120099.0,119165.0,117129.0,116156.0,115859.0,115836.0,115546.0,115176.0,115122.0,114959.0,114023.0,113169.0,112854.0,112844.0,112426.0,111258.0,111050.0,111021.0,110738.0,110572.0,110505.0,110194.0,110182.0,110157.0,109975.0,109889.0,109593.0,109580.0,109445.0,109338.0,109313.0,108744.0,108528.0,108282.0,108233.0,107857.0,106672.0,106434.0,106424.0,106088.0,105803.0,105349.0,105300.0,105159.0,104860.0,104249.0,103901.0,103154.0,102732.0,102396.0,102368.0,102292.0,102141.0,102044.0,101829.0,101684.0,101447.0,101188.0,98920.0,98148.0,98084.0,98029.0,97993.0,97968.0,97580.0,96499.0,95528.0,95248.0,94969.0,94889.0,94715.0,93577.0,93531.0,93414.0,93393.0,92957.0,92825.0,92547.0,92320.0,92084.0,92031.0,91425.0,91035.0,90289.0,90075.0,88986.0,88944.0,88880.0,88768.0,88639.0,88551.0,88136.0,87659.0,87619.0,87473.0,87359.0,86960.0,86939.0,86719.0,86146.0,86051.0,85626.0,85619.0,85528.0,85423.0,84724.0,84588.0,84392.0,84210.0,83955.0,83895.0,83557.0,83155.0,82910.0,82545.0,82032.0,81930.0,81339.0,80856.0,80734.0,80617.0,80502.0,80413.0,80304.0,79927.0,79804.0,79413.0,79407.0,78630.0,78589.0,78277.0,77438.0,76598.0,76451.0]},"kind":"numeric","n":500,"n_null":0,"n_unique":500,"null_rate":0.0,"stats":{"iqr":420142.75,"kurtosis":149.65862121651682,"max":23890102.0,"mean":580331.36,"median":213065.0,"min":76451.0,"n_outliers":51,"outlier_rate":0.102,"q1":115081.25,"q3":535224.0,"skew":10.439667232347285,"std":1424122.9006263383,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+2.45"},{"code":"outliers","level":"warn","message":"11.2% rows beyond 1.5 IQR"}],"column":"days_in_top_100","extras":{"histogram":{"counts":[247,60,47,35,12,11,17,9,6,18,5,5,2,2,0,5,1,0,3,0,1,14],"edges":[1.0,2.3181818181818183,3.6363636363636362,4.954545454545454,6.2727272727272725,7.590909090909091,8.909090909090908,10.227272727272727,11.545454545454545,12.863636363636363,14.181818181818182,15.5,16.818181818181817,18.136363636363637,19.454545454545453,20.772727272727273,22.09090909090909,23.409090909090907,24.727272727272727,26.045454545454543,27.363636363636363,28.68181818181818,30.0]},"sample":[16.0,28.0,30.0,30.0,30.0,10.0,30.0,30.0,22.0,30.0,30.0,30.0,13.0,30.0,23.0,30.0,6.0,29.0,30.0,15.0,14.0,7.0,29.0,18.0,25.0,9.0,6.0,12.0,13.0,26.0,17.0,12.0,29.0,22.0,11.0,16.0,25.0,13.0,13.0,21.0,7.0,19.0,14.0,6.0,11.0,7.0,15.0,9.0,5.0,13.0,15.0,4.0,6.0,14.0,6.0,8.0,16.0,19.0,5.0,22.0,11.0,4.0,14.0,4.0,4.0,13.0,15.0,13.0,11.0,6.0,13.0,7.0,12.0,21.0,3.0,4.0,14.0,13.0,16.0,4.0,3.0,6.0,13.0,9.0,9.0,11.0,12.0,16.0,10.0,9.0,15.0,12.0,6.0,14.0,9.0,3.0,6.0,11.0,10.0,3.0,8.0,7.0,3.0,3.0,14.0,4.0,6.0,9.0,4.0,14.0,8.0,4.0,5.0,12.0,8.0,10.0,11.0,11.0,8.0,6.0,7.0,6.0,3.0,6.0,3.0,8.0,4.0,9.0,4.0,9.0,6.0,9.0,7.0,11.0,8.0,6.0,5.0,10.0,7.0,3.0,4.0,4.0,8.0,4.0,7.0,4.0,5.0,7.0,6.0,9.0,4.0,8.0,6.0,3.0,1.0,4.0,5.0,5.0,2.0,3.0,7.0,8.0,7.0,3.0,9.0,4.0,2.0,5.0,3.0,6.0,4.0,4.0,2.0,5.0,4.0,8.0,4.0,6.0,6.0,2.0,4.0,3.0,5.0,2.0,3.0,3.0,4.0,3.0,2.0,3.0,2.0,2.0,4.0,2.0,3.0,6.0,3.0,2.0,4.0,2.0,3.0,5.0,3.0,4.0,4.0,2.0,2.0,4.0,2.0,2.0,4.0,3.0,5.0,4.0,4.0,3.0,1.0,3.0,3.0,2.0,4.0,4.0,1.0,5.0,2.0,2.0,3.0,3.0,3.0,2.0,3.0,2.0,2.0,2.0,2.0,3.0,5.0,4.0,2.0,3.0,2.0,2.0,3.0,1.0,2.0,4.0,2.0,3.0,4.0,3.0,4.0,2.0,4.0,3.0,2.0,2.0,2.0,3.0,1.0,1.0,3.0,2.0,2.0,4.0,4.0,2.0,2.0,2.0,2.0,3.0,2.0,2.0,3.0,2.0,4.0,2.0,2.0,3.0,2.0,4.0,2.0,4.0,3.0,4.0,2.0,3.0,3.0,2.0,2.0,2.0,2.0,2.0,3.0,3.0,4.0,4.0,2.0,2.0,2.0,1.0,3.0,3.0,2.0,2.0,2.0,2.0,3.0,2.0,2.0,2.0,3.0,2.0,2.0,2.0,2.0,1.0,2.0,2.0,2.0,3.0,2.0,1.0,1.0,2.0,2.0,2.0,1.0,2.0,2.0,2.0,2.0,3.0,3.0,2.0,1.0,3.0,2.0,2.0,3.0,1.0,2.0,2.0,3.0,3.0,2.0,2.0,1.0,2.0,3.0,2.0,2.0,2.0,1.0,1.0,2.0,2.0,3.0,2.0,1.0,1.0,3.0,2.0,2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,2.0,1.0,2.0,2.0,2.0,1.0,1.0,1.0,1.0,1.0,2.0,1.0,2.0,1.0,2.0,2.0,2.0,1.0,2.0,1.0,2.0,2.0,2.0,2.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,1.0,2.0,1.0,2.0,2.0,1.0,1.0,1.0,2.0,1.0,1.0,2.0,1.0,2.0,1.0,1.0,1.0,1.0,2.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,1.0,2.0,2.0,2.0,1.0,1.0,2.0,1.0,2.0,1.0,2.0,2.0,2.0,1.0,1.0,2.0,1.0,2.0,2.0,1.0,2.0,2.0,1.0,1.0,1.0,1.0,1.0,2.0,2.0,2.0,1.0,2.0,1.0,1.0,2.0,1.0,2.0,1.0,2.0,1.0,1.0,1.0,1.0,2.0,1.0,1.0,1.0,1.0,2.0,2.0,2.0,1.0,1.0,1.0,2.0,1.0,2.0,2.0,1.0,1.0,1.0,2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0]},"kind":"numeric","n":500,"n_null":0,"n_unique":27,"null_rate":0.0,"stats":{"iqr":4.0,"kurtosis":5.978845763463015,"max":30.0,"mean":5.176,"median":3.0,"min":1.0,"n_outliers":56,"outlier_rate":0.112,"q1":2.0,"q3":6.0,"skew":2.449124499297251,"std":6.238819579013241,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+9.71"},{"code":"outliers","level":"warn","message":"11.4% rows beyond 1.5 IQR"}],"column":"peak_views","extras":{"histogram":{"counts":[430,38,19,5,1,3,2,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1],"edges":[40332.0,220818.9090909091,401305.8181818182,581792.7272727273,762279.6363636364,942766.5454545454,1123253.4545454546,1303740.3636363635,1484227.2727272727,1664714.1818181819,1845201.0909090908,2025688.0,2206174.909090909,2386661.8181818184,2567148.727272727,2747635.6363636362,2928122.5454545454,3108609.4545454546,3289096.3636363638,3469583.2727272725,3650070.1818181816,3830557.090909091,4011044.0]},"sample":[4011044.0,1202415.0,293060.0,443234.0,495513.0,2519497.0,579366.0,253908.0,629625.0,165331.0,119519.0,167380.0,1001203.0,330706.0,739258.0,113287.0,1185770.0,166173.0,112259.0,292638.0,312200.0,952506.0,134936.0,136690.0,212003.0,886740.0,955251.0,443079.0,166254.0,166851.0,139794.0,669249.0,85504.0,145925.0,324596.0,141864.0,129880.0,180522.0,413673.0,213501.0,461877.0,135492.0,273263.0,455223.0,171444.0,301629.0,182947.0,313450.0,537971.0,141919.0,117391.0,678268.0,527246.0,165611.0,445569.0,229467.0,110594.0,124512.0,578274.0,51579.0,138447.0,480508.0,98785.0,552272.0,409546.0,122824.0,85968.0,109672.0,356895.0,190807.0,265031.0,259792.0,169580.0,48809.0,385900.0,406375.0,105900.0,107896.0,90277.0,340209.0,687909.0,261464.0,106711.0,173333.0,135623.0,124350.0,99403.0,61918.0,129296.0,113955.0,59001.0,101834.0,278201.0,87776.0,141874.0,512266.0,227750.0,101851.0,97289.0,545297.0,137903.0,262069.0,299689.0,390620.0,51748.0,381321.0,211946.0,110178.0,299812.0,51175.0,104357.0,252431.0,198159.0,119902.0,96600.0,89740.0,68117.0,76779.0,164137.0,146999.0,157296.0,182289.0,354525.0,123324.0,426938.0,139917.0,256115.0,91739.0,239674.0,82831.0,129355.0,82347.0,100228.0,55605.0,98751.0,124929.0,205336.0,63787.0,76050.0,273245.0,150638.0,231881.0,86869.0,203651.0,100357.0,158737.0,115755.0,87170.0,180360.0,49810.0,191942.0,73579.0,89310.0,198908.0,423277.0,190578.0,90779.0,100179.0,265044.0,187703.0,87881.0,65237.0,74932.0,164140.0,49244.0,130326.0,270664.0,105741.0,200063.0,89195.0,192401.0,166044.0,211869.0,95783.0,176601.0,52002.0,126572.0,68301.0,79012.0,228244.0,103131.0,207968.0,102070.0,205851.0,136630.0,146659.0,120029.0,134256.0,164822.0,183928.0,241473.0,225608.0,112899.0,228923.0,149537.0,57832.0,126736.0,148042.0,81788.0,178193.0,167198.0,71525.0,134509.0,94435.0,88098.0,205744.0,168369.0,115859.0,209357.0,190339.0,84665.0,129223.0,66203.0,87001.0,91318.0,127488.0,262648.0,143449.0,116326.0,144988.0,112258.0,83662.0,250006.0,61982.0,128031.0,195859.0,134644.0,115600.0,102532.0,183416.0,92332.0,173666.0,133524.0,141961.0,128508.0,111226.0,59677.0,75278.0,118622.0,131507.0,131419.0,166172.0,98007.0,223326.0,148697.0,61052.0,162965.0,100785.0,59211.0,113557.0,59099.0,155310.0,58062.0,110961.0,145185.0,147343.0,143632.0,96696.0,205457.0,205216.0,104746.0,123778.0,133941.0,58663.0,70772.0,117361.0,119691.0,125259.0,102360.0,72620.0,129050.0,126177.0,73892.0,130892.0,52121.0,109535.0,104839.0,78711.0,102039.0,51165.0,131984.0,47800.0,91189.0,48864.0,99111.0,75931.0,66143.0,97908.0,108576.0,116102.0,107483.0,100247.0,65329.0,63727.0,46890.0,44549.0,106357.0,110906.0,105855.0,161319.0,71788.0,61922.0,106870.0,101090.0,105526.0,88385.0,61569.0,102558.0,117339.0,107691.0,61889.0,96976.0,78741.0,105058.0,88695.0,150806.0,90245.0,101152.0,95641.0,60277.0,83727.0,148600.0,147820.0,94851.0,92534.0,75151.0,145106.0,76905.0,99689.0,80341.0,90611.0,51937.0,52179.0,81639.0,139423.0,48364.0,81196.0,84437.0,55250.0,136264.0,88616.0,93320.0,49714.0,51050.0,88687.0,80211.0,132023.0,76662.0,50241.0,81190.0,81345.0,84726.0,126043.0,126040.0,80176.0,73613.0,44121.0,80588.0,121917.0,121889.0,42252.0,70136.0,79169.0,120733.0,120475.0,120103.0,120099.0,119165.0,117129.0,116156.0,60427.0,69231.0,115546.0,58615.0,64567.0,63356.0,114023.0,113169.0,112854.0,112844.0,112426.0,72813.0,111050.0,69068.0,110738.0,65425.0,62508.0,68277.0,110182.0,56631.0,109975.0,64905.0,57770.0,56704.0,61683.0,109338.0,63556.0,62026.0,57495.0,64643.0,62310.0,59032.0,106672.0,62777.0,106424.0,53144.0,54787.0,105349.0,105300.0,105159.0,52483.0,104249.0,103901.0,58947.0,102732.0,58288.0,102368.0,102292.0,102141.0,102044.0,52175.0,101684.0,60277.0,59791.0,61924.0,53089.0,56095.0,58679.0,97993.0,58549.0,58126.0,51417.0,95528.0,95248.0,52503.0,94889.0,50703.0,93577.0,56101.0,53716.0,49732.0,92957.0,92825.0,51069.0,92320.0,51527.0,51525.0,91425.0,47893.0,46081.0,90075.0,88986.0,88944.0,88880.0,88768.0,49253.0,48784.0,44888.0,87659.0,51066.0,87473.0,87359.0,44543.0,86939.0,44979.0,86146.0,47664.0,85626.0,85619.0,85528.0,85423.0,43778.0,84588.0,84392.0,84210.0,83955.0,42706.0,46161.0,41597.0,82910.0,82545.0,82032.0,42062.0,81339.0,41987.0,41099.0,80617.0,80502.0,80413.0,40332.0,79927.0,79804.0,79413.0,79407.0,78630.0,78589.0,78277.0,77438.0,76598.0,76451.0]},"kind":"numeric","n":500,"n_null":0,"n_unique":499,"null_rate":0.0,"stats":{"iqr":71602.25,"kurtosis":127.99072943785771,"max":4011044.0,"mean":159797.124,"median":104303.0,"min":40332.0,"n_outliers":57,"outlier_rate":0.114,"q1":77304.75,"q3":148907.0,"skew":9.709287716220626,"std":250171.33221397706,"zero_rate":0.0}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"daily_views","extras":{},"kind":"unknown","n":500,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["days_in_top_100.stats","peak_views.stats","total_views.stats","title.top_values","row_count"],"featured_charts":[{"caption":"Look for an extreme right tail \u2014 a few articles dominate total attention while most cluster near the median of ~213K.","column":"total_views","kind":"histogram"},{"caption":"Check how peak single-day views are distributed; skew of 9.7 suggests a handful of viral spikes far above the typical ~104K.","column":"peak_views","kind":"histogram"},{"caption":"See how briefly most articles trend \u2014 the median is just 3 days, but some persist up to 30.","column":"days_in_top_100","kind":"histogram"},{"caption":"All 500 titles are unique; inspect title length to get a feel for the kinds of pages trending.","column":"title","kind":"length"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset captures 500 trending Wikipedia articles, with each row identified by a unique title and described by days_in_top_100, peak_views, total_views, and a daily_views series. All three numeric columns are heavily right-skewed with significant outliers \u2014 total_views skew is 10.4 with a max of ~23.9M against a median of ~213K, and peak_views shows similar behavior. Most articles spend only a few days in the top 100 (median 3, max 30), but a long tail extends well beyond. Start by examining the distribution of total_views and days_in_top_100 to understand how concentrated attention is on a few breakout articles.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"Wikipedia-style article titles with underscores (e.g. '1989_Tiananmen_Square_protests_and_massacre', 'Stranger_Things_season_5'), unique across all 500 rows (n_unique=500, entropy_ratio=1.0). Every value appears exactly once, so this functions as a row identifier rather than a categorical feature. The long_tail alert simply reflects that uniqueness.","role":"identifier","scope":"column","target":"title","treatment":"Treat as a row key; drop from modelling or use only for joins and lookup."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.zero_rate","stats.skew","stats.kurtosis","stats.median","stats.mean","stats.max","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Likely a per-row view count, with all 500 values unique and no nulls or zeros. The distribution is severely right-skewed (skew 10.44, kurtosis 149.66): the median is 213,065 but the mean is 580,331 and the max reaches 23,890,102, roughly 112x the median. Outliers make up 10.2% of rows (51 of 500), so a small set of viral entries dominates the tail.","role":"feature","scope":"column","target":"total_views","treatment":"log-transform before modelling to tame the heavy right tail."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.q1","stats.q3","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate","stats.std"],"model":"anthropic:claude-opus-4-7","narrative":"This column counts days a record spent in some top-100 ranking, with 500 non-null integer values ranging from 1 to 30 and a median of just 3. The distribution is heavily right-skewed (skew 2.45, kurtosis 5.98) \u2014 most items churn out fast while a long tail lingers, producing 56 outliers (11.2% outlier rate) above the q3 of 6. Mean (5.18) sits well above median, and only 27 unique values suggest tenure is bounded and discrete.","role":"feature","scope":"column","target":"days_in_top_100","treatment":"Log- or sqrt-transform before modelling to tame the right skew and outlier mass."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.median","stats.mean","stats.max","stats.q3","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate","stats.std","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"A numeric measure of peak viewership per record, with 499 unique values across 500 rows and no nulls or zeros. The distribution is severely right-skewed (skew 9.71, kurtosis 127.99): the median is 104,303 but the mean is 159,797 and the max reaches 4,011,044, well above q3 of 148,907. 57 outliers (11.4%) sit above the upper whisker, suggesting a small tail of viral peaks dominates the variance (std 250,171).","role":"feature","scope":"column","target":"peak_views","treatment":"log-transform before modelling to tame the heavy right tail."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","column","kind","n","null_rate","stats"],"model":"anthropic:claude-opus-4-7","narrative":"Column 'daily_views' was skipped by the profiler, so no type, uniqueness, or distribution stats were computed despite a full 500 non-null rows. The name suggests a per-day view count (likely numeric and right-skewed in practice), but nothing in the evidence confirms that. Re-run profiling with this column included before drawing any conclusions.","role":"other","scope":"column","target":"daily_views","treatment":"Re-profile the column to recover type and distribution before any downstream use."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":1924,"prompt_tokens":5346,"total_tokens":7270}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:25:20+00:00","mode":"full","row_count":500,"sampled_rows":500,"seed":42,"source":"/home/coolhand/datasets/us-attention-data/wikipedia_trending.json"},"notes":[],"saturn_version":"0.2.0","schema":{"daily_views":"unknown","days_in_top_100":"numeric","peak_views":"numeric","title":"categorical","total_views":"numeric"}}
