{"id":4010,"date":"2025-04-12T12:53:54","date_gmt":"2025-04-12T12:53:54","guid":{"rendered":"https:\/\/erikap.co.uk\/?page_id=4010"},"modified":"2025-04-13T09:54:46","modified_gmt":"2025-04-13T09:54:46","slug":"weekend-meal-planner","status":"publish","type":"page","link":"https:\/\/erikap.co.uk\/?page_id=4010","title":{"rendered":"Weekend Meal Planner"},"content":{"rendered":"

[et_pb_section fb_built=”1″ fullwidth=”on” admin_label=”Page Header” _builder_version=”4.27.4″ _module_preset=”3c901e30-8c7f-4173-af71-9e53c9b0862a” background_image=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/pexels-karolina-grabowska-4199098-scaled.jpg” parallax=”off” background_position=”bottom_center” background_vertical_offset=”35%” global_colors_info=”{}”][et_pb_fullwidth_header title=”Weekend Meal Planner” text_orientation=”center” admin_label=”Hero Section” _builder_version=”4.27.4″ _module_preset=”default” title_font=”Montserrat|on|||” title_font_size=”60px” title_line_height=”1.4em” content_font_size=”22px” content_line_height=”1.8em” subhead_font=”||||” background_color=”rgba(255, 255, 255, 0)” use_background_color_gradient=”on” background_color_gradient_stops=”rgba(58,52,226,0.93) 0%|rgba(73,108,220,0.7) 100%” background_color_gradient_start=”rgba(58,52,226,0.93)” background_color_gradient_end=”rgba(73,108,220,0.7)” custom_button_one=”on” button_one_text_size=”16px” button_one_bg_color=”#6eba01″ button_one_border_width=”2px” button_one_border_color=”#6eba01″ button_one_border_radius=”0″ button_one_letter_spacing=”2″ button_one_font=”Montserrat|||on|” button_one_use_icon=”off” custom_button_two=”on” button_two_text_size=”16px” button_two_border_width=”2px” button_two_border_color=”#ffffff” button_two_border_radius=”0″ button_two_letter_spacing=”2″ button_two_font=”Montserrat|||on|” button_two_use_icon=”off” module_alignment=”left” animation_style=”fade” button_one_text_color_hover=”#6eba01″ button_two_text_color_hover=”#6eba01″ button_one_border_color_hover=”#ffffff” button_two_border_color_hover=”#ffffff” button_one_border_radius_hover=”0″ button_two_border_radius_hover=”0″ button_one_letter_spacing_hover=”2″ button_two_letter_spacing_hover=”2″ button_one_bg_color_hover=”#ffffff” button_two_bg_color_hover=”#ffffff” global_colors_info=”{}” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_one_text_color__hover_enabled=”on” button_one_text_color__hover=”#6eba01″ button_two_text_color__hover_enabled=”on” button_two_text_color__hover=”#6eba01″ button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_one_border_color__hover_enabled=”on” button_one_border_color__hover=”#ffffff” button_two_border_color__hover_enabled=”on” button_two_border_color__hover=”#ffffff” button_one_border_radius__hover_enabled=”on” button_one_border_radius__hover=”0″ button_two_border_radius__hover_enabled=”on” button_two_border_radius__hover=”0″ button_one_letter_spacing__hover_enabled=”on” button_one_letter_spacing__hover=”2″ button_two_letter_spacing__hover_enabled=”on” button_two_letter_spacing__hover=”2″ button_one_bg_color__hover_enabled=”on” button_one_bg_color__hover=”#ffffff” button_two_bg_color__hover_enabled=”on” button_two_bg_color__hover=”#ffffff”]<\/p>\n

SQL Recipe Recommender<\/p>\n

 <\/p>\n

[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Projects” _builder_version=”4.16″ _module_preset=”default” custom_padding=”90px||90px|” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ _module_preset=”default” background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”45px|0px|45px|0px” custom_width_px=”710px” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” background_position=”top_left” custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_divider color=”#4e5ed0″ divider_weight=”3px” disabled_on=”off|off|off” _builder_version=”4.16″ _module_preset=”default” background_color_gradient_direction=”90deg” max_width=”100px” module_alignment=”center” height=”5px” custom_margin=”||20px|” custom_padding=”||20px|” animation_style=”slide” animation_direction=”bottom” saved_tabs=”all” locked=”off” global_colors_info=”{}”][\/et_pb_divider][et_pb_text admin_label=”Projects Section Title” _builder_version=”4.27.4″ _module_preset=”default” header_font=”Montserrat||||” header_text_color=”#1f1f1f” header_font_size=”36px” text_orientation=”center” max_width=”710px” module_alignment=”center” animation_style=”fold” animation_direction=”bottom” animation_intensity_fold=”20%” global_colors_info=”{}”]<\/p>\n

Python + SQL Data Exploration Project<\/strong><\/h2>\n
<\/blockquote>\n

[\/et_pb_text][et_pb_code _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”]Check out my project on GitHub: What Should I Cook This Weekend!<\/a>[\/et_pb_code][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” text_font_size=”16px” global_colors_info=”{}”]<\/p>\n

In this project, I cleaned and transformed a real recipe dataset using Python (pandas)<\/strong> and explored it using BigQuery SQL<\/strong>. The focus was on querying recipes based on available ingredients and dietary preferences.<\/p>\n

\n

\n

\n

\ud83d\udd27 Tools & Skills:<\/h4>\n
    \n
  • \n

    Python (pandas, CSV cleaning, data preprocessing)<\/p>\n<\/li>\n

  • \n

    SQL (BigQuery)<\/p>\n<\/li>\n

  • \n

    Data wrangling and string manipulation<\/p>\n<\/li>\n

  • \n

    Real-life problem-solving with a touch of food inspiration!<\/p>\n<\/li>\n<\/ul>\n

    \ud83e\uddf9 Key Highlights:<\/h4>\n
      \n
    • \n

      Cleaned messy CSV data with broken encoding, inconsistent quotes, and line breaks<\/p>\n<\/li>\n

    • \n

      Escaped special characters to make the dataset BigQuery-friendlyWrote SQL queries to:<\/p>\n<\/li>\n

    • \n

      Filter vegetarian options<\/p>\n<\/li>\n

    • \n

      Select random recipe suggestions<\/p>\n<\/li>\n

    • \n

      Find recipes based on ingredients<\/p>\n<\/li>\n<\/ul>\n

      [\/et_pb_text][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” custom_padding=”0px|||||” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

      \n

      Fancy a vegetarian dish? Let\u2019s skip the meat and see what\u2019s cooking.\u00a0<\/em><\/p>\n<\/blockquote>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-12-at-14.29.33.png” title_text=”Screenshot 2025-04-12 at 14.29.33″ _builder_version=”4.27.4″ _module_preset=”default” width=”84%” module_alignment=”center” global_colors_info=”{}”][\/et_pb_image][et_pb_divider _builder_version=”4.27.4″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″ show_divider=”off”][\/et_pb_divider][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” locked=”off” global_colors_info=”{}” custom_padding=”0px|||||” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n

      \n

      Everything\u2019s in the fridge, but no clue what to cook? Let\u2019s choose three recipes at random!<\/em><\/p>\n<\/blockquote>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-12-at-14.38.49.png” title_text=”Screenshot 2025-04-12 at 14.38.49″ _builder_version=”4.27.4″ _module_preset=”default” width=”70%” module_alignment=”center” global_colors_info=”{}”][\/et_pb_image][et_pb_divider _builder_version=”4.27.4″ _module_preset=”default” show_divider=”off” hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_divider][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” custom_padding=”||0px|||” hover_enabled=”0″ locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

      \n

      Rare ingredient spotlight section! Japanese-inspired ideas with Furikake?<\/em><\/p>\n<\/blockquote>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/erikap.co.uk\/wp-content\/uploads\/2025\/04\/Screenshot-2025-04-13-at-10.49.51.png” _builder_version=”4.27.4″ _module_preset=”default” title_text=”Screenshot 2025-04-13 at 10.49.51″ width=”76%” module_alignment=”center” hover_enabled=”0″ sticky_enabled=”0″][\/et_pb_image][et_pb_post_nav in_same_term=”off” _builder_version=”4.27.4″ _module_preset=”default” title_font=”|600|||||||” title_text_color=”gcid-cec232a7-b6b7-44dd-8069-e0b6a3a379a8″ title_font_size=”21px” custom_padding=”5px|5px|5px|5px|true|true” border_radii=”on|2px|2px|2px|2px” border_style_bottom=”inset” box_shadow_style=”preset4″ box_shadow_blur=”10px” box_shadow_color=”rgba(0,0,0,0.07)” global_colors_info=”{%22gcid-cec232a7-b6b7-44dd-8069-e0b6a3a379a8%22:%91%22title_text_color%22%93,%22gcid-a674551e-c023-4666-82b8-b7448e713885%22:%91%22title_text_color%22%93}”][\/et_pb_post_nav][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” background_color=”rgba(0,0,0,0.04)” locked=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][et_pb_icon font_icon=”||fa||400″ icon_color=”#0C71C3″ icon_width=”35px” url=”http:\/\/www.linkedin.com\/in\/erikap423″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_icon][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

      SQL Recipe Recommender  Python + SQL Data Exploration Project In this project, I cleaned and transformed a real recipe dataset using Python (pandas) and explored it using BigQuery SQL. The focus was on querying recipes based on available ingredients and dietary preferences. \ud83d\udd27 Tools & Skills: Python (pandas, CSV cleaning, data preprocessing) SQL (BigQuery) Data […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-4010","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4010"}],"version-history":[{"count":13,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4010\/revisions"}],"predecessor-version":[{"id":4047,"href":"https:\/\/erikap.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/4010\/revisions\/4047"}],"wp:attachment":[{"href":"https:\/\/erikap.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}