Python database youtubeงาน

I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in web applications

*Please read this carefully before applying for this job.* The ideal candidate/team will have worked on YouTube automation channels before with measurable success, have extensive knowledge of Youtube guidelines/copyright rules/fair use policies, strong drawing skills. We Want to Work With You If: - You have experience in creating high quality art work. - You understand psychology behind thumbnails - You can analyze competition and their thumbnails & create your own best version - You understand how to draw viewers in with an interesting and emotional art work to use for thumbnail. - You have experience working under tight deadlines - You are committed to high quality without the need for lots of revisions. - You are organized, communicative and have fast turnaround tim...

hello , i currently have my app in playstore up and running. but, i have created this app in drag and drop builder ( Kodular ). which have so much limitations as well, i am unable to push notifications for the new content. I am looking for someone who can convert or build same app with same interface and structure . What you have to do ? - Co...build same app with same interface and structure . What you have to do ? - Convert whole app from kodular to android studio. ( don't want any trace of the app ) - optimize app and UI for higher fill rate of ads. ( i am using FB ads to earn revenue ) - I will share API key once project done. - Allow me to easily update news or content from my PC ( Easy Backend ). - Add one more page to upload my youtube videos into app or into content...

Das Ziel des Projekts ist die Entwicklung eines Blackjack-Spiels in Python. Das Spiel wird von einer Person gegen einen computergesteuerten Dealer gespielt. Es soll eine grafische Oberfläche und Geldeinsätze enthalten. Zur Dokumentation wird ein Projektbericht geschrieben. Hier werden alle Arbeitsschritte dokumentiert und reflektiert. Die verschiedenen Code Blöcke werden kommentiert, um seine Funktionsweise besser zu erklären. Eine kurze Anleitung erklärt dem Benutzer, wie das Spiel gespielt wird

I am in need of a developer who can assist me in converting my existing Flask API into an Assistant GPT openai. The ideal candidate will be skilled in Python and GPTs Assistant and have a proficient understanding of Flask APIs. As the project involves converting the API into an Assistant GPT, experience with AI and NLP models will be a huge plus. Please note that there was a technical error in the questions, hence the repeated skips. It is highly important that the converted system maintains the functionalities of the original API while being able to run as an Assistant GPT.

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I'm seeking a skilled video editor to work on my YouTube channel. The videos will be a mix of Vlogs and Tutorials, each ranging between 5-10 minutes in length. Key Responsibilities: - Edit Vlog and Tutorial videos for 5-10-minute duration - Implement custom graphics in post-production The ideal candidate will have: - Proficiency in video editing software (e.g., Premiere Pro, Final Cut Pro) - Experience in editing Vlogs and Tutorials - A strong portfolio demonstrating custom graphics creation - Good communication skills to understand my vision and bring it to life If you're a talented video editor with an eye for engaging content, I'd love to hear from you.

I'm in need of a talented video editor to help bring my vlogs to life. Each video will be around 10-15 minutes long and I'm looking for someone who can match my desired style, which is a good pace and chic/elegant. In terms of video editing specifics, I'm hoping to in...video editing specifics, I'm hoping to incorporate cute and feminine transitions to make the videos more engaging. Key Requirements: - Video editing experience, especially in the realm of vlogging content - Able to maintain a good pace and chic/elegant style - Skilled in incorporating cute and feminine transitions The ideal candidate will have a keen eye for detail, a solid understanding of the Youtube vlogging landscape, and be creative in their approach to video editing. Please INCLUDE any r...

I'm in need of a skilled professional who can produce a high-quality case study report focusing on marketing strategies within the retail industry. Key Deliverables: - Thorough Analysis: The case study should delve into various effective marketing strategies within the retail sector, potentially highlighting particular successes and failures. - Practi...You should have a strong track record of creating engaging and insightful case studies. - Retail Marketing Expertise: A deep understanding of the retail sector and its marketing dynamics is crucial for this project. - Strategic Thinker: The ability to identify patterns and trends in marketing strategies and translate them into practical recommendations is key. Gurobi with Python, Anaconda: Is able to use Gurobi with python...

I am a content creator on YouTube launching a course in the fall of 2024, I am offering a fantastic opportunity for an experienced video editor to create an engaging and dynamic learning journey for my audience. Project Objectives: - Edit a total of ~ 25-30 videos, which will make up the lessons for the course. Video length will be anywhere from 5-15 minutes each. Total edited video content will be 3-4 hours. Footage will include 2 camera angles and potentially some b-roll of relevant information to be supplied by me. - Integrate branding assets into edits for cohesive, sleek, professional, and engaging online course videos. - Enhancing the footage with animations and effects to maintain student engagement and improve knowledge retention. This will include some on-screen grap...

I'm seeking a skilled video editor to enhance my YouTube videos. Key Responsibilities: - Edit videos with a focus on educational content - Add text overlays to emphasize key points Ideal Candidate: - Prior experience in editing YouTube videos - Proficiency in adding engaging text overlays - Ability to maintain a consistent educational tone throughout the video

I am seeking a proficient DevOps eng...out CI/CD pipeline with supporting infrastructure as Code (Kubernetes, Docker) - Manage code releases and updates with popular orchestration tools like : Jenkins , Ansible Ideal Skills: - Proficiency with AWS and Azure cloud platforms - Strong experience with CI/CD - Adeptness with Python, PowerShell programming or any other popular scripting language This job demands the candidate to have a sound understanding of cloud computing and CI/CD implementation, coupled with the ability to comfortably work with Python or other popular scripting languages like PowerShell. The selected consultant will have to train and mentor from A to Z how all steps are implemented The project plan is provided and reviewed by hired Freelancer to avoid any ...

I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to...

I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid unde...

I'm in need of a skilled Python developer to create a custom Telegram bot for me. This bot will primarily focus on automated messaging. Key requirements: - (((meeting will be in person in Kuwait))) - The bot should be programmed in Python / any - It should be able to send automated messages - integrate payment gateway - Messages include, but aren't limited to, welcome messages for new users, notifications for updates, and reminders for appointments Please consider the following skills and experiences for this project: - Strong proficiency in Python, with a good understanding of its libraries and frameworks - Experience in developing Telegram bots specifically - A solid grasp of automation and scripting - Prior work with automated messaging systems - Ab...

...from a tax website. This involves scrapping website using the provided credentials by the client, i am looking for getting the python code as i can run the code myself in the future or integrate it to another system. Key Requirements: - I need approximately 300 data points extracted. - The output for these data points should be organized into a PDF or Word. This project is about creating an automated system to generate instant reports about a company. Only difficulty is the website has drops downs to select the period involved and in those 300 data points actually many come from the same source. Ideal Skills and Experience: - Experience in web scraping (Python) - Proficient in creating PDF documents from extracted data - Adept at handling large amounts of data - Famili...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

.The scope of this project includes: 1. Data Transmission: You should be able to help in enhancing our network to ensure that it delivers data more optimally, focusing particularly on text-based data, as this is what our UDP/IP network primarily handles. 2. Error Detection and Correction: The hiree will also have to devise new methods for detecting and correction errors within our system. We've been facing some challenges in this area that need resolution. 3. Scalable Solutions: Our network system currently connects between 10 and 50 devices. While working on this project, it is important to keep scalability in mind to accommodate potential future growth.

We are looking for a developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the P...one view, allowing the user to check the total bonding curve of SOLs versus SOLs owned in the project. Implement a comment bot to automatically write comments on each project. Qualifications: Proven experience in developing trading bots. Strong understanding and experience with the Solana network. Familiarity with the Pumpfun platform is mandatory. Proficiency in programming languages such as Python, C++, or Java. Experience with trading APIs and platforms (e.g., REST, WebSocket, FIX protocol). Strong problem-solving skills and attention to detail. Ability to work independently and as part of a team. Excellent communicati...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

I am the owner of a YouTube channel that focuses on educational content for adults. Currently, my audience is under 100 subscribers, and I'm looking for a skilled freelancer to help grow this audience. Topic of my channel: therapeutic potential of psychedelics to treat mental illnesses Key Requirements: - Proven experience in growing YouTube channels. - Understanding of the educational content niche. - Insight into engaging an adult audience. Your tasks may include, but are not limited to: - Developing a targeted growth strategy for my channel. - Improving current content and creating new engaging videos. - Utilizing SEO, social media, and other tools to increase visibility. The goal is to organically grow my subscriber base, increase

I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.

I'm looking for an experienced videographer to capture various aspects of a visit to a company HQ in London. This project will include: - Filming interior shots of the HQ - Filming interviews with employees (YouTube presenter will conduct the interviews) - Capturing B-roll footage of the surrounding area The visit date is Tuesday 18th May. The purpose of the video is to generate a YouTube video that will captivate and engage YouTube viewers. The ideal freelancer should have prior experience in corporate videography, and creating dynamic YouTube content. Please provide samples of previous work of a similar nature when applying.

I'm in need of a skilled programmer who is adept in Python, Java, and C++. Your tasks will span database management, working with algorithms and data structures, and user interface design. Here's a further breakdown of the ideal skills and experience I'm looking for: - Programming skills: Proficient in Python, Java, and C++. Familiarity with various coding patterns and best practices. - Database management: Experience in handling large datasets, querying databases in an optimized manner, and ensuring the integrity and safety of the data. - Algorithms and Data Structures: Demonstrated understanding of algorithms and data structures. The ability to use this knowledge to solve problems efficiently is a must. - User Interface Design: Skills in...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

...using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to various audience segments. Set up and manage multiple ad campaigns across Google Ads (Search, Display, YouTube) and Facebook Ads (Feed, Stories, Audience Network). Utilize advanced targeting techniques, including demographic, behavioral, and geographic targeting. Optimization and Analysis: Monitor and analyze campaign performance data to identify trends and insights. Perform A/B testing to continually refine ad copy, creatives, and targeting strategies. Optimize campaigns to maximize ROI, re...

I am seeking a creative and experienced video editor to create a captivating YouTube introduction video to increase the average view duration of my posted content. This video is primarily targeted at young adults and business professionals. - Objective: The aim is to create a video that will hook my viewers, encouraging them to watch more of my posted videos, hence increasing the average view duration. - Video Content: The video will be repurposed from the original recording. - Desired Video Length: The video should be anywhere from 30 seconds to 1 minute long, capturing the audience's interest from the get-go. Ideal Skills: - Experienced with video editing in line with YouTube's format and general style. - Ability to create content that appeals to a mixed audience of yo...

...brand. The ideal candidate will be proficient in using ChatGPT, Shopify, research, copywriting, and various social media platforms to help us execute our comprehensive content and marketing plan. Responsibilities: -Content Creation and Management: -Develop and schedule daily posts for Instagram, TikTok, and Twitter. -Write weekly blog posts and newsletters. -Manage and create content for our YouTube channel, including weekly AMA (Ask Me Anything) sessions. Event Coordination: -Assist in organizing and promoting monthly influencer events -Engagement and Community Building: -Engage with followers and respond to comments and messages. -Organize and manage giveaways for followers Research and Analysis: -Conduct research on digital beauty trends and skincare ingredients. -Monitor a...

...work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - Good communication skills, as we'll need ...

I am in need of a versatile video editor who can create engaging and captivating YouTube Kids videos. Add sound effects and animation where needed. Key Responsibilities: - Edit and enhance video content for educational, animated, and music videos - Incorporate suitable cartoon effects, sound effects, and background music - Ensure that the final video is between 20-40 minutes in length Ideal Candidate: - Proficiency in using cartoon and sound effects, as well as selecting suitable background music - Ability to create engaging content that captures the attention of young viewers - Capacity to deliver high-quality, polished video content within the specified length Payment will be done per video. We will provide you with the videos and you have to combine them together, add sounds ...

I'm in need of a proficient Python developer who can help compile a Python code, that I have acquired from GitHub, into an executable format for Windows. As the client, I expect: - Understanding the existing Python code and its dependencies - Transforming the Python code into a Windows executable file Successful freelancers should provide a detailed project proposal illustrating how they plan to compile the code to exe on a Windows operating system. Though no specific Python libraries or frameworks were mentioned, a background in Python coding and debugging is paramount. The ideal freelancer should have a deep understanding of Python code, dependencies, and experience dealing with code from GitHub. Experience in generating Windows e...

I'm in need of a seasoned social media marketing expert to actively help generate leads for my business on various platforms including - Facebook, Instagram, Twitter, Youtube, and Tiktok. The primary objective is to design and execute a dynamic, engaging social media strategy that will successfully capture the attention of business professionals, our main demographic, and convert them into potential leads. The appropriate professional for this job would ideally: - Have extensive experience with social media strategies aimed at lead generation. - Possess a strong working knowledge of the platforms mentioned. - Have the skills to define, identify and target 'Business Professionals' within social media demographics. - Be creative, as compelling content will be key t...

...am looking for a skilled programmer to develop an interactive chemistry experiment for me. You may code using JavaScript, HTML5 or using Python, so experience or proficiency in this language is crucial. Key Requirements: - Users should be able to drag and drop objects using mouse or in case of mobile- fingers. - It should offer a moderate level of interactivity. This includes features such as adjusting quantities and temperatures. If a user pours something in a beaker, it should show the beaker full. If emptied, beaker is empty. - Vector images of lab equipments like Test tube, beaker, burner etc can be found online. Ideal Skills: - Proficiency in Python or JavaScript. You may use CreateJS libraries. If you are a programmer with a passion for chemistry, this is a great...

I'm seeking a skilled developer to creat...limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utilities or tools - Familiarity with e-signing mechanisms and standards - Prior experience in working with PDF, XML, JSON, and Text files - Ability to create a user-friendly interface for the utility. If you have the required skills and can deliver within the specified time frame, please s...

I am seeking an experienced Python web application developer to construct a user-friendly platform for cryptocurrency airdrop and telegram integration. The final product should be similar to notcoin. Key requirements: - User registration and verification. - Airdrop distribution capabilities. - Integration with Telegram. Professional skills and experience: -Familiarity with Python. -Past work demonstrating ability to create robust web applications. -Understanding of cryptocurrency airdrop processes. Applicants should include their relevant experience in their applications. Working examples of similar projects will be highly appreciated.

I need a tool that extracts specific content (text and images) from PDF files and adds this data into a CSV file under designated headers. Key Requirements: - The tool should be designed specifically for Windows OS. PDF Data Extraction: - Need the tool to extract both text and images from the PDFs. CSV Insertion: - The extracted data should be sorted correctly under...Insertion: - The extracted data should be sorted correctly under their respective column headers in a CSV file. Consistent PDF Structure: - It is important that the tool can handle data extraction from PDFs with a consistent structure. Ideal Skills and Experience: - Proficiency in developing Windows-based tools. - Experience with PDF data extraction. - Familiarity with CSV file manipulation in Python or related ...

I am seeking an AI developer with significant expertise in reinforcement learning. Key Responsibilities: * Apply reinforcement learning techniques to solve complex problems. Required Skills and Experience: * Proficiency in Python. * Expert-level knowledge and hands-on experience in reinforcement learning. Only apply if you possess an excellent understanding of reinforcement learning algorithms, and Python programming. This project is demanding and requires a high level of competency, therefore, only experts in the field are sought. Your expertise will be crucial in optimizing our current models and laying down the roads for future developments.

I am looking for a graphic designer to create a bold and colorful YouTube thumbnail for a podcast. The thumbnail should include a catchy phrase related to the main theme of the podcast. Skills and experience required for this project: Graphic design expertise, with a strong understanding of color theory and composition Ability to create eye-catching and visually appealing designs Experience in creating thumbnails for YouTube or other social media platforms Understanding of the real estate and business industry to accurately represent the podcast theme The ideal candidate should be able to create a thumbnail that grabs attention, communicates the podcast's theme, and entices viewers to click and listen. The name of the podcast is "The Next Deal Podcast" You...

I'm searching for a proficient video editor to help with my YouTube and social media content. Your primary task will be editing videos that will be within the 5-10 minutes range. Key Responsibilities: - Edit YouTube and social media videos - Implement a cinematic editing style Ideal Skills: - Proficient in video editing software - Previous experience in editing YouTube or social media content - Ability to deliver high-quality work - Strong understanding of cinematic editing Please, apply with your portfolio that showcases your previous video editing work.

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I'm seeking a skilled video editor to enhance my 10-15 minute footage with basic editing services. This includes cutting and trimming, adding background music, titles, subtitles, and basic animations. Ideal Skillset: - Proficient in video editing software - Prior experience with basic video editing - Ability to add animations is a plus - Good understanding of pacing, music, and transitions Please provide a portfolio of your previous works for consideration.

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

I'm seeking a talented graphic designer to create an eye-catching and colorful thumbnail for my YouTube channel. Key requirements: - Incorporate company logo, a product image, and playful and creative text overlays. Ideal candidate: - Proficient in graphic design and knowledgeable about YouTube's thumbnail best practices. - Capable of creating a design that's both professional and attention-grabbing. - Able to interpret the playful and creative design approach I'm looking for. - Good communication skills to understand my brand aesthetic and vision. If you're a creative and experienced designer who can make my video stand out in the crowded YouTube space, I'd love to hear from you.

I'm in dire need of a marketing expert highly skilled in the domain of Instagram and YouTube. The core aim of this project is twofold: 1. Elevate Brand Awareness 2. Fuel Direct Sales Adeptness in harnessing the potential of industry-specific influencers for campaign collaboration is a great advantage. Looking forward to empowering my brand through your marketing acumen. Please attach samples of relevant work done for review, if any.

I am looking for an AI trainer proficient in Python or java to assist me with my AI project. Key Requirements: - Proficiency in Python: You should be adept in using Python for AI projects. - Machine Learning and Deep Learning Skills: Ideally you will have a solid foundation in machine learning and deep learning concepts and their practical applications. - Communication Skills: A good trainer should be able to explain complex ideas in simple terms. I will require online and offline assistance, so you should be comfortable with both modes of training. The ideal candidate should be able to provide regular updates and feedback on my progress. I am eager to get started and would appreciate if you could commit some time to this project.

I'm in need of a skilled video editor to help with my YouTube channel that focuses on gaming content. Key Requirements: - You'll be primarily editing gaming videos (less than 10 minutes each), so a good understanding of this genre is essential. - I'd like the editor to add specific video effects to enhance the quality of the content. These include slow motion, animations, and sound effects. Ideal Skills and Experience: - Proficient in video editing software, preferably Adobe Premiere Pro or Final Cut Pro. - Prior experience with editing gaming content is a big plus. - Creativity and a good eye for detail in adding effects. - Ability to work efficiently to deliver engaging and polished videos. If you're a gaming enthusiast with a knack for video editing and ef...

...you might not be the winner. It's just the nature of the contest. I suggest not to waste your time and effort, if you are not very good or don't have much experience, or don't have good taste. For you, who would like to try, GOOD LUCK! I appreciate all your effort. I will make sure leave you a great review for you who win. What we need: 30 - 35 second video We are going to use the video for Youtube, FB & Instagram ads. Need the video in these formats: 16:9 , 1:1 & 9:16 More details of the project: Requirements: - Advanced editing skills, including color grading and special effects. The video should look sleek and professional. - A good understanding of corporate video production and what

I need a skilled social media marketing expert to run a unique and engaging campaign primarily aimed at driving footfalls to my stores. While I hold no strict deadlines, the project completion should align with a steady and robust increase in store visits. Ideal expertise would include: - Proficient in Facebook, Instagram, and Youtube campaign management. - Proven track record in generating footfalls in brick-and-mortar stores through online campaigns. - Ability to design captivating visuals that align with my brand's identity. - Outstanding copywriting and content planning abilities. Your proposal should present a brief but comprehensive strategy on how you plan to execute this. Roles may potentially extend provided significant revenue boosts are seen during project dura...

I am looking for a talented videographer and editor to create engaging football themed entertainment shorts for my YouTube channel. Key Responsibilities: - Filming and editing a variety of shorts focused on football skills and tricks, match highlights and analysis, as well as news and updates on football events. - Creating high-quality, entertaining content that captivates viewers and enhances the visibility of my channel. Ideal Skills: - Excellent video shooting and editing skills, preferably with experience in sports media. - Deep understanding of YouTube platform and trends. - Strong knowledge of football, and ability to bring out the thrill and passion of the sport in the videos. Your expertise will aid in building my channel's reputation and viewership. Make sur...

I'm looking for someone who can do automated selenium test (using python) for a wordpress plugin. You need to write the test cases and automate it.