0% found this document useful (0 votes)
6 views2 pages

Data Mapping for Stock Telemetry Analysis

Uploaded by

kumarkartikeyean
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views2 pages

Data Mapping for Stock Telemetry Analysis

Uploaded by

kumarkartikeyean
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

🧠 The Great Data Shuffle

## Objective
You are given a dataset of time-series telemetry with misleading column names. Your
task is to reverse-engineer the actual meaning of each column by analyzing
patterns, relationships, and statistical clues in the data.

## Data Details
You are provided with a CSV containing the following fabricated fields:
- deltaX
- gamma
- omega
- flux
- pulse
- neutronCount

These DO NOT represent their real-world meaning. Instead they represent one of the
following values regarding some stock: open, high, low, close, price, volume.

---

## Deliverables (All Mandatory)

1. 📌 **Final Mapping File (`[Link]`)**


- A JSON file specifying your mapping from fabricated names to real field names.

2. 📊 **Justification Notebook (`[Link]`)**


- Must include:
- Summary statistics for all columns
- Visualizations (histograms, correlations, candlestick reconstructions)
- Clear explanation of how you mapped each column

3. 🧪 **Validation Script (`validate_mapping.py`)**


- Should read your mapping and verify integrity (e.g., `low ≤ close ≤ high`,
`volume` should be largest magnitude, etc.)

4. 📄 **Short Write-up (`thought_process.md`)**


- 300–500 words summarizing your reasoning, confidence, and process. What rules
did you use? What were your doubts?

5. (Bonus - Optional) ⭐ **Confidence Scores**


- Include in `[Link]` a confidence score between 0.0 and 1.0 for each
guess:
```json
{
"deltaX": {"mapping": "open", "confidence": 0.8},
...
}
```

---

## Evaluation Rubric

| Category | Max Points | Notes |


|------------------------------|------------|-------|
| Final Mapping Accuracy | 30 | Based on correct field identification
|
| Justification Quality | 20 | Reasoning must be rigorous, not
guesses |
| Visual & Statistical Analysis| 15 | Effective use of plots and summaries
|
| Validation Script Logic | 15 | Script catches structural errors
properly |
| Thought Process Write-up | 10 | Structured, clear, insightful |
| (Opt) Confidence Calibration | +10 | Rewarded for well-calibrated guesses
|

---

## Constraints
- Do NOT rely on column names.
- The dataset contains only 25% of the full data on which it will be finally
evaluated. Your logic should generalize.
- No internet access or external data allowed.
- Auto-generated or random guesses without justification will be penalized.

---

## Submission Format
Please submit a ZIP file containing:
- `[Link]`
- `[Link]`
- `validate_mapping.py`
- `thought_process.md`

Common questions

Powered by AI

The evaluation rubric for the Great Data Shuffle task assigns a maximum of 30 points for Final Mapping Accuracy, assessing whether the fabricated names have been correctly identified as real-world stock-related values, which is central to the task's goal. Justification Quality is worth 20 points, rewarding rigorous reasoning and reflective assessment rather than mere guessing. Visual & Statistical Analysis has 15 points, emphasizing the importance of utilizing plots and data summaries effectively to inform mapping decisions. Validation Script Logic is valued at 15 points, ensuring the script effectively verifies mapping correctness through structural checks, such as logical constraints on data numerical relationships. The Thought Process Write-up is worth 10 points, focusing on structured and insightful reflection on the thought process and reasoning. An optional 10 points are available for accurately calibrated Confidence Scores, rewarding precise self-assessment of mapping accuracy.

The constraints imposed on the dataset exploration in the Great Data Shuffle task include a prohibition on relying on column names for data analysis, as the names are intentionally misleading. The dataset provided represents only 25% of the full data set, suggesting the need for generalizability in the analysis logic, preventing overfitting to the current subset. Furthermore, external data and internet access are disallowed, requiring the analysis to be purely based on the data provided. These constraints necessitate a robust analytical approach that can identify patterns and relationships through statistical methods and visualization alone, ensuring the mappings are based on intrinsic data characteristics rather than any preconceived notions or outside information.

The 'Thought Process Write-up' contributes significantly to the success of the Great Data Shuffle task submission by capturing and communicating the decision-making processes, rationale, and insights gained throughout the mapping project. It provides a structured narrative that explains not only the conclusions reached but also the reasoning underpinning these judgments, highlighting the methodologies and rules applied, the insights and patterns recognized, as well as any doubts or challenges encountered. This reflective component supports the credibility of the task by illustrating the thoroughness, diligence, and analytical depth undertaken during the project, enhancing the evaluator's understanding and appreciation of the process behind the final deliverables. It represents 10 points in the evaluation rubric, emphasizing the importance of communicative clarity and insightfulness.

Summary statistics are invaluable tools in the mapping process of the Great Data Shuffle task as they provide initial insights into the fundamental characteristics of each dataset column. Key statistics, such as mean and median, help estimate typical values, which can hint at price-related columns if values are moderate or volume-related if substantially higher. Standard deviation reveals variability, which in high amounts could imply stock prices, while lower variability may suggest stable data like volume. Range and quartiles help determine the spread and concentration of data, assisting in ruling out columns that do not fit financially logical bounds, such as negative prices. Together, these statistical measures offer clues towards understanding which fabricated columns might best correspond to real-world stock values like open, high, low, close, price, or volume.

Generalization beyond the 25% sample dataset is crucial in the Great Data Shuffle task because the final evaluation will occur on a full dataset, and the logic must remain effective when scaling. Generalization ensures that the mappings are based on intrinsic characteristics and patterns which are consistent irrespective of sample size, as opposed to being an overfit specific to the small subset provided. This requirement mitigates the risk of inaccurate conclusions and reinforces the reliability of the analytical methods employed. It guarantees that the mapping logic is based on structural and statistical robustness, leading to correct identifications across different datasets, ultimately contributing to achieving high accuracy and effectiveness under diverse conditions.

In the Great Data Shuffle task, visualizations can be effectively utilized to identify correct mappings of misleading column names to stock values by revealing data patterns and relationships that align with characteristics of known financial data. Histograms can illustrate the distribution of column data, helping infer if a column could represent volume or price, based on common statistical distributions observed in these metrics. Correlation matrices can visualize relationships between columns, identifying pairs of columns that might represent related stock metrics, such as open and close prices. Candlestick reconstructions can simulate price movements using different combinations of columns until realistic patterns are identified, matching known stock behavior. These visual tools help discern and interpret data characteristics that suggest particular mapping assignments, supporting rigorous, evidence-based reasoning in the absence of direct name clues.

The key deliverables for the Great Data Shuffle task include: 1) the Final Mapping File (`mapping.json`), which specifies the mapping from fabricated dataset column names to their corresponding real-world names, contributing by organizing the results of the analysis; 2) the Justification Notebook (`analysis.ipynb`), which must include summary statistics, visualizations, and explanations for the mappings, providing needed evidence and reasoning; 3) the Validation Script (`validate_mapping.py`), which checks the integrity of the mappings by ensuring logical data constraints are met, thereby ensuring the mappings' accuracy; and 4) the Short Write-up (`thought_process.md`), that summarizes the reasoning, decision-making process, and confidence level in the mappings, offering insights into the thought process. Bonus deliverable includes Confidence Scores, providing optional quantitative assessment of the mapping accuracy. Each deliverable contributes by offering clarity, evidence, reliability, and insight into the task's solution approach.

Ensuring the validation script in the Great Data Shuffle task catches structural errors is necessary to verify that logical data constraints, which define the validity of the mapped data, are correctly applied. These constraints act as filters to prevent incorrect mappings that defy basic financial principles. Typical logical constraints include ensuring that the low value is never higher than the close or open values, and that the close value falls between the low and high values, which are financial norms. Moreover, volume is expected to have a larger magnitude compared to price data, often expressed in thousands. By leveraging these logical constraints, the validation script helps confirm that the resultant data mappings do not only reflect potential accuracies from statistical analysis but also adhere to real-world financial data relationships and rules.

The rule against using column names directly impacts analysis in the Great Data Shuffle task by forcing the analyst to rely on statistical and pattern-based evidence rather than assumptions linked to potentially misleading names. This encourages a more rigorous approach, emphasizing the examination of data distributions, correlations, and behaviors specific to each column. Analysts must employ exploratory data analysis techniques, like visualizations and statistical summaries, to deduce the true nature of the data columns. By prohibiting direct reliance on column names, the task necessitates a deeper exploration and understanding of the dataset, ensuring that mapping decisions are data-driven and not biased by potentially incorrect naming conventions.

Including confidence scores in the `mapping.json` file for the Great Data Shuffle task is important as it provides a quantitative self-assessment of the accuracy and reliability of each mapping decision. Although optional, this deliverable allows for transparent communication of uncertainty, demonstrating the mapper's level of certainty about the correct identification of each fabricated column name. It enhances the overall quality by encouraging evaluators to consider the degree of confidence in potentially uncertain mappings, thereby acknowledging the inherent complexities and potential ambiguities in the task. Well-calibrated confidence scores can earn up to 10 bonus points, recognizing their added value in conveying thoroughness and introspective evaluation in the decision-making process.

You might also like