{ "cells": [ { "cell_type": "code", "execution_count": 6, "id": "0eccd20e", "metadata": {}, "outputs": [], "source": [ "from langchain_groq import ChatGroq" ] }, { "cell_type": "code", "execution_count": 7, "id": "c16ff50e", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "That's an easy one!\n", "\n", "The first person to set foot on the moon was Neil Armstrong. He stepped out of the lunar module Eagle and onto the moon's surface on July 20, 1969, during the Apollo 11 mission. Armstrong famously declared, \"That's one small step for man, one giant leap for mankind,\" as he became the first human to walk on the moon.\n" ] } ], "source": [ "llm = ChatGroq(\n", " temperature=0, \n", " groq_api_key='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', \n", " model_name=\"llama3-70b-8192\"\n", ")\n", "response = llm.invoke(\"The first person to land on moon was ...\")\n", "print(response.content)" ] }, { "cell_type": "code", "execution_count": 8, "id": "90d33612", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "USER_AGENT environment variable not set, consider setting it to identify your requests.\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Senior Data Engineer\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Skip to main content\n", "Open Virtual Assistant\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Home\n", "\n", "\n", "Career Areas\n", "\n", "\n", "Total Rewards\n", "\n", "\n", "Life@Nike\n", "\n", "\n", "Purpose\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Language\n", "\n", "\n", "\n", "\n", "\n", "Select a Language\n", "\n", " Deutsch \n", " English \n", " Español (España) \n", " Español (América Latina) \n", " Français \n", " Italiano \n", " Nederlands \n", " Polski \n", " Tiếng Việt \n", " Türkçe \n", " 简体中文 \n", " 繁體中文 \n", " עִברִית \n", " 한국어 \n", " 日本語 \n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Careers\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Close Menu\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Careers\n", "\n", "\n", "\n", "\n", "\n", "\n", "Chat\n", "\n", "\n", "\n", "\n", "\n", "\n", " Home\n", " \n", "\n", "\n", "\n", " Career Areas\n", " \n", "\n", "\n", "\n", " Total Rewards\n", " \n", "\n", "\n", "\n", " Life@Nike\n", " \n", "\n", "\n", "\n", " Purpose\n", " \n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Jordan Careers\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Converse Careers\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Language\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Menu\n", "\n", "\n", "\n", "Return to Previous Menu\n", "\n", "\n", "\n", "Select a Language\n", "\n", " Deutsch \n", " English \n", " Español (España) \n", " Español (América Latina) \n", " Français \n", " Italiano \n", " Nederlands \n", " Polski \n", " Tiếng Việt \n", " Türkçe \n", " 简体中文 \n", " 繁體中文 \n", " עִברִית \n", " 한국어 \n", " 日本語 \n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", " Back to Search\n", "\n", " \n", "\n", "Senior Data Engineer\n", "\n", "\n", "Categories ID\n", "\n", "\n", "\n", "Categories URL\n", "\n", "\n", "\n", "Position Type\n", "\n", "\n", "\n", "Date Posted\n", "\n", "\n", "\n", "Primary Quest ID\n", "\n", "\n", "\n", "Second Quest ID\n", "\n", "\n", "\n", "Job Classification\n", "\n", "\n", "\n", "\n", "Career area\n", "Analytics\n", "\n", "\n", "Location\n", "1 Bowerman Drive, Beaverton, Oregon 97005, United States\n", "\n", "\n", "\n", "Job ID\n", "R-52993\n", "\n", "\n", "\n", "\n", "\n", " Apply Now\n", " \n", "\n", "\n", "\n", "\n", "\n", "\n", "Share Job\n", "\n", "\n", "\n", "\n", "Share Job Posting\n", "\n", "\n", "\n", "\n", "\n", "\n", "Facebook\n", "Opens In A New Tab\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "LinkedIn\n", "Link Opens In New Window\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Email\n", "\n", "\n", "\n", "\n", "\n", "\n", "Close-Medium (Default Size)-icon\n", "\n", "Close Menu\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Become a Part of the NIKE, Inc. Team\n", "NIKE, Inc. does more than outfit the world’s best athletes. It is a place to explore\n", " potential, obliterate boundaries\n", " and push out the edges of what can be. The company looks for people who can grow, think,\n", " dream and create. Its\n", " culture thrives by embracing diversity and rewarding imagination. The brand seeks achievers,\n", " leaders and\n", " visionaries. At NIKE, Inc. it’s about each person bringing skills and passion to a\n", " challenging and constantly\n", " evolving game.\n", "\n", "Senior Data Engineer - NIKE, Inc. - Beaverton, OR. Develop and deliver high quality software solutions that solve specific business problems and grow Nike’s digital businesses.Work on technical solutions that serve other engineering, data, or business facing teams. Serve the end-to-end breadth of Nike, from building foundational data capabilities, creating analytical products to help the Nike business make better decisions, to optimizing supply chain enabling business to run as efficiently as possible.Run agile squads where transparency and trust are key, and collectively bring a culture of engineering excellence and continuous improvement to the organization coach and mentor junior team members. Build products to run reliable and at scale.Code infrastructure and automatically build, test, and deploy creations.Provide support by writing documentation and tutorials as well as providing guidance to users with a variety of technical skills. Part of an agile scrum team, closely working with the Product Owner, Scrum Master and other team members that drive to deliver innovative data solutions.Partner with business facing team members and other technology solution delivery, architecture, and platform teams and interact with engineers from multiple other squads to help define Nike’s engineering culture, standards, and best practices, advocating for engineering excellence and innovation.Telecommuting is available from anywhere in the U.S., except from AK, AL, AR, DE, HI, IA, ID, IN, KS, KY, LA, MT, ND, NE, NH, NM, NV,OH, OK, RI, SD, VT, WV, and WY.Must have a Master's degree in Computer Science, Engineering and 2 years of experience in the position offered or in an engineering-related occupation.Experience must include:• Python• Databricks• Pyspark• Java• Airflow• Data Modeling• Snowflake• SQL• AWS• Microservices• Data Analysis• Machine Learning• System Design• CI/CD Pipeline DevelopmentApply at www.jobs.nike.com (Job# -R-52993)125%#LI-DNIWe offer a number of accommodations to complete our interview process including screen readers, sign language interpreters, accessible and single location for in-person interviews, closed captioning, and other reasonable modifications as needed. If you discover, as you navigate our application process, that you need assistance or an accommodation due to a disability, please complete the Candidate Accommodation Request Form.\n", "\n", "NIKE, Inc. is a growth company that looks for team members to grow with it. Nike offers a\n", " generous total rewards\n", " package, casual work environment, a diverse and inclusive culture, and an electric\n", " atmosphere for professional\n", " development. No matter the location, or the role, every Nike employee shares one galvanizing\n", " mission: To bring\n", " inspiration and innovation to every athlete* in the world.\n", "NIKE, Inc. is an equal opportunity employer. Qualified applicants will receive\n", " consideration without\n", " regard to race, color, religion, sex, national origin, age, sexual orientation, gender\n", " identity, gender expression,\n", " veteran status, or disability.\n", "\n", "\n", "\n", "\n", " Apply Now\n", " \n", "\n", "\n", "\n", "\n", "\n", "\n", "Share Job\n", "\n", "\n", "\n", "\n", "Share Job Posting\n", "\n", "\n", "\n", "\n", "\n", "\n", "Faceboox\n", "Opens In A New Tab\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "LinkedIn\n", "Link Opens In New Window\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Email\n", "\n", "\n", "\n", "\n", "\n", "\n", "Close-Medium (Default Size)-icon\n", "\n", "Close Menu\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "What You Can Expect\n", "OUR HIRING GAME PLAN\n", "\n", "\n", "01 Apply\n", "Our teams are made up of diverse skillsets, knowledge bases, inputs, ideas and backgrounds.\n", " We want you to find your fit – review job descriptions, departments and teams to discover\n", " the role for you.\n", "\n", "\n", "02 Meet a Recruiter or Take an Assessment\n", "If selected for a corporate role, a recruiter will reach out to start your interview process\n", " and be your main contact\n", " throughout the process. For retail roles, you’ll complete an interactive assessment that\n", " includes a chat and quizzes and\n", " takes about 10-20 minutes to complete.  No matter the role, we want to learn about you – the\n", " whole you – so don’t shy\n", " away from how you approach world-class service and what makes you unique.\n", "\n", "\n", "03 Interview\n", "Go into this stage confident by doing your research, understanding what we are looking for\n", " and being prepared for\n", " questions that are set up to learn more about you, and your background.\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Home\n", "\n", "\n", "About Us\n", "\n", "\n", "Contact\n", "\n", "\n", "Talent Community\n", "\n", "\n", "Terms\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", " \n", " \n", " Nike Applicant Privacy Policy\n", " \n", "\n", "\n", "\n", "\n", "\n", "We offer a number of accommodations to complete our interview process including screen readers, sign language interpreters,\n", " accessible and single location for in-person interviews, closed captioning, and other reasonable modifications as\n", " needed.\n", "\n", "\n", "If you discover, as you navigate our application process, that you need assistance or an accommodation due to a\n", " disability, please contact us at +1 503-671-4156 and include your full name, best way to reach you, and the\n", " accommodation you request to assist with the application process.\n", "For more information, please refer to Equal Employment\n", " Opportunity is The Law.\n", "\n", "\n", "\n", "© Nike, Inc. All Rights Reserved\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Careers\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "Chat\n", "Chat with our AI Assistant\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n" ] } ], "source": [ "from langchain_community.document_loaders import WebBaseLoader\n", "\n", "loader = WebBaseLoader(\"https://careers.nike.com/senior-data-engineer/job/R-52993\")\n", "page_data = loader.load().pop().page_content\n", "print(page_data)" ] }, { "cell_type": "code", "execution_count": 9, "id": "85c89a57", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "str" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from langchain_core.prompts import PromptTemplate\n", "\n", "prompt_extract = PromptTemplate.from_template(\n", " \"\"\"\n", " ### SCRAPED TEXT FROM WEBSITE:\n", " {page_data}\n", " ### INSTRUCTION:\n", " The scraped text is from the career's page of a website.\n", " Your job is to extract the job postings and return them in JSON format containing the \n", " following keys: `role`, `experience`, `skills` and `description`.\n", " Only return the valid JSON.\n", " ### VALID JSON (NO PREAMBLE): \n", " \"\"\"\n", ")\n", "\n", "chain_extract = prompt_extract | llm \n", "res = chain_extract.invoke(input={'page_data':page_data})\n", "type(res.content)" ] }, { "cell_type": "code", "execution_count": 10, "id": "5415fd54", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[{'role': 'Senior Data Engineer',\n", " 'experience': '2 years',\n", " 'skills': ['Python',\n", " 'Databricks',\n", " 'Pyspark',\n", " 'Java',\n", " 'Airflow',\n", " 'Data Modeling',\n", " 'Snowflake',\n", " 'SQL',\n", " 'AWS',\n", " 'Microservices',\n", " 'Data Analysis',\n", " 'Machine Learning',\n", " 'System Design',\n", " 'CI/CD Pipeline Development'],\n", " 'description': 'Develop and deliver high quality software solutions that solve specific business problems and grow Nike’s digital businesses. Work on technical solutions that serve other engineering, data, or business facing teams. Serve the end-to-end breadth of Nike, from building foundational data capabilities, creating analytical products to help the Nike business make better decisions, to optimizing supply chain enabling business to run as efficiently as possible.'}]" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from langchain_core.output_parsers import JsonOutputParser\n", "\n", "json_parser = JsonOutputParser()\n", "json_res = json_parser.parse(res.content)\n", "json_res" ] }, { "cell_type": "code", "execution_count": 11, "id": "39961ed6", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "list" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "type(json_res)" ] }, { "cell_type": "code", "execution_count": 12, "id": "1e8a0f74", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
TechstackLinks
0Python,Machine Learning,SQL,Power BI,Data Visu...https://linkedin.com/in/rajesh-patil-12345
1Java,Spring Boot,REST APIs,MySQL,Dockerhttps://linkedin.com/in/snehal-kulkarni-67890
2JavaScript,Node.js,React,Express,HTML,CSShttps://linkedin.com/in/pradip-shinde-23456
3C++,Data Structures,Algorithms,Java,MySQL,Githttps://linkedin.com/in/vaidehi-jadhav-34567
4Python,Deep Learning,TensorFlow,Data Science,P...https://linkedin.com/in/akash-thorat-45678
5Ruby,SQL,API Development,Node.js,PostgreSQLhttps://linkedin.com/in/ankita-pawar-56789
6Java,Spring,REST APIs,Oracle,Cloud Computinghttps://linkedin.com/in/suraj-deshmukh-67890
7C#,ASP.NET,SQL Server,JavaScript,Angularhttps://linkedin.com/in/poonam-kadam-78901
8R,Data Science,Statistics,Machine Learning,Pythonhttps://linkedin.com/in/rohini-kulkarni-89012
9PHP,MySQL,Laravel,JavaScript,HTML,CSShttps://linkedin.com/in/milind-patil-90123
10Python,Flask,Django,Machine Learning,Data Stru...https://linkedin.com/in/nitish-deshmukh-12345
11JavaScript,React,Redux,Node.js,HTML5,CSS3https://linkedin.com/in/suman-shirke-23456
12Go,Microservices,Cloud Computing,Docker,API De...https://linkedin.com/in/atul-ambekar-34567
13Swift,iOS Development,Objective-C,SwiftUI,Reac...https://linkedin.com/in/sandhya-chavan-45678
14Java,Spring Boot,Kotlin,Database Design,REST APIshttps://linkedin.com/in/vaibhav-ghate-56789
15Python,Data Engineering,Spark,ETL,Big Datahttps://linkedin.com/in/priyanka-jadhav-67890
16C,Embedded Systems,Microcontrollers,PCB Design...https://linkedin.com/in/ashwini-patil-78901
17Java,Android Development,SQLite,Git,JSONhttps://linkedin.com/in/santosh-kulkarni-89012
18Kotlin,Android Studio,Java,Git,REST APIshttps://linkedin.com/in/vaibhavi-shinde-90123
19Scala,Akka,Play Framework,Database Design,Big ...https://linkedin.com/in/suresh-tambe-12345
20SQL,NoSQL,Database Design,Cloud Computing,Data...https://linkedin.com/in/madhuri-shelke-23456
21Java,Spring,Cloud,MySQL,RESTful APIshttps://linkedin.com/in/milind-jadhav-34567
22JavaScript,Vue.js,Vuex,Node.js,Expresshttps://linkedin.com/in/keerthi-pawar-45678
23HTML,HTML5,CSS3,JavaScript,Responsive Web Designhttps://linkedin.com/in/ajay-deshmukh-56789
24PHP,Laravel,JavaScript,MySQL,AJAXhttps://linkedin.com/in/pooja-kulkarni-67890
25Python,Flask,SQL,Machine Learning,Web Scrapinghttps://linkedin.com/in/rupesh-thorat-78901
26TypeScript,React,Node.js,GraphQL,Expresshttps://linkedin.com/in/ravindra-chavan-89012
27Python,Data Science,ML,NumPy,Pandashttps://linkedin.com/in/sonali-patil-90123
28Java,Spring,Apache Kafka,Cloud,MySQLhttps://linkedin.com/in/swapnil-shinde-12345
29C++,Python,OpenCV,Deep Learning,AIhttps://linkedin.com/in/monika-ghate-23456
30Ruby on Rails,JavaScript,SQL,REST APIs,Cloudhttps://linkedin.com/in/shubham-shelke-34567
31Swift,iOS,UI/UX Design,Core Data,Push Notifica...https://linkedin.com/in/poornima-jadhav-45678
32Java,Spring Boot,Spring Security,Microservices...https://linkedin.com/in/rahul-pawar-56789
33PHP,WordPress,HTML,CSS,MySQLhttps://linkedin.com/in/sunita-kadam-67890
34Java,Spring,Microservices,PostgreSQL,Dockerhttps://linkedin.com/in/vinay-kulkarni-78901
35JavaScript,Node.js,Angular,Express,MongoDBhttps://linkedin.com/in/archana-deshmukh-89012
36C#,ASP.NET MVC,Entity Framework,SQL Server,Azurehttps://linkedin.com/in/sandip-patil-90123
37Python,Web Scraping,Selenium,Data Analysis,Bea...https://linkedin.com/in/raju-thorat-12345
38Java,Spring Boot,React,SQL,HTMLhttps://linkedin.com/in/jyoti-shinde-23456
39Node.js,Express,JavaScript,MongoDB,Dockerhttps://linkedin.com/in/nilay-kulkarni-34567
40Python,PyTorch,Computer Vision,Deep Learning,T...https://linkedin.com/in/vaishali-deshmukh-45678
41Swift,iOS,Core Animation,SwiftUI,Objective-Chttps://linkedin.com/in/vijay-jadhav-56789
42Java,Android Development,XML,SQLite,REST APIshttps://linkedin.com/in/ritesh-pawar-67890
43TypeScript,Angular,Node.js,GraphQL,JavaScripthttps://linkedin.com/in/mandar-patil-78901
44JavaScript,Vue.js,Nuxt.js,GraphQL,TypeScripthttps://linkedin.com/in/krishna-thorat-89012
45PHP,Laravel,REST APIs,JavaScript,MySQLhttps://linkedin.com/in/anuja-chavan-90123
46Ruby,JavaScript,MySQL,Cloud Computing,Agilehttps://linkedin.com/in/vinita-patil-12345
47Go,Microservices,Kubernetes,Docker,API Designhttps://linkedin.com/in/ankur-shinde-23456
48Python,Flask,Machine Learning,Web Scraping,Dee...https://linkedin.com/in/sarika-jadhav-34567
49C++,Python,Embedded Systems,Machine Learning,A...https://linkedin.com/in/mukesh-ghate-45678
\n", "
" ], "text/plain": [ " Techstack \\\n", "0 Python,Machine Learning,SQL,Power BI,Data Visu... \n", "1 Java,Spring Boot,REST APIs,MySQL,Docker \n", "2 JavaScript,Node.js,React,Express,HTML,CSS \n", "3 C++,Data Structures,Algorithms,Java,MySQL,Git \n", "4 Python,Deep Learning,TensorFlow,Data Science,P... \n", "5 Ruby,SQL,API Development,Node.js,PostgreSQL \n", "6 Java,Spring,REST APIs,Oracle,Cloud Computing \n", "7 C#,ASP.NET,SQL Server,JavaScript,Angular \n", "8 R,Data Science,Statistics,Machine Learning,Python \n", "9 PHP,MySQL,Laravel,JavaScript,HTML,CSS \n", "10 Python,Flask,Django,Machine Learning,Data Stru... \n", "11 JavaScript,React,Redux,Node.js,HTML5,CSS3 \n", "12 Go,Microservices,Cloud Computing,Docker,API De... \n", "13 Swift,iOS Development,Objective-C,SwiftUI,Reac... \n", "14 Java,Spring Boot,Kotlin,Database Design,REST APIs \n", "15 Python,Data Engineering,Spark,ETL,Big Data \n", "16 C,Embedded Systems,Microcontrollers,PCB Design... \n", "17 Java,Android Development,SQLite,Git,JSON \n", "18 Kotlin,Android Studio,Java,Git,REST APIs \n", "19 Scala,Akka,Play Framework,Database Design,Big ... \n", "20 SQL,NoSQL,Database Design,Cloud Computing,Data... \n", "21 Java,Spring,Cloud,MySQL,RESTful APIs \n", "22 JavaScript,Vue.js,Vuex,Node.js,Express \n", "23 HTML,HTML5,CSS3,JavaScript,Responsive Web Design \n", "24 PHP,Laravel,JavaScript,MySQL,AJAX \n", "25 Python,Flask,SQL,Machine Learning,Web Scraping \n", "26 TypeScript,React,Node.js,GraphQL,Express \n", "27 Python,Data Science,ML,NumPy,Pandas \n", "28 Java,Spring,Apache Kafka,Cloud,MySQL \n", "29 C++,Python,OpenCV,Deep Learning,AI \n", "30 Ruby on Rails,JavaScript,SQL,REST APIs,Cloud \n", "31 Swift,iOS,UI/UX Design,Core Data,Push Notifica... \n", "32 Java,Spring Boot,Spring Security,Microservices... \n", "33 PHP,WordPress,HTML,CSS,MySQL \n", "34 Java,Spring,Microservices,PostgreSQL,Docker \n", "35 JavaScript,Node.js,Angular,Express,MongoDB \n", "36 C#,ASP.NET MVC,Entity Framework,SQL Server,Azure \n", "37 Python,Web Scraping,Selenium,Data Analysis,Bea... \n", "38 Java,Spring Boot,React,SQL,HTML \n", "39 Node.js,Express,JavaScript,MongoDB,Docker \n", "40 Python,PyTorch,Computer Vision,Deep Learning,T... \n", "41 Swift,iOS,Core Animation,SwiftUI,Objective-C \n", "42 Java,Android Development,XML,SQLite,REST APIs \n", "43 TypeScript,Angular,Node.js,GraphQL,JavaScript \n", "44 JavaScript,Vue.js,Nuxt.js,GraphQL,TypeScript \n", "45 PHP,Laravel,REST APIs,JavaScript,MySQL \n", "46 Ruby,JavaScript,MySQL,Cloud Computing,Agile \n", "47 Go,Microservices,Kubernetes,Docker,API Design \n", "48 Python,Flask,Machine Learning,Web Scraping,Dee... \n", "49 C++,Python,Embedded Systems,Machine Learning,A... \n", "\n", " Links \n", "0 https://linkedin.com/in/rajesh-patil-12345 \n", "1 https://linkedin.com/in/snehal-kulkarni-67890 \n", "2 https://linkedin.com/in/pradip-shinde-23456 \n", "3 https://linkedin.com/in/vaidehi-jadhav-34567 \n", "4 https://linkedin.com/in/akash-thorat-45678 \n", "5 https://linkedin.com/in/ankita-pawar-56789 \n", "6 https://linkedin.com/in/suraj-deshmukh-67890 \n", "7 https://linkedin.com/in/poonam-kadam-78901 \n", "8 https://linkedin.com/in/rohini-kulkarni-89012 \n", "9 https://linkedin.com/in/milind-patil-90123 \n", "10 https://linkedin.com/in/nitish-deshmukh-12345 \n", "11 https://linkedin.com/in/suman-shirke-23456 \n", "12 https://linkedin.com/in/atul-ambekar-34567 \n", "13 https://linkedin.com/in/sandhya-chavan-45678 \n", "14 https://linkedin.com/in/vaibhav-ghate-56789 \n", "15 https://linkedin.com/in/priyanka-jadhav-67890 \n", "16 https://linkedin.com/in/ashwini-patil-78901 \n", "17 https://linkedin.com/in/santosh-kulkarni-89012 \n", "18 https://linkedin.com/in/vaibhavi-shinde-90123 \n", "19 https://linkedin.com/in/suresh-tambe-12345 \n", "20 https://linkedin.com/in/madhuri-shelke-23456 \n", "21 https://linkedin.com/in/milind-jadhav-34567 \n", "22 https://linkedin.com/in/keerthi-pawar-45678 \n", "23 https://linkedin.com/in/ajay-deshmukh-56789 \n", "24 https://linkedin.com/in/pooja-kulkarni-67890 \n", "25 https://linkedin.com/in/rupesh-thorat-78901 \n", "26 https://linkedin.com/in/ravindra-chavan-89012 \n", "27 https://linkedin.com/in/sonali-patil-90123 \n", "28 https://linkedin.com/in/swapnil-shinde-12345 \n", "29 https://linkedin.com/in/monika-ghate-23456 \n", "30 https://linkedin.com/in/shubham-shelke-34567 \n", "31 https://linkedin.com/in/poornima-jadhav-45678 \n", "32 https://linkedin.com/in/rahul-pawar-56789 \n", "33 https://linkedin.com/in/sunita-kadam-67890 \n", "34 https://linkedin.com/in/vinay-kulkarni-78901 \n", "35 https://linkedin.com/in/archana-deshmukh-89012 \n", "36 https://linkedin.com/in/sandip-patil-90123 \n", "37 https://linkedin.com/in/raju-thorat-12345 \n", "38 https://linkedin.com/in/jyoti-shinde-23456 \n", "39 https://linkedin.com/in/nilay-kulkarni-34567 \n", "40 https://linkedin.com/in/vaishali-deshmukh-45678 \n", "41 https://linkedin.com/in/vijay-jadhav-56789 \n", "42 https://linkedin.com/in/ritesh-pawar-67890 \n", "43 https://linkedin.com/in/mandar-patil-78901 \n", "44 https://linkedin.com/in/krishna-thorat-89012 \n", "45 https://linkedin.com/in/anuja-chavan-90123 \n", "46 https://linkedin.com/in/vinita-patil-12345 \n", "47 https://linkedin.com/in/ankur-shinde-23456 \n", "48 https://linkedin.com/in/sarika-jadhav-34567 \n", "49 https://linkedin.com/in/mukesh-ghate-45678 " ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "\n", "df = pd.read_csv(\"my_portfolio.csv\")\n", "df" ] }, { "cell_type": "code", "execution_count": 2, "id": "f7e888d4", "metadata": {}, "outputs": [], "source": [ "import uuid\n", "import chromadb\n", "\n", "client = chromadb.PersistentClient('vectorstore')\n", "collection = client.get_or_create_collection(name=\"portfolio\")\n", "\n", "if not collection.count():\n", " for _, row in df.iterrows():\n", " collection.add(documents=row[\"Techstack\"],\n", " metadatas={\"links\": row[\"Links\"]},\n", " ids=[str(uuid.uuid4())])" ] }, { "cell_type": "code", "execution_count": 13, "id": "39ad2fa2", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[[{'links': 'https://linkedin.com/in/milind-patil-90123'},\n", " {'links': 'https://linkedin.com/in/sunita-kadam-67890'}]]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "links = collection.query(query_texts=\"PHP,MySQL,Laravel,JavaScript,HTML,CSS\", n_results=2).get('metadatas', [])\n", "links" ] }, { "cell_type": "code", "execution_count": 18, "id": "8bd36844", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[{'role': 'Senior Data Engineer',\n", " 'experience': '2 years',\n", " 'skills': ['Python',\n", " 'Databricks',\n", " 'Pyspark',\n", " 'Java',\n", " 'Airflow',\n", " 'Data Modeling',\n", " 'Snowflake',\n", " 'SQL',\n", " 'AWS',\n", " 'Microservices',\n", " 'Data Analysis',\n", " 'Machine Learning',\n", " 'System Design',\n", " 'CI/CD Pipeline Development'],\n", " 'description': 'Develop and deliver high quality software solutions that solve specific business problems and grow Nike’s digital businesses. Work on technical solutions that serve other engineering, data, or business facing teams. Serve the end-to-end breadth of Nike, from building foundational data capabilities, creating analytical products to help the Nike business make better decisions, to optimizing supply chain enabling business to run as efficiently as possible.'}]" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "job" ] }, { "cell_type": "code", "execution_count": 20, "id": "1ccfd720", "metadata": { "scrolled": false }, "outputs": [], "source": [ "job = json_res\n" ] }, { "cell_type": "code", "execution_count": 16, "id": "64a97dd2", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Here is the cold email:\n", "\n", "Subject: Expert Data Engineering Solutions for Nike's Digital Businesses\n", "\n", "Dear Hiring Manager,\n", "\n", "I came across the Senior Data Engineer job description at Nike, and I'm excited to introduce AtliQ, an AI & Software Consulting company that can help you develop and deliver high-quality software solutions to solve specific business problems and grow Nike's digital businesses.\n", "\n", "At AtliQ, we have a proven track record of empowering enterprises with tailored solutions, fostering scalability, process optimization, cost reduction, and heightened overall efficiency. Our team of experts has extensive experience in Python, Databricks, Pyspark, Java, Airflow, Data Modeling, Snowflake, SQL, AWS, Microservices, Data Analysis, Machine Learning, System Design, and CI/CD Pipeline Development.\n", "\n", "We understand the importance of building foundational data capabilities, creating analytical products, and optimizing supply chain efficiency. Our expertise in data engineering can help Nike make better decisions, drive business growth, and improve operational efficiency.\n", "\n", "Some of our notable projects include:\n", "\n", "* Developed a real-time data analytics platform for a leading retail company, resulting in a 30% increase in sales\n", "* Built a scalable data warehousing solution for a Fortune 500 company, reducing data processing time by 50%\n", "\n", "You can learn more about our capabilities and success stories through the following links:\n", "\n", "https://linkedin.com/in/milind-patil-90123\n", "https://linkedin.com/in/sunita-kadam-67890\n", "\n", "I'd love to discuss how AtliQ can support Nike's digital transformation initiatives. Please let me know if you're interested in exploring further.\n", "\n", "Best regards,\n", "\n", "Mohan\n", "Business Development Executive\n", "AtliQ\n" ] } ], "source": [ "prompt_email = PromptTemplate.from_template(\n", " \"\"\"\n", " ### JOB DESCRIPTION:\n", " {job_description}\n", " \n", " ### INSTRUCTION:\n", " You are Mohan, a business development executive at AtliQ. AtliQ is an AI & Software Consulting company dedicated to facilitating\n", " the seamless integration of business processes through automated tools. \n", " Over our experience, we have empowered numerous enterprises with tailored solutions, fostering scalability, \n", " process optimization, cost reduction, and heightened overall efficiency. \n", " Your job is to write a cold email to the client regarding the job mentioned above describing the capability of AtliQ \n", " in fulfilling their needs.\n", " Also add the most relevant ones from the following links to showcase Atliq's portfolio: {link_list}\n", " Remember you are Mohan, BDE at AtliQ. \n", " Do not provide a preamble.\n", " ### EMAIL (NO PREAMBLE):\n", " \n", " \"\"\"\n", " )\n", "\n", "chain_email = prompt_email | llm\n", "res = chain_email.invoke({\"job_description\": str(job), \"link_list\": links})\n", "print(res.content)" ] }, { "cell_type": "code", "execution_count": null, "id": "42a73b90", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "7392df2e", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.0" } }, "nbformat": 4, "nbformat_minor": 5 }