47:"/_next/static/chunks/2g8w-80ml0qgh.js" 48:"/_next/static/chunks/0iv56yrji_20j.js" 49:"/_next/static/chunks/2j22cxchii_xx.js" 4a:"/_next/static/chunks/0lc44eilyyvky.js" 4b:"/_next/static/chunks/1jl6tco-uuy-j.js" 4c:"/_next/static/chunks/20w4eaqlekefm.js" 4d:"/_next/static/chunks/3i1_gmjy-npy3.js" 4e:"/_next/static/chunks/3k2gyg36fnag_.js" 4f:"/_next/static/chunks/0om3fkgfnicab.js" 50:"/_next/static/chunks/39xqakak-rww8.js" 51:"/_next/static/chunks/2k8pepwc4pxns.js" 52:"/_next/static/chunks/3di53f0fz7pw_.js" 53:"/_next/static/chunks/1ot1rbfa0d_n4.js" 54:"/_next/static/chunks/1nyz-fz1mk3y6.js" 55:"/_next/static/chunks/2d693k1du0jif.js" 56:"/_next/static/chunks/23lvo0719esx5.js" 57:"/_next/static/chunks/2s3axvrz9s11v.js" 58:"/_next/static/chunks/3m1xjj5kw5fie.js" 59:"/_next/static/chunks/20k3408cq3fwt.js" 5a:"/_next/static/chunks/3bgoyiso1rhn7.js" 5b:"/_next/static/chunks/1r-4-7k4p367v.js" 5c:"/_next/static/chunks/0oag6lffx7d01.js" 5d:"/_next/static/chunks/082jo-0ajazgr.js" 5e:"/_next/static/chunks/0-a64pg0hn7g7.js" 5f:"/_next/static/chunks/09nq57stwzkgf.js" 60:"/_next/static/chunks/20329i6m_04t6.js" 61:"/_next/static/chunks/0wa9m1-tphf9u.js" 62:"/_next/static/chunks/0so1i35v7xcta.js" 63:"/_next/static/chunks/0i3-eynrkvqi7.js" 64:"/_next/static/chunks/1aoncsc85dt-5.js" 65:"/_next/static/chunks/2ozcrjb_hh74t.js" 66:"/_next/static/chunks/0hy4a31wjpabs.js" 67:"/_next/static/chunks/1tn-0fivsxsv1.js" 68:"/_next/static/chunks/0hlb44ca7-4a2.js" 69:"/_next/static/chunks/3ah32gv3pv1wi.js" 6a:"/_next/static/chunks/0jbzid2v9xv3h.js" 6b:"/_next/static/chunks/2wl4_vih_-70f.js" 6c:"/_next/static/chunks/1_lo_qve3gu86.js" 6d:"/_next/static/chunks/3tgd0la5mmnsn.js" 6e:"/_next/static/chunks/18ggtgz2yf759.js" 6f:"/_next/static/chunks/3odmutpycmfnf.js" 70:"/_next/static/chunks/253gnmj0-cj17.js" 71:I[593304,["$2d","$2e","$2f","$30","$31","$32","$47","$48","$49","$4a","$4b","$4c","$4d","$4e","$4f","$50","$51","$52","$53","$54","$55","$56","$57","$58","$59","$5a","$5b","$5c","$5d","$5e","$5f","$60","$61","$62","$63","$64","$65","$66","$67","$68","$69","$6a","$6b","$6c","$6d","$6e","$6f","$70"],"OwnedHydration"] 72:T869,import numpy as np import pandas as pd from scipy import stats def analyze_numerical_feature(series: pd.Series, name: str) -> dict: """ Comprehensive analysis of a numerical feature. Returns statistics and recommendations for preprocessing. """ analysis = { "name": name, "dtype": str(series.dtype), "count": len(series), "missing": series.isna().sum(), "missing_pct": series.isna().mean() * 100, "unique_values": series.nunique(), "is_likely_discrete": series.nunique() < 50 and series.dropna().apply(float.is_integer).all(), } # Basic statistics (for non-missing values) clean = series.dropna() if len(clean) > 0: analysis.update({ "min": clean.min(), "max": clean.max(), "mean": clean.mean(), "median": clean.median(), "std": clean.std(), "skewness": stats.skew(clean), "kurtosis": stats.kurtosis(clean), }) # Distribution shape recommendations skew = abs(analysis["skewness"]) if skew > 2: analysis["transform_recommendation"] = "log or sqrt transform (highly skewed)" elif skew > 1: analysis["transform_recommendation"] = "consider log transform (moderately skewed)" else: analysis["transform_recommendation"] = "standard scaling likely sufficient" # Outlier detection using IQR q1, q3 = clean.quantile([0.25, 0.75]) iqr = q3 - q1 outlier_mask = (clean < q1 - 1.5 * iqr) | (clean > q3 + 1.5 * iqr) analysis["outlier_count"] = outlier_mask.sum() analysis["outlier_pct"] = outlier_mask.mean() * 100 return analysis # Example usage np.random.seed(42) income = pd.Series(np.random.lognormal(10, 1, 10000)) # Log-normal income data analysis = analyze_numerical_feature(income, "household_income") print(f"Feature: {analysis['name']}") print(f"Skewness: {analysis['skewness']:.2f}") print(f"Recommendation: {analysis['transform_recommendation']}") print(f"Outliers: {analysis['outlier_pct']:.1f}%")73:T59b,import pandas as pd import numpy as np from sklearn.preprocessing import OneHotEncoder, OrdinalEncoder from category_encoders import TargetEncoder # Sample data df = pd.DataFrame({ "color": ["red", "blue", "green", "red", "blue", "green", "red", "blue"], "size": ["S", "M", "L", "XL", "S", "M", "L", "XL"], "target": [0, 1, 1, 1, 0, 0, 1, 1] }) # 1. One-Hot Encoding for nominal features onehot = OneHotEncoder(sparse_output=False, handle_unknown="ignore") color_encoded = onehot.fit_transform(df[["color"]]) color_columns = onehot.get_feature_names_out(["color"]) print("One-Hot Encoded Colors:") print(pd.DataFrame(color_encoded, columns=color_columns)) # 2. Ordinal Encoding with explicit order size_order = ["S", "M", "L", "XL"] # Smallest to largest ordinal = OrdinalEncoder(categories=[size_order]) df["size_ordinal"] = ordinal.fit_transform(df[["size"]]) print(f" Ordinal Encoded Sizes: {df['size_ordinal'].tolist()}") # 3. Target Encoding (with smoothing to prevent overfitting) target_enc = TargetEncoder(smoothing=1.0) df["color_target_encoded"] = target_enc.fit_transform(df["color"], df["target"]) print(f" Target Encoded Colors: {df[['color', 'color_target_encoded']].drop_duplicates()}") # 4. Frequency Encoding freq_map = df["color"].value_counts(normalize=True).to_dict() df["color_freq"] = df["color"].map(freq_map) print(f" Frequency Encoded Colors: {df[['color', 'color_freq']].drop_duplicates()}")74:Td20,import pandas as pd import numpy as np def infer_feature_type(series: pd.Series, name: str) -> dict: """ Infer semantic feature type from data characteristics. Returns type classification and confidence. """ result = {"name": name, "dtype": str(series.dtype)} clean = series.dropna() n_unique = clean.nunique() n_total = len(clean) unique_ratio = n_unique / n_total if n_total > 0 else 0 # String-like columns if series.dtype == 'object' or str(series.dtype) == 'string': if n_unique == 2: result["inferred_type"] = "binary" result["confidence"] = "high" elif n_unique <= 20: result["inferred_type"] = "categorical_lowcard" result["confidence"] = "high" elif n_unique <= 100: result["inferred_type"] = "categorical_medcard" result["confidence"] = "medium" else: # Could be high-cardinality categorical or text avg_len = clean.astype(str).str.len().mean() if avg_len > 50: result["inferred_type"] = "text" result["confidence"] = "medium" else: result["inferred_type"] = "categorical_highcard" result["confidence"] = "medium" # Numeric columns elif np.issubdtype(series.dtype, np.number): is_integer = clean.apply(lambda x: float(x).is_integer()).all() if n_unique == 2: result["inferred_type"] = "binary" result["confidence"] = "high" elif is_integer and n_unique <= 10: # Low-cardinality integers: could be ordinal, discrete, or categorical result["inferred_type"] = "discrete_or_ordinal" result["confidence"] = "low" result["note"] = "Inspect values to determine if ordinal or categorical" elif is_integer and n_unique <= 50: result["inferred_type"] = "discrete_numerical" result["confidence"] = "medium" elif unique_ratio > 0.9: result["inferred_type"] = "continuous" result["confidence"] = "high" elif unique_ratio > 0.5: result["inferred_type"] = "continuous" result["confidence"] = "medium" else: result["inferred_type"] = "discrete_numerical" result["confidence"] = "medium" # Datetime elif pd.api.types.is_datetime64_any_dtype(series): result["inferred_type"] = "datetime" result["confidence"] = "high" else: result["inferred_type"] = "unknown" result["confidence"] = "low" result["unique_values"] = n_unique result["unique_ratio"] = unique_ratio return result # Apply to a DataFrame def analyze_all_features(df: pd.DataFrame) -> pd.DataFrame: results = [infer_feature_type(df[col], col) for col in df.columns] return pd.DataFrame(results) # Example df = pd.DataFrame({ "user_id": range(1000), "age": np.random.randint(18, 80, 1000), "income": np.random.lognormal(10, 1, 1000), "gender": np.random.choice(["M", "F"], 1000), "education": np.random.choice(["HS", "BS", "MS", "PhD"], 1000), "rating": np.random.randint(1, 6, 1000), "is_premium": np.random.choice([0, 1], 1000), }) print(analyze_all_features(df).to_string())46:["$","$L71",null,{"owner":"anonymous","state":{"mutations":[],"queries":[{"dehydratedAt":1792316060916,"state":{"data":{"json":{"archivedAt":null,"id":"seed_f3eab11dea40038b7e168ba31a9b56d9","slug":"data-quality-and-analytics-engineering","title":"Data Quality & Analytics Engineering","description":"Combine SQL reporting, data preparation and dataset-release controls. Work through correctness at boundaries, time-window exports and quality gates.","image":null,"color":"#2563eb","keyTopics":["Prepare trustworthy inputs","Query and aggregate correctly","Time windows and reproducible exports","Release gates and production architecture"],"estimatedHours":16.6,"problemCount":26,"visualizerCount":0,"quizCount":0,"learningCount":8,"difficulty":"INTERMEDIATE","idealFor":["Learners who want a focused route from concepts to applied practice"],"prerequisites":["SQL basics and basic Python programming"],"skillsGained":["Prepare trustworthy inputs","Query and aggregate correctly","Time windows and reproducible exports","Release gates and production architecture"],"outcomes":["Explain the core ideas and their tradeoffs","Complete the included coding and design activities","Identify failure cases and justify a reliable implementation"],"overview":"Combine SQL reporting, data preparation and dataset-release controls. Work through correctness at boundaries, time-window exports and quality gates.","createdAt":"2026-10-17T16:02:58.635Z","updatedAt":"2026-10-17T16:28:34.314Z","modules":[{"id":"seed_7dd124acbcd7ad62305829c74b0582ed","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Feature Engineering Mastery","order":1,"contentType":"LEARNING","contentSlug":"feature-engineering-mastery","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_0584a4a6f87d6b26862fade5c7274ad0","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Feature Selection Theory","order":2,"contentType":"LEARNING","contentSlug":"feature-selection-theory","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_f4c8ebfa5635cedbc39bc686fc7e307c","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Data Normalization Techniques: Z-Score and Min-Max Scaling","order":3,"contentType":"PROBLEM","contentSlug":"feature-scaling-normalization","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_28e6f73596e24bcf6959afcf663d629e","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Synchronized Data Permutation","order":4,"contentType":"PROBLEM","contentSlug":"synchronized-data-permutation","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_9d7b3161e6c57abd3194ba666d3fcc6b","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Dataset Batch Generator for Training Pipelines","order":5,"contentType":"PROBLEM","contentSlug":"dataset-batch-generator","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_b2c36ec83e2de932242b6571db285ac5","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Dataset quality checks reject values on valid limits","order":6,"contentType":"REPO","contentSlug":"dataset-gate-range-boundary","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_a1af2c95588ee4a5a0a7aefb80c0dcc5","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Include the configured data-quality endpoints","order":7,"contentType":"CODE_REVIEW","contentSlug":"dataset-gate-review-range-boundary","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_ac74fcf43054ce304acbbdb2b4f22830","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Join Concepts","order":1,"contentType":"LEARNING","contentSlug":"join-concepts","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_a8badacafe97505daec85c53b6ee0152","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Mastering Inner Joins in SQL","order":2,"contentType":"LEARNING","contentSlug":"inner-join","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_e71a0c5abce2c311d2a7b62324324e8b","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"SQL Aggregate Functions: Summarizing Data with Precision","order":3,"contentType":"LEARNING","contentSlug":"aggregate-functions","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_0cf24f0a5ed2294d097dc008fcb3da50","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"GROUP BY: Categorizing and Summarizing Data","order":4,"contentType":"LEARNING","contentSlug":"group-by","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_44f8822553a9a0c5f66dcc5191e8b72c","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Adjacent Free Seat Finder","order":5,"contentType":"PROBLEM","contentSlug":"adjacent-free-seat-finder","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_bdbfdcf38cc56e1cecd3a3dab100db30","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Binary Hierarchy Node Role Tagging","order":6,"contentType":"PROBLEM","contentSlug":"binary-hierarchy-node-role-tagging","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_7149f1606bc3de6a1738c9a1a16f5442","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Double Round-Robin League Fixtures","order":7,"contentType":"PROBLEM","contentSlug":"double-round-robin-league-fixtures","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_bde361d98865115cee5fd4e9b4c4fae3","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Employee Identity Bridge Report","order":8,"contentType":"PROBLEM","contentSlug":"employee-identity-bridge-report","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_ebfa3236159961899fe450831f71a0ed","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Accounts Above Net Balance Threshold","order":9,"contentType":"PROBLEM","contentSlug":"accounts-above-net-balance-threshold","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_78a147a1cf7ff1509ba05df5a161a480","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Ad Campaign Click-Through Rate Ranking","order":10,"contentType":"PROBLEM","contentSlug":"ad-campaign-click-through-rate-ranking","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_0a39b798693ed2b3e55fcb7c412a584b","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Artist Presence Frequency on Streaming Chart","order":11,"contentType":"PROBLEM","contentSlug":"artist-presence-frequency-on-streaming-chart","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_c9992d4b67dcc5b6008281a41ff8e301","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Average Process Duration by Machine","order":12,"contentType":"PROBLEM","contentSlug":"average-process-duration-by-machine","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_14bb01ed4fe99ee12f8ea8ebcdb0f544","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Bike Fleet Last Usage Timestamp","order":1,"contentType":"PROBLEM","contentSlug":"bike-fleet-last-usage-timestamp","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_d8fb63fee91b40f6f6b0364ac8628f99","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Buyer Yearly Order Volume Report","order":2,"contentType":"PROBLEM","contentSlug":"buyer-yearly-order-volume-report","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_7be177e5ca61ee7441f64c65588d981c","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Calendar Date Long-Format Renderer","order":3,"contentType":"PROBLEM","contentSlug":"calendar-date-long-format-renderer","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_d86b3e2e13aeebbaff54436e2cc14ceb","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Country November Climate Banding","order":4,"contentType":"PROBLEM","contentSlug":"country-november-climate-banding","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_5e2191c40660eb7513a5f069a7cf51da","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Implement grouped research-window reporting with Spark","order":5,"contentType":"REPO","contentSlug":"research-rollups-window-export","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_5af6a356c488afd241b7203f50b66568","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Aggregate event counts and subject diversity in separate columns","order":6,"contentType":"CODE_REVIEW","contentSlug":"research-rollups-review-window-export","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_b85447ebb26687b3db4b7be8db756a17","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Late research corrections resurrect measurements and cross tenant boundaries","order":7,"contentType":"REPO","contentSlug":"research-rollups-amendment-order","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_f8a65bd4b602018a3d2218b171e32c20","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Move period filtering after revisions but keep a global event-ID partition","order":8,"contentType":"CODE_REVIEW","contentSlug":"research-rollups-review-amendment-order","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_151f0a5d588da6a78885a65b4ecd8342","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"ML System Design","order":1,"contentType":"LEARNING","contentSlug":"ml-system-design","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_0b023de37e88596354c190d63fa1d873","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Debugging ML Models","order":2,"contentType":"LEARNING","contentSlug":"debugging-ml-models","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_1ed3f6e9c3235903f08610f52f32470f","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"One bad dataset row consumes several quality allowances","order":3,"contentType":"REPO","contentSlug":"dataset-gate-failure-budget","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_26478799390bb02a9c04eef458c2560a","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Count bad dataset rows once","order":4,"contentType":"CODE_REVIEW","contentSlug":"dataset-gate-review-failure-budget","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_997ee6bd0af9db91a4d313e23e0875a9","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Published datasets differ from the snapshot that passed review","order":5,"contentType":"REPO","contentSlug":"dataset-gate-unchecked-publication","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_aa2ec17e6db2dec50d9884e77cf9559e","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Publish the rows captured by the quality run","order":6,"contentType":"CODE_REVIEW","contentSlug":"dataset-gate-review-unchecked-publication","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"},{"id":"seed_1a2bdd66cdc23350e183f004f93a538d","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Design a Machine Learning Feature Store","order":7,"contentType":"HLD","contentSlug":"design-ml-feature-store","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z"}],"sections":[{"title":"Prepare trustworthy inputs","order":1,"modules":["$46:props:state:queries:0:state:data:json:modules:0","$46:props:state:queries:0:state:data:json:modules:1","$46:props:state:queries:0:state:data:json:modules:2","$46:props:state:queries:0:state:data:json:modules:3","$46:props:state:queries:0:state:data:json:modules:4","$46:props:state:queries:0:state:data:json:modules:5","$46:props:state:queries:0:state:data:json:modules:6"]},{"title":"Query and aggregate correctly","order":2,"modules":["$46:props:state:queries:0:state:data:json:modules:7","$46:props:state:queries:0:state:data:json:modules:8","$46:props:state:queries:0:state:data:json:modules:9","$46:props:state:queries:0:state:data:json:modules:10","$46:props:state:queries:0:state:data:json:modules:11","$46:props:state:queries:0:state:data:json:modules:12","$46:props:state:queries:0:state:data:json:modules:13","$46:props:state:queries:0:state:data:json:modules:14","$46:props:state:queries:0:state:data:json:modules:15","$46:props:state:queries:0:state:data:json:modules:16","$46:props:state:queries:0:state:data:json:modules:17","$46:props:state:queries:0:state:data:json:modules:18"]},{"title":"Time windows and reproducible exports","order":3,"modules":["$46:props:state:queries:0:state:data:json:modules:19","$46:props:state:queries:0:state:data:json:modules:20","$46:props:state:queries:0:state:data:json:modules:21","$46:props:state:queries:0:state:data:json:modules:22","$46:props:state:queries:0:state:data:json:modules:23","$46:props:state:queries:0:state:data:json:modules:24","$46:props:state:queries:0:state:data:json:modules:25","$46:props:state:queries:0:state:data:json:modules:26"]},{"title":"Release gates and production architecture","order":4,"modules":["$46:props:state:queries:0:state:data:json:modules:27","$46:props:state:queries:0:state:data:json:modules:28","$46:props:state:queries:0:state:data:json:modules:29","$46:props:state:queries:0:state:data:json:modules:30","$46:props:state:queries:0:state:data:json:modules:31","$46:props:state:queries:0:state:data:json:modules:32","$46:props:state:queries:0:state:data:json:modules:33"]}]},"meta":{"values":{"createdAt":["Date"],"updatedAt":["Date"],"modules.0.createdAt":["Date"],"modules.0.updatedAt":["Date"],"modules.1.createdAt":["Date"],"modules.1.updatedAt":["Date"],"modules.2.createdAt":["Date"],"modules.2.updatedAt":["Date"],"modules.3.createdAt":["Date"],"modules.3.updatedAt":["Date"],"modules.4.createdAt":["Date"],"modules.4.updatedAt":["Date"],"modules.5.createdAt":["Date"],"modules.5.updatedAt":["Date"],"modules.6.createdAt":["Date"],"modules.6.updatedAt":["Date"],"modules.7.createdAt":["Date"],"modules.7.updatedAt":["Date"],"modules.8.createdAt":["Date"],"modules.8.updatedAt":["Date"],"modules.9.createdAt":["Date"],"modules.9.updatedAt":["Date"],"modules.10.createdAt":["Date"],"modules.10.updatedAt":["Date"],"modules.11.createdAt":["Date"],"modules.11.updatedAt":["Date"],"modules.12.createdAt":["Date"],"modules.12.updatedAt":["Date"],"modules.13.createdAt":["Date"],"modules.13.updatedAt":["Date"],"modules.14.createdAt":["Date"],"modules.14.updatedAt":["Date"],"modules.15.createdAt":["Date"],"modules.15.updatedAt":["Date"],"modules.16.createdAt":["Date"],"modules.16.updatedAt":["Date"],"modules.17.createdAt":["Date"],"modules.17.updatedAt":["Date"],"modules.18.createdAt":["Date"],"modules.18.updatedAt":["Date"],"modules.19.createdAt":["Date"],"modules.19.updatedAt":["Date"],"modules.20.createdAt":["Date"],"modules.20.updatedAt":["Date"],"modules.21.createdAt":["Date"],"modules.21.updatedAt":["Date"],"modules.22.createdAt":["Date"],"modules.22.updatedAt":["Date"],"modules.23.createdAt":["Date"],"modules.23.updatedAt":["Date"],"modules.24.createdAt":["Date"],"modules.24.updatedAt":["Date"],"modules.25.createdAt":["Date"],"modules.25.updatedAt":["Date"],"modules.26.createdAt":["Date"],"modules.26.updatedAt":["Date"],"modules.27.createdAt":["Date"],"modules.27.updatedAt":["Date"],"modules.28.createdAt":["Date"],"modules.28.updatedAt":["Date"],"modules.29.createdAt":["Date"],"modules.29.updatedAt":["Date"],"modules.30.createdAt":["Date"],"modules.30.updatedAt":["Date"],"modules.31.createdAt":["Date"],"modules.31.updatedAt":["Date"],"modules.32.createdAt":["Date"],"modules.32.updatedAt":["Date"],"modules.33.createdAt":["Date"],"modules.33.updatedAt":["Date"],"sections.0.modules.0.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.0.createdAt","sections.0.modules.0.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.0.updatedAt","sections.0.modules.1.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.1.createdAt","sections.0.modules.1.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.1.updatedAt","sections.0.modules.2.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.2.createdAt","sections.0.modules.2.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.2.updatedAt","sections.0.modules.3.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.3.createdAt","sections.0.modules.3.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.3.updatedAt","sections.0.modules.4.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.4.createdAt","sections.0.modules.4.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.4.updatedAt","sections.0.modules.5.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.5.createdAt","sections.0.modules.5.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.5.updatedAt","sections.0.modules.6.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.6.createdAt","sections.0.modules.6.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.6.updatedAt","sections.1.modules.0.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.7.createdAt","sections.1.modules.0.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.7.updatedAt","sections.1.modules.1.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.8.createdAt","sections.1.modules.1.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.8.updatedAt","sections.1.modules.2.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.9.createdAt","sections.1.modules.2.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.9.updatedAt","sections.1.modules.3.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.10.createdAt","sections.1.modules.3.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.10.updatedAt","sections.1.modules.4.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.11.createdAt","sections.1.modules.4.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.11.updatedAt","sections.1.modules.5.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.12.createdAt","sections.1.modules.5.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.12.updatedAt","sections.1.modules.6.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.13.createdAt","sections.1.modules.6.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.13.updatedAt","sections.1.modules.7.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.14.createdAt","sections.1.modules.7.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.14.updatedAt","sections.1.modules.8.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.15.createdAt","sections.1.modules.8.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.15.updatedAt","sections.1.modules.9.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.16.createdAt","sections.1.modules.9.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.16.updatedAt","sections.1.modules.10.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.17.createdAt","sections.1.modules.10.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.17.updatedAt","sections.1.modules.11.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.18.createdAt","sections.1.modules.11.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.18.updatedAt","sections.2.modules.0.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.19.createdAt","sections.2.modules.0.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.19.updatedAt","sections.2.modules.1.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.20.createdAt","sections.2.modules.1.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.20.updatedAt","sections.2.modules.2.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.21.createdAt","sections.2.modules.2.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.21.updatedAt","sections.2.modules.3.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.22.createdAt","sections.2.modules.3.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.22.updatedAt","sections.2.modules.4.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.23.createdAt","sections.2.modules.4.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.23.updatedAt","sections.2.modules.5.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.24.createdAt","sections.2.modules.5.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.24.updatedAt","sections.2.modules.6.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.25.createdAt","sections.2.modules.6.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.25.updatedAt","sections.2.modules.7.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.26.createdAt","sections.2.modules.7.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.26.updatedAt","sections.3.modules.0.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.27.createdAt","sections.3.modules.0.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.27.updatedAt","sections.3.modules.1.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.28.createdAt","sections.3.modules.1.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.28.updatedAt","sections.3.modules.2.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.29.createdAt","sections.3.modules.2.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.29.updatedAt","sections.3.modules.3.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.30.createdAt","sections.3.modules.3.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.30.updatedAt","sections.3.modules.4.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.31.createdAt","sections.3.modules.4.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.31.updatedAt","sections.3.modules.5.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.32.createdAt","sections.3.modules.5.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.32.updatedAt","sections.3.modules.6.createdAt":"$46:props:state:queries:0:state:data:meta:values:modules.33.createdAt","sections.3.modules.6.updatedAt":"$46:props:state:queries:0:state:data:meta:values:modules.33.updatedAt"},"referentialEqualities":{"modules.0":["sections.0.modules.0"],"modules.1":["sections.0.modules.1"],"modules.2":["sections.0.modules.2"],"modules.3":["sections.0.modules.3"],"modules.4":["sections.0.modules.4"],"modules.5":["sections.0.modules.5"],"modules.6":["sections.0.modules.6"],"modules.7":["sections.1.modules.0"],"modules.8":["sections.1.modules.1"],"modules.9":["sections.1.modules.2"],"modules.10":["sections.1.modules.3"],"modules.11":["sections.1.modules.4"],"modules.12":["sections.1.modules.5"],"modules.13":["sections.1.modules.6"],"modules.14":["sections.1.modules.7"],"modules.15":["sections.1.modules.8"],"modules.16":["sections.1.modules.9"],"modules.17":["sections.1.modules.10"],"modules.18":["sections.1.modules.11"],"modules.19":["sections.2.modules.0"],"modules.20":["sections.2.modules.1"],"modules.21":["sections.2.modules.2"],"modules.22":["sections.2.modules.3"],"modules.23":["sections.2.modules.4"],"modules.24":["sections.2.modules.5"],"modules.25":["sections.2.modules.6"],"modules.26":["sections.2.modules.7"],"modules.27":["sections.3.modules.0"],"modules.28":["sections.3.modules.1"],"modules.29":["sections.3.modules.2"],"modules.30":["sections.3.modules.3"],"modules.31":["sections.3.modules.4"],"modules.32":["sections.3.modules.5"],"modules.33":["sections.3.modules.6"]},"v":1}},"dataUpdateCount":1,"dataUpdatedAt":1792316060618,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["learningPaths","getBySlug"],{"input":{"slug":"data-quality-and-analytics-engineering"},"type":"query"}],"queryHash":"[[\"learningPaths\",\"getBySlug\"],{\"input\":{\"slug\":\"data-quality-and-analytics-engineering\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060919,"state":{"data":{"json":{"path":{"archivedAt":null,"id":"seed_f3eab11dea40038b7e168ba31a9b56d9","slug":"data-quality-and-analytics-engineering","title":"Data Quality & Analytics Engineering","description":"Combine SQL reporting, data preparation and dataset-release controls. Work through correctness at boundaries, time-window exports and quality gates.","image":null,"color":"#2563eb","keyTopics":["Prepare trustworthy inputs","Query and aggregate correctly","Time windows and reproducible exports","Release gates and production architecture"],"estimatedHours":16.6,"problemCount":26,"visualizerCount":0,"quizCount":0,"learningCount":8,"difficulty":"INTERMEDIATE","idealFor":["Learners who want a focused route from concepts to applied practice"],"prerequisites":["SQL basics and basic Python programming"],"skillsGained":["Prepare trustworthy inputs","Query and aggregate correctly","Time windows and reproducible exports","Release gates and production architecture"],"outcomes":["Explain the core ideas and their tradeoffs","Complete the included coding and design activities","Identify failure cases and justify a reliable implementation"],"overview":"Combine SQL reporting, data preparation and dataset-release controls. Work through correctness at boundaries, time-window exports and quality gates.","createdAt":"2026-10-17T16:02:58.635Z","updatedAt":"2026-10-17T16:28:34.314Z","modules":[{"id":"seed_7dd124acbcd7ad62305829c74b0582ed","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Feature Engineering Mastery","order":1,"contentType":"LEARNING","contentSlug":"feature-engineering-mastery","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_56dd58a33d5534516199c7580e841f63","title":"Feature Types","order":0},{"id":"seed_842f4a11ba72179bd359958a69c32a08","title":"Domain Knowledge","order":1},{"id":"seed_0e74c9a08deb29e70b8fc92ba3fe99ed","title":"Interaction Features","order":2},{"id":"seed_a46bdb1443418ed68ebb0bc3223d5a9d","title":"Time-Based Features","order":3},{"id":"seed_09805d9c32a742bd2a525f9770161506","title":"Text and Categorical","order":4}]},{"id":"seed_0584a4a6f87d6b26862fade5c7274ad0","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Feature Selection Theory","order":2,"contentType":"LEARNING","contentSlug":"feature-selection-theory","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_ac96756fe1d66bb7a3dccb4937954afc","title":"Filter Methods","order":0},{"id":"seed_ab79381fc456ad8c97dfdf7bcc88e2d0","title":"Wrapper Methods","order":1},{"id":"seed_cd41c3c79e7e50fd872cb73cfc07fa95","title":"Embedded Methods","order":2},{"id":"seed_392bf51ca8608e808c255ac167e9a796","title":"Stability Selection","order":3},{"id":"seed_ff2defccc0fa65581937fe462a85cd0c","title":"Feature Selection Bias","order":4}]},{"id":"seed_f4c8ebfa5635cedbc39bc686fc7e307c","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Data Normalization Techniques: Z-Score and Min-Max Scaling","order":3,"contentType":"PROBLEM","contentSlug":"feature-scaling-normalization","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_28e6f73596e24bcf6959afcf663d629e","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Synchronized Data Permutation","order":4,"contentType":"PROBLEM","contentSlug":"synchronized-data-permutation","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_9d7b3161e6c57abd3194ba666d3fcc6b","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Dataset Batch Generator for Training Pipelines","order":5,"contentType":"PROBLEM","contentSlug":"dataset-batch-generator","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_b2c36ec83e2de932242b6571db285ac5","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Dataset quality checks reject values on valid limits","order":6,"contentType":"REPO","contentSlug":"dataset-gate-range-boundary","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_a1af2c95588ee4a5a0a7aefb80c0dcc5","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Prepare trustworthy inputs","sectionOrder":1,"title":"Include the configured data-quality endpoints","order":7,"contentType":"CODE_REVIEW","contentSlug":"dataset-gate-review-range-boundary","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_ac74fcf43054ce304acbbdb2b4f22830","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Join Concepts","order":1,"contentType":"LEARNING","contentSlug":"join-concepts","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_1e38b5921528025106a26c4f089be1cb","title":"Combining Tables","order":0},{"id":"seed_dcb5ce4b175415c957f779406b0d1b19","title":"Join Condition","order":1},{"id":"seed_bbc6131db378c14a087179a9f72414a7","title":"Join Types Overview","order":2},{"id":"seed_539cb990795374d6c31333ef9bf3ecf7","title":"Table Aliases","order":3},{"id":"seed_0001c1cac7cca78eb6f52ebbdb1afab6","title":"Join Syntax Variations","order":4}]},{"id":"seed_a8badacafe97505daec85c53b6ee0152","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Mastering Inner Joins in SQL","order":2,"contentType":"LEARNING","contentSlug":"inner-join","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_781692f47c6df7e679c40e142dbed5c9","title":"INNER JOIN Syntax","order":0},{"id":"seed_2b732df663b65e3d43f6363984a3fa55","title":"Matching Rows Only","order":1},{"id":"seed_88dd7a26daed2bbe4082eef5f643c393","title":"Multiple Conditions","order":2},{"id":"seed_94ed1e7fd34ec5ad357e57fb1022715e","title":"Multiple Tables","order":3},{"id":"seed_084222a14e232d4e40a5d11a15b96358","title":"Self-Join","order":4}]},{"id":"seed_e71a0c5abce2c311d2a7b62324324e8b","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"SQL Aggregate Functions: Summarizing Data with Precision","order":3,"contentType":"LEARNING","contentSlug":"aggregate-functions","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_6f2fc9e6f49c60b40521ec0e3b4abbf7","title":"COUNT: Counting Rows and Values with Precision","order":0},{"id":"seed_cbed285c607556c164b17ffa562f14cb","title":"SUM: Calculating Totals with Precision","order":1},{"id":"seed_308de1c55dab2a99f9c8c886dc2e68a6","title":"AVG: Computing Means with Semantic Precision","order":2},{"id":"seed_50f7ba02d27ae039c85d275e2d96e94a","title":"MIN and MAX: Finding Extreme Values","order":3},{"id":"seed_7dc79160fecffe4e83ee0423cc30f4fa","title":"Handling NULLs: Mastering Missing Data in Aggregation","order":4}]},{"id":"seed_0cf24f0a5ed2294d097dc008fcb3da50","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"GROUP BY: Categorizing and Summarizing Data","order":4,"contentType":"LEARNING","contentSlug":"group-by","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_72c41ca2dabbb80ac25981efb24c3adf","title":"Grouping Concept","order":0},{"id":"seed_7460a93d7b6ce124e5f77737409ad9c9","title":"GROUP BY Clause","order":1},{"id":"seed_cab381744d762300f833692ce185b452","title":"Multiple Columns","order":2},{"id":"seed_d93fc2bbe11421c0ce356d8b940bc58f","title":"Grouping Rules","order":3},{"id":"seed_e7cac5f6a83bd8cfef9e28afbbabffbf","title":"Common Errors","order":4}]},{"id":"seed_44f8822553a9a0c5f66dcc5191e8b72c","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Adjacent Free Seat Finder","order":5,"contentType":"PROBLEM","contentSlug":"adjacent-free-seat-finder","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_bdbfdcf38cc56e1cecd3a3dab100db30","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Binary Hierarchy Node Role Tagging","order":6,"contentType":"PROBLEM","contentSlug":"binary-hierarchy-node-role-tagging","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_7149f1606bc3de6a1738c9a1a16f5442","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Double Round-Robin League Fixtures","order":7,"contentType":"PROBLEM","contentSlug":"double-round-robin-league-fixtures","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_bde361d98865115cee5fd4e9b4c4fae3","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Employee Identity Bridge Report","order":8,"contentType":"PROBLEM","contentSlug":"employee-identity-bridge-report","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_ebfa3236159961899fe450831f71a0ed","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Accounts Above Net Balance Threshold","order":9,"contentType":"PROBLEM","contentSlug":"accounts-above-net-balance-threshold","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_78a147a1cf7ff1509ba05df5a161a480","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Ad Campaign Click-Through Rate Ranking","order":10,"contentType":"PROBLEM","contentSlug":"ad-campaign-click-through-rate-ranking","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_0a39b798693ed2b3e55fcb7c412a584b","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Artist Presence Frequency on Streaming Chart","order":11,"contentType":"PROBLEM","contentSlug":"artist-presence-frequency-on-streaming-chart","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_c9992d4b67dcc5b6008281a41ff8e301","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Query and aggregate correctly","sectionOrder":2,"title":"Average Process Duration by Machine","order":12,"contentType":"PROBLEM","contentSlug":"average-process-duration-by-machine","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_14bb01ed4fe99ee12f8ea8ebcdb0f544","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Bike Fleet Last Usage Timestamp","order":1,"contentType":"PROBLEM","contentSlug":"bike-fleet-last-usage-timestamp","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_d8fb63fee91b40f6f6b0364ac8628f99","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Buyer Yearly Order Volume Report","order":2,"contentType":"PROBLEM","contentSlug":"buyer-yearly-order-volume-report","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_7be177e5ca61ee7441f64c65588d981c","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Calendar Date Long-Format Renderer","order":3,"contentType":"PROBLEM","contentSlug":"calendar-date-long-format-renderer","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_d86b3e2e13aeebbaff54436e2cc14ceb","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Country November Climate Banding","order":4,"contentType":"PROBLEM","contentSlug":"country-november-climate-banding","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_5e2191c40660eb7513a5f069a7cf51da","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Implement grouped research-window reporting with Spark","order":5,"contentType":"REPO","contentSlug":"research-rollups-window-export","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_5af6a356c488afd241b7203f50b66568","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Aggregate event counts and subject diversity in separate columns","order":6,"contentType":"CODE_REVIEW","contentSlug":"research-rollups-review-window-export","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_b85447ebb26687b3db4b7be8db756a17","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Late research corrections resurrect measurements and cross tenant boundaries","order":7,"contentType":"REPO","contentSlug":"research-rollups-amendment-order","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_f8a65bd4b602018a3d2218b171e32c20","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Time windows and reproducible exports","sectionOrder":3,"title":"Move period filtering after revisions but keep a global event-ID partition","order":8,"contentType":"CODE_REVIEW","contentSlug":"research-rollups-review-amendment-order","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_151f0a5d588da6a78885a65b4ecd8342","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"ML System Design","order":1,"contentType":"LEARNING","contentSlug":"ml-system-design","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_9c02b1cac102d1618b5d2ec9d3acba59","title":"Requirements Gathering","order":0},{"id":"seed_4dc28980257492a88544dbbe86e73b19","title":"Data Pipeline Design","order":1},{"id":"seed_62a45e62e8b80ee0447ecd615fa712c0","title":"Model Architecture","order":2},{"id":"seed_b7258f0e68a594a5a66f52270fa9899a","title":"Serving Infrastructure","order":3},{"id":"seed_0732cd35ca60ac2d3904f7f048471665","title":"Monitoring and Maintenance","order":4}]},{"id":"seed_0b023de37e88596354c190d63fa1d873","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Debugging ML Models","order":2,"contentType":"LEARNING","contentSlug":"debugging-ml-models","description":null,"estimatedMins":20,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[{"id":"seed_d9d2a99058adc397a751811416595e5f","title":"Training Debugging","order":0},{"id":"seed_4271b4ae3eaaa79f36aa687080b09aba","title":"Data Debugging","order":1},{"id":"seed_86cf1003e649a0ded1b3bf5b996cf595","title":"Model Debugging","order":2},{"id":"seed_f226e71a2171e33f686c6786b4d49392","title":"Performance Debugging","order":3},{"id":"seed_fd41a6a1a89a4d5ddcc8aa0a4dedc876","title":"Systematic Debugging","order":4}]},{"id":"seed_1ed3f6e9c3235903f08610f52f32470f","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"One bad dataset row consumes several quality allowances","order":3,"contentType":"REPO","contentSlug":"dataset-gate-failure-budget","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_26478799390bb02a9c04eef458c2560a","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Count bad dataset rows once","order":4,"contentType":"CODE_REVIEW","contentSlug":"dataset-gate-review-failure-budget","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_997ee6bd0af9db91a4d313e23e0875a9","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Published datasets differ from the snapshot that passed review","order":5,"contentType":"REPO","contentSlug":"dataset-gate-unchecked-publication","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_aa2ec17e6db2dec50d9884e77cf9559e","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Publish the rows captured by the quality run","order":6,"contentType":"CODE_REVIEW","contentSlug":"dataset-gate-review-unchecked-publication","description":null,"estimatedMins":35,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]},{"id":"seed_1a2bdd66cdc23350e183f004f93a538d","learningPathId":"seed_f3eab11dea40038b7e168ba31a9b56d9","section":"Release gates and production architecture","sectionOrder":4,"title":"Design a Machine Learning Feature Store","order":7,"contentType":"HLD","contentSlug":"design-ml-feature-store","description":null,"estimatedMins":60,"createdAt":"2026-10-17T16:02:59.261Z","updatedAt":"2026-10-17T16:28:33.431Z","pages":[]}]},"currentModule":"$46:props:state:queries:1:state:data:json:path:modules:0","prevModule":null,"nextModule":"$46:props:state:queries:1:state:data:json:path:modules:1","allModules":"$46:props:state:queries:1:state:data:json:path:modules"},"meta":{"values":{"path.createdAt":["Date"],"path.updatedAt":["Date"],"path.modules.0.createdAt":["Date"],"path.modules.0.updatedAt":["Date"],"path.modules.1.createdAt":["Date"],"path.modules.1.updatedAt":["Date"],"path.modules.2.createdAt":["Date"],"path.modules.2.updatedAt":["Date"],"path.modules.3.createdAt":["Date"],"path.modules.3.updatedAt":["Date"],"path.modules.4.createdAt":["Date"],"path.modules.4.updatedAt":["Date"],"path.modules.5.createdAt":["Date"],"path.modules.5.updatedAt":["Date"],"path.modules.6.createdAt":["Date"],"path.modules.6.updatedAt":["Date"],"path.modules.7.createdAt":["Date"],"path.modules.7.updatedAt":["Date"],"path.modules.8.createdAt":["Date"],"path.modules.8.updatedAt":["Date"],"path.modules.9.createdAt":["Date"],"path.modules.9.updatedAt":["Date"],"path.modules.10.createdAt":["Date"],"path.modules.10.updatedAt":["Date"],"path.modules.11.createdAt":["Date"],"path.modules.11.updatedAt":["Date"],"path.modules.12.createdAt":["Date"],"path.modules.12.updatedAt":["Date"],"path.modules.13.createdAt":["Date"],"path.modules.13.updatedAt":["Date"],"path.modules.14.createdAt":["Date"],"path.modules.14.updatedAt":["Date"],"path.modules.15.createdAt":["Date"],"path.modules.15.updatedAt":["Date"],"path.modules.16.createdAt":["Date"],"path.modules.16.updatedAt":["Date"],"path.modules.17.createdAt":["Date"],"path.modules.17.updatedAt":["Date"],"path.modules.18.createdAt":["Date"],"path.modules.18.updatedAt":["Date"],"path.modules.19.createdAt":["Date"],"path.modules.19.updatedAt":["Date"],"path.modules.20.createdAt":["Date"],"path.modules.20.updatedAt":["Date"],"path.modules.21.createdAt":["Date"],"path.modules.21.updatedAt":["Date"],"path.modules.22.createdAt":["Date"],"path.modules.22.updatedAt":["Date"],"path.modules.23.createdAt":["Date"],"path.modules.23.updatedAt":["Date"],"path.modules.24.createdAt":["Date"],"path.modules.24.updatedAt":["Date"],"path.modules.25.createdAt":["Date"],"path.modules.25.updatedAt":["Date"],"path.modules.26.createdAt":["Date"],"path.modules.26.updatedAt":["Date"],"path.modules.27.createdAt":["Date"],"path.modules.27.updatedAt":["Date"],"path.modules.28.createdAt":["Date"],"path.modules.28.updatedAt":["Date"],"path.modules.29.createdAt":["Date"],"path.modules.29.updatedAt":["Date"],"path.modules.30.createdAt":["Date"],"path.modules.30.updatedAt":["Date"],"path.modules.31.createdAt":["Date"],"path.modules.31.updatedAt":["Date"],"path.modules.32.createdAt":["Date"],"path.modules.32.updatedAt":["Date"],"path.modules.33.createdAt":["Date"],"path.modules.33.updatedAt":["Date"],"currentModule.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.0.createdAt","currentModule.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.0.updatedAt","nextModule.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.1.createdAt","nextModule.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.1.updatedAt","allModules.0.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.0.createdAt","allModules.0.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.0.updatedAt","allModules.1.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.1.createdAt","allModules.1.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.1.updatedAt","allModules.2.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.2.createdAt","allModules.2.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.2.updatedAt","allModules.3.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.3.createdAt","allModules.3.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.3.updatedAt","allModules.4.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.4.createdAt","allModules.4.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.4.updatedAt","allModules.5.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.5.createdAt","allModules.5.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.5.updatedAt","allModules.6.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.6.createdAt","allModules.6.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.6.updatedAt","allModules.7.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.7.createdAt","allModules.7.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.7.updatedAt","allModules.8.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.8.createdAt","allModules.8.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.8.updatedAt","allModules.9.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.9.createdAt","allModules.9.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.9.updatedAt","allModules.10.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.10.createdAt","allModules.10.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.10.updatedAt","allModules.11.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.11.createdAt","allModules.11.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.11.updatedAt","allModules.12.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.12.createdAt","allModules.12.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.12.updatedAt","allModules.13.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.13.createdAt","allModules.13.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.13.updatedAt","allModules.14.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.14.createdAt","allModules.14.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.14.updatedAt","allModules.15.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.15.createdAt","allModules.15.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.15.updatedAt","allModules.16.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.16.createdAt","allModules.16.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.16.updatedAt","allModules.17.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.17.createdAt","allModules.17.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.17.updatedAt","allModules.18.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.18.createdAt","allModules.18.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.18.updatedAt","allModules.19.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.19.createdAt","allModules.19.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.19.updatedAt","allModules.20.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.20.createdAt","allModules.20.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.20.updatedAt","allModules.21.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.21.createdAt","allModules.21.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.21.updatedAt","allModules.22.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.22.createdAt","allModules.22.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.22.updatedAt","allModules.23.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.23.createdAt","allModules.23.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.23.updatedAt","allModules.24.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.24.createdAt","allModules.24.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.24.updatedAt","allModules.25.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.25.createdAt","allModules.25.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.25.updatedAt","allModules.26.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.26.createdAt","allModules.26.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.26.updatedAt","allModules.27.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.27.createdAt","allModules.27.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.27.updatedAt","allModules.28.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.28.createdAt","allModules.28.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.28.updatedAt","allModules.29.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.29.createdAt","allModules.29.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.29.updatedAt","allModules.30.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.30.createdAt","allModules.30.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.30.updatedAt","allModules.31.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.31.createdAt","allModules.31.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.31.updatedAt","allModules.32.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.32.createdAt","allModules.32.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.32.updatedAt","allModules.33.createdAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.33.createdAt","allModules.33.updatedAt":"$46:props:state:queries:1:state:data:meta:values:path.modules.33.updatedAt"},"referentialEqualities":{"allModules":["path.modules"],"currentModule":["path.modules.0"],"nextModule":["path.modules.1"]},"v":1}},"dataUpdateCount":1,"dataUpdatedAt":1792316060681,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["learningPaths","getModule"],{"input":{"pathSlug":"data-quality-and-analytics-engineering","contentType":"LEARNING","contentSlug":"feature-engineering-mastery"},"type":"query"}],"queryHash":"[[\"learningPaths\",\"getModule\"],{\"input\":{\"contentSlug\":\"feature-engineering-mastery\",\"contentType\":\"LEARNING\",\"pathSlug\":\"data-quality-and-analytics-engineering\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060921,"state":{"data":{"json":{"id":"seed_c514e98b204bd1219affb5d0783386a7","slug":"feature-engineering-mastery","category":"Machine Learning","topic":"Feature Engineering & Selection","title":"Feature Engineering Mastery","description":"Master the art and science of feature engineering—the crucial bridge between raw data and powerful machine learning models. Learn to craft features that capture domain knowledge, create meaningful interactions, handle temporal patterns, and transform text and categorical data into model-ready representations.","difficulty":"INTERMEDIATE","estimatedMinutes":90,"pages":[{"id":"seed_56dd58a33d5534516199c7580e841f63","title":"Feature Types","order":0,"content":[{"id":"opening-hook","title":"The Atoms of Machine Learning","content":[{"data":{"content":"In chemistry, understanding atomic properties determines how elements combine into molecules. In machine learning, understanding **feature types** determines how data transforms into predictions. Features are the atomic units of machine learning—the individual measurements, attributes, and characteristics that models consume to make decisions.\n\nYet many practitioners treat features as interchangeable inputs, feeding whatever data they have into models without considering the fundamental nature of each variable. This approach leaves enormous predictive power on the table and often leads to subtle bugs that silently degrade model performance."},"type":"text"},{"data":{"icon":"Target","title":"What You Will Learn","content":"By the end of this page, you will have a rigorous understanding of feature type taxonomy—numerical, categorical, ordinal, binary, and derived features. You'll know how each type behaves mathematically, what encoding strategies they require, and which modeling assumptions they satisfy or violate. This foundation is essential for everything that follows in feature engineering.","variant":"info"},"type":"callout"}]},{"id":"feature-type-taxonomy","title":"The Feature Type Taxonomy","content":[{"data":{"content":"Before diving into individual feature types, we need to understand why this taxonomy matters. The type of a feature determines:\n\n- **Mathematical operations** that are valid (can you compute a mean?)\n- **Distance metrics** that are meaningful (is Euclidean distance sensible?)\n- **Encoding strategies** required for model consumption\n- **Preprocessing steps** needed (scaling, normalization, imputation)\n- **Model compatibility** (tree-based vs. linear vs. neural approaches)\n\nGetting feature types wrong doesn't cause obvious errors—models still train and produce predictions. But those predictions are based on mathematically incoherent operations, leading to degraded performance that's difficult to diagnose."},"type":"text"},{"data":{"rows":[["**Numerical (Continuous)**","Ordered, arithmetic meaningful, infinite precision theoretically","Temperature, price, height, duration","Scale-sensitive; requires normalization for many algorithms"],["**Numerical (Discrete)**","Ordered, countable, integer-valued","Age in years, count of items, number of children","May need binning; consider as continuous or categorical depending on cardinality"],["**Categorical (Nominal)**","Unordered classes, no arithmetic meaning","Country, color, product category, user ID","Requires encoding; high cardinality is challenging"],["**Categorical (Ordinal)**","Ordered classes, intervals not equal","Education level, satisfaction rating, size (S/M/L)","Order matters but magnitude doesn't; encoding must preserve order"],["**Binary**","Two mutually exclusive states","Yes/No, True/False, Male/Female, Purchased/Not","Special case of categorical; simple 0/1 encoding usually sufficient"],["**Derived/Composite**","Created from other features","Ratios, interactions, aggregations, embeddings","Type depends on construction; often where domain expertise shines"]],"caption":"Feature Type Taxonomy Overview","headers":["Feature Type","Mathematical Properties","Examples","Key Considerations"]},"type":"table"},{"data":{"icon":"AlertCircle","title":"Type Ambiguity is Common","content":"Real-world features often don't fit cleanly into one category. A 'star rating' (1-5) could be treated as ordinal, discrete numerical, or even continuous after averaging. Zip codes are numerical in representation but categorical in meaning. Always consider the semantic meaning, not just the data format.","variant":"warning"},"type":"callout"}],"titleType":"number","titleNumber":1},{"id":"numerical-features","title":"Numerical Features: Continuous and Discrete","content":[{"data":{"content":"Numerical features represent quantities where arithmetic operations are meaningful. The distinction between continuous and discrete is theoretically important but practically blurred—most algorithms treat them identically after preprocessing.\n\n**Continuous Numerical Features**\n\nContinuous features can theoretically take any value within a range. Examples include:\n- Physical measurements: height (cm), weight (kg), temperature (°C)\n- Financial values: price ($), revenue, stock returns\n- Temporal durations: seconds since event, session length\n- Derived metrics: click-through rate, conversion probability\n\nThese features have several key properties:"},"type":"text"},{"data":{"items":["**Arithmetic is meaningful** — Mean, standard deviation, and differences convey information. A temperature of 20°C is genuinely 'between' 10°C and 30°C.","**Scale matters** — A feature ranging 0-1 behaves differently than one ranging 0-1,000,000. Most algorithms are scale-sensitive.","**Distribution shape affects modeling** — Heavily skewed distributions often benefit from log or power transforms.","**Outliers have disproportionate influence** — Extreme values can dominate distance calculations and gradient updates.","**Missing values require careful imputation** — Mean, median, or model-based imputation each has tradeoffs."],"title":{"icon":"Zap","text":"Properties of Continuous Features","type":"icon","color":"primary","variant":"outline-circle"},"variant":"accent"},"type":"list"},{"data":{"content":"**Discrete Numerical Features**\n\nDiscrete features take countable values, typically integers:\n- Counts: number of purchases, page views, children\n- Rankings: position in search results, leaderboard rank\n- Indices: day of week (1-7), month (1-12), hour (0-23)\n\nThe key question with discrete numerics is **cardinality**:"},"type":"text"},{"data":{"rows":[["Very low (2-5)","Often better as categorical","Number of bedrooms"],["Low (5-20)","Could go either way","Age in decades"],["Medium (20-100)","Usually treat as numeric","Age in years"],["High (100+)","Almost always numeric","Days since signup"]],"headers":["Cardinality","Treatment Strategy","Example"]},"type":"table"},{"data":{"fileName":"numerical_feature_analysis.py","languages":[{"code":"$72","label":"Python","value":"python"}],"showLineNumbers":true},"type":"code"},{"data":{"icon":"Lightbulb","title":"The Scale Normalization Decision","content":"For tree-based models (Random Forest, XGBoost), scaling is unnecessary—trees split on thresholds regardless of scale. For linear models, SVMs, neural networks, and distance-based methods (k-NN, k-means), scaling is critical. When in doubt, standardize (z-score) or min-max normalize, but be aware that both approaches handle outliers differently.","variant":"tip"},"type":"callout"}],"titleType":"number","titleNumber":2},{"id":"categorical-features","title":"Categorical Features: Nominal and Ordinal","content":[{"data":{"content":"Categorical features represent discrete classes or groups. Unlike numerical features, arithmetic operations are meaningless—you cannot average 'red' and 'blue.' The fundamental distinction within categoricals is whether an **order** exists.\n\n**Nominal (Unordered) Categorical Features**\n\nNominal features have no inherent ordering. Any ordering you impose is arbitrary:\n- Geographic: country, city, region, timezone\n- Identity: user_id, product_sku, session_id\n- Classification: animal species, disease type, error category\n- Descriptive: color, brand, payment method\n\nThe critical insight: **assigning integers to categories implies a false ordering**. If you encode `{red: 1, blue: 2, green: 3}`, a linear model will treat green as 'more than' blue, which is semantically meaningless."},"type":"text"},{"data":{"items":["**One-Hot Encoding** — Creates binary column per category. Safe default but explodes dimensionality for high cardinality. Use for <50 categories typically.","**Dummy Encoding** — One-hot minus one column (reference category). Prevents multicollinearity in linear models. Preferred for regression.","**Target Encoding** — Replaces category with mean of target variable. Powerful but risks overfitting—requires careful regularization and cross-validation.","**Frequency Encoding** — Replaces category with its frequency in training data. Simple and often effective for high-cardinality features.","**Hashing Trick** — Hashes categories to fixed-size vector. Handles unseen categories but introduces collisions. Good for very high cardinality.","**Embedding Layers** — Learns dense vector representation. Best for neural networks with high cardinality (user_id, product_id)."],"title":{"icon":"Target","text":"Nominal Feature Encoding Strategies","type":"icon","color":"primary","variant":"outline-circle"},"variant":"accent"},"type":"list"},{"data":{"content":"**Ordinal Categorical Features**\n\nOrdinal features have meaningful order but non-uniform intervals:\n- Education: high school < bachelor's < master's < PhD\n- Satisfaction: very unsatisfied < unsatisfied < neutral < satisfied < very satisfied\n- Size: small < medium < large < extra-large\n- Quality grade: F < D < C < B < A\n\nThe challenge: the **gaps between categories are semantically unequal**. The jump from 'unsatisfied' to 'neutral' might be psychologically larger than 'satisfied' to 'very satisfied.'"},"type":"text"},{"data":{"rows":[["**Integer Encoding**","Map to 0, 1, 2, ..., k-1","✓ Yes","✗ Assumes equal","Tree models; quick baseline"],["**Custom Mapping**","Domain-informed numeric values","✓ Yes","~ Approximated","When domain knowledge suggests intervals"],["**Target-Based Ordering**","Order by target correlation","✓ Yes","~ Data-driven","When order is uncertain or task-specific"],["**Treat as Nominal**","One-hot encoding","✗ Lost","N/A","When interval uncertainty is high; linear models"]],"caption":"Ordinal Encoding Strategies","headers":["Strategy","Description","Preserves Order","Preserves Intervals","Use Case"]},"type":"table"},{"data":{"fileName":"categorical_encoding.py","languages":[{"code":"$73","label":"Python","value":"python"}],"showLineNumbers":true},"type":"code"},{"data":{"icon":"AlertCircle","title":"The High-Cardinality Challenge","content":"Features like user_id, product_sku, or IP address can have millions of unique values. One-hot encoding is impractical (millions of columns). Target encoding risks overfitting (some categories appear once). Hashing causes collisions. Embeddings require neural architectures. There's no perfect solution—choose based on model type, data volume, and acceptable complexity.","variant":"warning"},"type":"callout"}],"titleType":"number","titleNumber":3},{"id":"binary-features","title":"Binary Features: The Special Case","content":[{"data":{"content":"Binary features represent exactly two mutually exclusive states. While technically categorical, they deserve special treatment due to their simplicity and ubiquity.\n\n**Common Binary Feature Types:**"},"type":"text"},{"data":{"rows":[["Boolean flags","is_verified, has_subscription, email_confirmed"],["Presence/absence","clicked, purchased, churned, converted"],["Binary classification","pass/fail, spam/ham, positive/negative"],["Demographic","gender (when binary), citizen/non-citizen"],["Threshold-based","high_value_customer, above_median_income"]],"headers":["Category","Examples"]},"type":"table"},{"data":{"content":"**Encoding is trivial**: 0/1 representation works for virtually all algorithms. The main considerations are semantic clarity and handling edge cases."},"type":"text"},{"data":{"items":["**Consistent semantics** — Decide whether 1 means 'positive' or 'present' and stick with it. Don't mix is_churned (1=bad) with is_active (1=good) without clear documentation.","**Handle missing values explicitly** — A missing 'has_subscription' might mean 'unknown' (impute or model) vs 'not applicable' (should be 0 or separate category).","**Consider class imbalance** — Binary features that are 99% one class carry little information for splits but may be critical for the 1% case.","**Watch for data leakage** — Binary labels created after observation time (is_churned_30days) can leak future information if not handled carefully.","**Aggregation context** — Mean of a binary feature gives the rate (click-through rate, conversion rate), which is often more useful than raw counts."],"title":{"icon":"CheckCircle","text":"Binary Feature Best Practices","type":"icon","color":"primary","variant":"outline-circle"},"variant":"accent"},"type":"list"},{"data":{"content":"**Creating Binary Features from Other Types**\n\nBinary features are often derived by thresholding or categorizing other feature types:\n\n```python\n# From numerical: thresholding\ndf['is_high_income'] = (df['income'] > 100000).astype(int)\ndf['is_adult'] = (df['age'] >= 18).astype(int)\n\n# From categorical: presence detection\ndf['is_premium_member'] = (df['membership_type'] == 'premium').astype(int)\ndf['is_us_based'] = df['country'].isin(['US', 'USA', 'United States']).astype(int)\n\n# From text: pattern matching\ndf['has_email'] = df['email'].notna().astype(int)\ndf['mentions_discount'] = df['review_text'].str.contains('discount|coupon|sale', case=False).astype(int)\n```\n\nThese derived binaries often capture domain-specific thresholds that are more predictive than the raw values."},"type":"text"}],"titleType":"number","titleNumber":4},{"id":"feature-type-relationships","title":"Feature Type Relationships and Conversions","content":[{"data":{"content":"Features types aren't fixed—they can be converted based on modeling needs. Understanding these conversions and their tradeoffs is essential for effective feature engineering.\n\n**Information Flow in Conversions:**\n\n```\nContinuous → Discrete → Ordinal → Nominal → Binary\n ↓ ↓ ↓ ↓ ↓\n (binning) (ordering) (collapse) (one-hot) (present)\n \nEach arrow represents INFORMATION LOSS.\nReverse arrows (binned → continuous) recover approximations, not originals.\n```"},"type":"text"},{"data":{"rows":[["Continuous","Discrete","Rounding, floor, ceiling","Loses precision; useful for counts or when precision is noise"],["Continuous","Ordinal","Quantile binning, equal-width binning","Loses magnitude; gains robustness to outliers"],["Continuous","Binary","Thresholding","Major information loss; captures only one split point"],["Discrete","Categorical","Treat values as labels","Loses numerical relationships; gains flexibility"],["Ordinal","Nominal","Ignore ordering","Loses order information; may be necessary for fair one-hot"],["Ordinal","Numerical","Integer coding","Assumes equal intervals (may be false)"],["Categorical","Binary (each)","One-hot encoding","Preserves all; explodes dimensionality"],["Categorical","Numerical","Target/frequency encoding","Summarizes via statistics; risks leakage"]],"caption":"Feature Type Conversion Matrix","headers":["From","To","Method","Information Impact"]},"type":"table"},{"data":{"icon":"Lightbulb","title":"When to Convert Types","content":"Convert continuous → binned when: outliers cause problems, relationship is non-linear and bins capture it, or interpretability matters. Convert categorical → numerical when: high cardinality makes one-hot impractical, target encoding reduces overfitting via smoothing, or embedding layers aren't available. Keep original features when possible—let the model discover the best representation.","variant":"tip"},"type":"callout"}],"titleType":"number","titleNumber":5},{"id":"identifying-types","title":"Identifying Feature Types in Practice","content":[{"data":{"content":"Real datasets rarely come with explicit type annotations. The data format (int, float, string) is a clue but not definitive. Here's a systematic approach to type identification:"},"type":"text"},{"data":{"fileName":"feature_type_detection.py","languages":[{"code":"$74","label":"Python","value":"python"}],"showLineNumbers":true},"type":"code"},{"data":{"items":["**Zip codes** — Stored as integers but semantically categorical. Arithmetic is meaningless (10001 + 10002 ≠ meaningful).","**Phone numbers, SSNs, IDs** — Numeric format but identifier semantics. Never treat as numerical.","**Dates as integers** — YYYYMMDD format needs datetime parsing, not numeric treatment.","**Boolean as 1/2 or Yes/No** — May need recoding to 0/1 for proper binary handling.","**Ratings stored as floats** — Often discrete ordinal despite float dtype (1.0, 2.0, 3.0...).","**Encoded categoricals** — Previous label encoding makes categoricals look numeric. Check data dictionary."],"title":{"icon":"AlertCircle","text":"Common Type Identification Pitfalls","type":"icon","color":"accent","variant":"outline-circle"},"variant":"glass"},"type":"list"}],"titleType":"number","titleNumber":6},{"id":"summary","title":"Summary: Mastering Feature Types","content":[{"data":{"content":"Feature types are the foundation of feature engineering. Getting them right enables all subsequent transformations; getting them wrong corrupts your entire modeling pipeline. Here are the key takeaways:"},"type":"text"},{"data":{"type":"ordered","items":["**Numerical features** allow arithmetic but require scaling for many algorithms. Distinguish continuous from discrete based on cardinality and domain meaning.","**Categorical features** require encoding. Nominal features need one-hot or similar; ordinal features need order-preserving encoding. High cardinality requires special techniques.","**Binary features** are simple but ubiquitous. Consistent semantics and careful missing value handling are essential.","**Type conversions trade information for structure**. Binning loses precision but gains robustness; encoding compresses categories but may distort relationships.","**Always verify types semantically**, not just by data format. Zip codes aren't numerical; ratings might be ordinal despite integer storage.","**When uncertain, try multiple representations**. Let model performance guide the choice between treating a feature as categorical vs. numerical."],"title":{"icon":"CheckCircle","text":"Key Takeaways","type":"icon","color":"primary","variant":"outline-circle"},"variant":"accent"},"type":"list"},{"data":{"icon":"CheckCircle","title":"Page Complete","content":"You now have a rigorous understanding of feature types—the atomic units of machine learning. Next, we'll explore how domain knowledge transforms raw features into powerful predictors that capture business and scientific understanding.","variant":"success"},"type":"callout"}],"titleType":"number","titleNumber":7}],"isLocked":false},{"id":"seed_842f4a11ba72179bd359958a69c32a08","title":"Domain Knowledge","order":1,"content":null,"isLocked":true},{"id":"seed_0e74c9a08deb29e70b8fc92ba3fe99ed","title":"Interaction Features","order":2,"content":null,"isLocked":true},{"id":"seed_a46bdb1443418ed68ebb0bc3223d5a9d","title":"Time-Based Features","order":3,"content":null,"isLocked":true},{"id":"seed_09805d9c32a742bd2a525f9770161506","title":"Text and Categorical","order":4,"content":null,"isLocked":true}]}},"dataUpdateCount":1,"dataUpdatedAt":1792316060847,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["learningContent","getModule"],{"input":{"slug":"feature-engineering-mastery"},"type":"query"}],"queryHash":"[[\"learningContent\",\"getModule\"],{\"input\":{\"slug\":\"feature-engineering-mastery\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060922,"state":{"data":{"json":null},"dataUpdateCount":1,"dataUpdatedAt":1792316060914,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["learningContent","getProgress"],{"input":{"moduleId":"seed_c514e98b204bd1219affb5d0783386a7"},"type":"query"}],"queryHash":"[[\"learningContent\",\"getProgress\"],{\"input\":{\"moduleId\":\"seed_c514e98b204bd1219affb5d0783386a7\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060922,"state":{"data":{"json":null},"dataUpdateCount":1,"dataUpdatedAt":1792316060916,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["feedback","get"],{"input":{"contentType":"LEARNING_PAGE","contentId":"seed_a46bdb1443418ed68ebb0bc3223d5a9d"},"type":"query"}],"queryHash":"[[\"feedback\",\"get\"],{\"input\":{\"contentId\":\"seed_a46bdb1443418ed68ebb0bc3223d5a9d\",\"contentType\":\"LEARNING_PAGE\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060923,"state":{"data":{"json":null},"dataUpdateCount":1,"dataUpdatedAt":1792316060916,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["feedback","getUserLike"],{"input":{"contentType":"LEARNING_PAGE","contentId":"seed_a46bdb1443418ed68ebb0bc3223d5a9d"},"type":"query"}],"queryHash":"[[\"feedback\",\"getUserLike\"],{\"input\":{\"contentId\":\"seed_a46bdb1443418ed68ebb0bc3223d5a9d\",\"contentType\":\"LEARNING_PAGE\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060923,"state":{"data":{"json":[]},"dataUpdateCount":1,"dataUpdatedAt":1792316060916,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"success","fetchStatus":"idle"},"queryKey":[["highlights","getHighlights"],{"input":{"contentType":"LEARNING_PAGE","contentId":"seed_a46bdb1443418ed68ebb0bc3223d5a9d"},"type":"query"}],"queryHash":"[[\"highlights\",\"getHighlights\"],{\"input\":{\"contentId\":\"seed_a46bdb1443418ed68ebb0bc3223d5a9d\",\"contentType\":\"LEARNING_PAGE\"},\"type\":\"query\"}]"},{"dehydratedAt":1792316060923,"state":{"data":"$undefined","dataUpdateCount":0,"dataUpdatedAt":0,"error":null,"errorUpdateCount":0,"errorUpdatedAt":0,"fetchFailureCount":0,"fetchFailureReason":null,"fetchMeta":null,"isInvalidated":false,"status":"pending","fetchStatus":"fetching"},"queryKey":[["highlights","getPopularHighlights"],{"input":{"contentType":"LEARNING_PAGE","contentId":"seed_a46bdb1443418ed68ebb0bc3223d5a9d","minCount":2},"type":"query"}],"queryHash":"[[\"highlights\",\"getPopularHighlights\"],{\"input\":{\"contentId\":\"seed_a46bdb1443418ed68ebb0bc3223d5a9d\",\"contentType\":\"LEARNING_PAGE\",\"minCount\":2},\"type\":\"query\"}]","promise":"$@75"}]},"children":"$L76"}]