Skip to content

Add Messy Column Fixer recipe#5062

Merged
agiuliano-square merged 3 commits intoblock:mainfrom
the-matrixneo:messy-column-fixer-recipe
Oct 8, 2025
Merged

Add Messy Column Fixer recipe#5062
agiuliano-square merged 3 commits intoblock:mainfrom
the-matrixneo:messy-column-fixer-recipe

Conversation

@the-matrixneo
Copy link
Copy Markdown
Contributor

@the-matrixneo the-matrixneo commented Oct 8, 2025

Summary

This PR introduces the Messy Column Fixer, a new recipe for the Cookbook. This tool provides users with a workflow to automatically clean and normalize CSV files. The recipe scans a provided CSV to detect common data quality issues such as mixed data types, missing values, and formatting inconsistencies.

Extension Usage:

  1. filesystem:
    This declares that the recipe needs access to the file system.

Type of Change

  • Feature
  • Bug fix
  • Refactor / Code quality
  • Performance improvement
  • Documentation
  • Tests
  • Security fix
  • Build / Release
  • Other (specify below)

Testing

This recipe was tested manually using the Goose UI to ensure its functionality and user interaction are correct.
Steps:

  1. The "Messy Column Fixer" recipe was loaded and run in the application.
  2. A sample of messy CSV data, containing missing fields and inconsistent formatting, was provided as input.
  3. The agent's output was reviewed for correctness.
    Verification:
    As shown in the test screenshot, the recipe successfully:
  • Parsed the raw CSV input.
  • Identified empty or missing values and replaced them with "N/A".
  • Presented the cleaned data in a clear and correctly formatted markdown table.

This confirms the core logic of the recipe is working as expected in a real-world environment.
goose-testing

Related Issues

Relates to #4994

Email: [email protected]

@the-matrixneo the-matrixneo requested a review from a team as a code owner October 8, 2025 10:47
@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

❌ Recipe Validation Failed

Please fix the validation errors and push your changes:

❌ messy-column-fixer.yaml: INVALID\n\n✗ extensions: invalid type: map, expected a sequence at line 29 column 5 Error: extensions: invalid type: map, expected a sequence at line 29 column 5\n\n

📚 Check our Recipe Guide for help with the correct format.

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

🔍 Recipe Security Scan Results

✅ Status: APPROVED - All recipes passed security scan

📊 Scan Summary:

  • Total recipes scanned: 1

📋 Individual Recipe Results:
✅ Recipe 1: APPROVED (LOW risk)

🔗 View detailed scan results in the workflow artifacts.

@the-matrixneo
Copy link
Copy Markdown
Contributor Author

the-matrixneo commented Oct 8, 2025

Hey @taniandjerry!
can you please review the PR and merge it.

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

✅ Recipe Validation Passed

Your recipe(s) are valid and ready for review!

🔍 Next Steps:

  1. Our team will review your recipe
  2. If approved, we'll run a security scan
  3. Once merged, you'll receive $10 in OpenRouter credits (if email provided)

Thanks for contributing to the goose Recipe Cookbook! 🎉

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

🔍 Recipe Security Scan Results

✅ Status: APPROVED - All recipes passed security scan

📊 Scan Summary:

  • Total recipes scanned: 1

📋 Individual Recipe Results:
✅ Recipe 1: APPROVED (LOW risk)

🔗 View detailed scan results in the workflow artifacts.

@the-matrixneo the-matrixneo force-pushed the messy-column-fixer-recipe branch from b7ce063 to 4254264 Compare October 8, 2025 12:22
@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

✅ Recipe Validation Passed

Your recipe(s) are valid and ready for review!

🔍 Next Steps:

  1. Our team will review your recipe
  2. If approved, we'll run a security scan
  3. Once merged, you'll receive $10 in OpenRouter credits (if email provided)

Thanks for contributing to the goose Recipe Cookbook! 🎉

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

🔍 Recipe Security Scan Results

✅ Status: APPROVED - All recipes passed security scan

📊 Scan Summary:

  • Total recipes scanned: 1

📋 Individual Recipe Results:
✅ Recipe 1: APPROVED (LOW risk)

🔗 View detailed scan results in the workflow artifacts.

@taniacryptid taniacryptid added hacktoberfest Issues awarding points for Hacktoberfest 2025! small Weight label for Hacktoberfest 2025 issues labels Oct 8, 2025
@taniacryptid
Copy link
Copy Markdown
Collaborator

taniacryptid commented Oct 8, 2025

Thank you so much for your contribution! Let me make sure @EbonyLouis and @iandouglas have a chance to review.

agiuliano-square
agiuliano-square reviewed Oct 8, 2025
View reviewed changes
Copy link
Copy Markdown
Contributor

@agiuliano-square agiuliano-square left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks for your contribution @the-matrixneo! Just left a few comments to tidy things up a bit.

documentation/src/pages/recipes/data/recipes/messy-column-fixer.yaml Outdated
- Statistics before and after cleaning
- Save the cleaned CSV file with "_cleaned" suffix

prompt_chain:
Copy link
Copy Markdown
Contributor

@agiuliano-square agiuliano-square Oct 8, 2025

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This is also not a supported field. We'll want to delete this.

iandouglas
iandouglas suggested changes Oct 8, 2025
View reviewed changes
@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

✅ Recipe Validation Passed

Your recipe(s) are valid and ready for review!

🔍 Next Steps:

  1. Our team will review your recipe
  2. If approved, we'll run a security scan
  3. Once merged, you'll receive $10 in OpenRouter credits (if email provided)

Thanks for contributing to the goose Recipe Cookbook! 🎉

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

🔍 Recipe Security Scan Results

❌ Status: BLOCKED - One or more recipes have MEDIUM risk or higher

⚠️ Merge Protection: This PR cannot be merged until security concerns are addressed.
Repository maintainers can override this decision if needed.

📊 Scan Summary:

  • Total recipes scanned: 1
  • Blocked recipes: 1

📋 Individual Recipe Results:
✅ Recipe 1: APPROVED (MEDIUM risk)

🔗 View detailed scan results in the workflow artifacts.

@iandouglas
Copy link
Copy Markdown
Contributor

iandouglas commented Oct 8, 2025

at a glance, the recipe looks fine to me, not sure why the security scanner is flagging it as medium risk, i'm rerunning an analysis on it to be sure.

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Oct 8, 2025

🔍 Recipe Security Scan Results

✅ Status: APPROVED - All recipes passed security scan

📊 Scan Summary:

  • Total recipes scanned: 1

📋 Individual Recipe Results:
✅ Recipe 1: APPROVED (LOW risk)

🔗 View detailed scan results in the workflow artifacts.

@agiuliano-square agiuliano-square merged commit 384c076 into block:main Oct 8, 2025
14 of 15 checks passed
@alexhancock alexhancock mentioned this pull request Oct 9, 2025
Closed
michaelneale added a commit that referenced this pull request Oct 9, 2025
@michaelneale
Merge branch 'main' into micn/goose-swarm
04731df 
* main: (170 commits)
  Applied server side call to parse and save recipe (#5022)
  feat(prompt-library): add Code Documentation Migrator intermediate prompt (#4996) (#5051)
  Add Messy Column Fixer recipe (#5062)
  Cleanup temp files (#5081)
  add openmetadata recipe (#5076)
  Fix Hacktoberfest Leaderboard (#5080)
  adding brand guidelines to AGENTS.md (#4887)
  Fix: Prevent cross-contamination of cache data across analysis modes for `analyze` tool (#5075)
  fix: remove circular reference (#5018)
  Introduced a new prompt for content amplification that integrates multi-step workflows using official Goose extensions. Closes Issue #4998 (#5050)
  Add hint for focus mode when used on file paths for `analyze` tool (#5069)
  fix: use dynamic port allocation for OAuth server (#5019)
  Art vandelay: Import & Export (#5053)
  docs: misc updates for extensions directory (#5035)
  updating recipe scanner workflows for detecting recipes from forked repos (#5056)
  feat(prompt-library): add Smart Meeting Assistant advanced prompt (#4998) (#5031)
  Allow auto focus and typing while chat is initializing (#5043)
  docs(blog): Add blog for running Goose in containerized envs  (#5052)
  fix: Add WINDOWS_CODESIGN_CERTIFICATE to nightly workflow (#5037)
  Developer `analyze` tool improvement (#5030)
  ...
tlongwell-block added a commit that referenced this pull request Oct 10, 2025
@tlongwell-block
Merge remote-tracking branch 'origin/main' into moim2
811da83 
* origin/main:
  Improve Rust analysis output for `analyze` tool (#5072)
  Remove duplicate prepare_reply_context call (#5063)
  install react dev tools in development (#4979)
  Doc: Added powershell installation link to the guide (#5012)
  draft of new blog post about automating more automation (#5038)
  Subagent extension selection behavior fix (#5093)
  Add dev and alpha environment indicator (#5092)
  docs: add content carousel (#5086)
  Applied server side call to parse and save recipe (#5022)
  feat(prompt-library): add Code Documentation Migrator intermediate prompt (#4996) (#5051)
  Add Messy Column Fixer recipe (#5062)
  Cleanup temp files (#5081)
  add openmetadata recipe (#5076)
  Fix Hacktoberfest Leaderboard (#5080)
  adding brand guidelines to AGENTS.md (#4887)
  Fix: Prevent cross-contamination of cache data across analysis modes for `analyze` tool (#5075)
  fix: remove circular reference (#5018)
  Introduced a new prompt for content amplification that integrates multi-step workflows using official Goose extensions. Closes Issue #4998 (#5050)
  Add hint for focus mode when used on file paths for `analyze` tool (#5069)
  fix: use dynamic port allocation for OAuth server (#5019)
@taniacryptid taniacryptid mentioned this pull request Oct 10, 2025
Closed
5 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

2 more reviewers

@iandouglas iandouglas iandouglas approved these changes

@agiuliano-square agiuliano-square agiuliano-square approved these changes

Reviewers whose approvals may not affect merge requirements

Assignees

@the-matrixneo the-matrixneo

Labels

hacktoberfest Issues awarding points for Hacktoberfest 2025! hacktoberfest-accepted small Weight label for Hacktoberfest 2025 issues

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

4 participants

@the-matrixneo @taniacryptid @iandouglas @agiuliano-square