Import date time mysql fields işler

I need a Python expert to perform data analysis on my database. Key Requirements: - Proficiency in Python: You should be well-versed in Python and its data analysis libraries such as Pandas and NumPy. - Database Management Skill: Experience with database systems would be helpful as t... - Database Management Skill: Experience with database systems would be helpful as the data is stored there. - Data Analysis Expertise: You should have a strong background in data analysis to make meaningful insights and reports from the database. Please note that the database management system is not specified, so you should have a good understanding of different database systems, preferably MySQL, MongoDB, or PostgreSQL. Your ability to work with different systems and extract relevant data will b...

...automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline this vital part of my farming opera...

Hello, I need a social media graphic designed for an event. Date: May 30th Event: Runneth Over Coffee Truck will be at The Homestead Assisted Living Time: 7am-2pm Address: 1132 Cottage Dr, Houma, LA 70360

I have a Word document that I'd like to convert into a fillable PDF form. I need someone who can take care of this and ensure the form includes the following elements. - Form Fields: The fillable PDF must include text fields, checkboxes, and dropdown menus. - Layout and Design: The design of the fillable PDF should be simple and minimalistic. - Security: The form should include password protection for security purposes. Ideal candidates for this job should have: - Experience in creating fillable PDF forms. - Proficiency in PDF editing tools. - A good eye for design and layout, with a preference for minimalistic styles. - Knowledge about creating secure PDFs, particularly with password protection.

I am in urgent need of an experienced web developer to duplicate Website A, with its distinct design layout, content organization, and functionality. Key Tasks: - Precisely replicate the design layout of Website A - Copy the exact content organization method p...am in urgent need of an experienced web developer to duplicate Website A, with its distinct design layout, content organization, and functionality. Key Tasks: - Precisely replicate the design layout of Website A - Copy the exact content organization method present in Website A - Ensure the functionality of the original website is maintained to the letter - Create admin area that can edit all fields and pictures ,website logo , phone number , and font THE BUDGET IS FIXED PLEASE DON T BID IF YOUR PRICE DOES NOT MATC...

Our Journal company is looking for a designer with an artistic flair to craft a unique cover for our journals. We are looking for aesthetic journal designer. We will attach some covers you like. Submissions: - Let's see what you can do! - Past work: Show me your portfolio of previous journal cover designs or any related fields where you've showcased your creativity and design skills. - Experience: Let me know how long you've been working in design, and any relevant qualifications you've earned along the way. - Detailed project proposals: I would appreciate a quick explanation of your initial ideas for the journal cover, including proposed styles and themes. Looking forward to seeing how you can turn my vague instructions into a captivating jou...

Our Journal company is looking for a designer with an artistic flair to craft a unique cover for our journals. We are looking for aesthetic journal designer. We will attach some covers you like. Submissions: - Let's see what you can do! - Past work: Show me your portfolio of previous journal cover designs or any related fields where you've showcased your creativity and design skills. - Experience: Let me know how long you've been working in design, and any relevant qualifications you've earned along the way. - Detailed project proposals: I would appreciate a quick explanation of your initial ideas for the journal cover, including proposed styles and themes. Looking forward to seeing how you can turn my vague instructions into a captivating jou...

I'm seeking a specialist able to extract all job posts and associated data from an old MySQL database, and import them into another WordPress template. I only possess the database from the old site. Here are the specifics: - Database transfer: I need all my job posts and their related data transferred intact. - WordPress version: The new template is installed on WordPress 5.3 or older. - Formatting: Job posts should be formatted using the new template's default settings. Ideal freelancer should: - Possess strong WordPress and MySQL knowledge. - Have experience in data migration between different WordPress templates. - Understand the formatting styles of WordPress templates to apply the default settings effectively. - Handle legacy system constraints due to...

...blockchain integration - Proficiency with Web 3 development and smart contracts - Demonstrated ability to create platforms specialized for low-level user interaction To clarify, a successful project will include a Colibrism Web 3 platform integrated with the Ethereum blockchain and a designed interface optimized for simple transaction activity. Only developers with significant experience in these fields should apply....

I looking for project like this website: I need admin panel to add affilation offer. Multi-lang option.

Se requiere un desarrollador Full Stack, junior. Front End * React, JavaScript * Visual studio code Back End * Java, spring boot * Eclipse Base Datos * PostgresSql, MySQL Habilides Blandas * Buena predisposición * Predisposición aprender * Manejo de estrés y emociones * Buen manejo en la comunicación Redes * Manejo de redes e infraestructura Su mayor experiencia deberá ser en backend, lo demás se puede ir capacitando, y en la medida que vayamos teniendo mas proyectos su curva de aprendizaje irá creciendo, considerando el perfil que queremos a largo plazo.

I need to save a single value obtained from an API into my MySQL database. I urgently require this functionality to be implemented in Laravel. Key Requirements: - Retrieve a single field from an API - Store this value in a MySQL database - Implement this functionality in Laravel I am looking for a professional who can swiftly and efficiently carry out this task to get this feature up and running. You should be familiar with Laravel and have experience in API integration and MySQL database management.

I need a skilled PHP/MySQL teacher who can guide me through a variety of topics related to PHP programming and MySQL database management. While specific topics are flexible, a focus on basic PHP syntax and functions, MySQL database management, and object-oriented PHP programming is expected. With the lessons being conducted online, a teacher with a solid understanding of digital tutoring methods would be ideal. The exact number of hours per week is not yet determined, and can be discussed upon hiring. Skills and experiences: - Proficient in PHP and MySQL. - Experienced in teaching or tutoring. - Experience with online tutoring methods. - Knowledge of basic PHP syntax and functions, MySQL database management, and Object-oriented PHP programming.

I need an expert who can retrieve and compile a comprehensive list of home to school transport operators operating at the local level. Key Responsibilities: - Conduct deep web research to identify and compile a list of transport operators - The list must be specific to the county level - Ensure that the list is up-to-date and includes relevant contact details Ideal Skills: - Proficient in web research - Strong data mining capabilities - Familiarity with the transport industry would be a plus Experience: - Previous experience in compiling detailed lists through web research.

...collect date data that they later send to an Excel spreadsheet. Unfortunately, we're facing an issue wherein the date picked up by the Power App appears to be a day behind the date actually entered. Your task will be to investigate and rectify this date discrepancy issue, ensuring that the date data picked up by the Power App is accurate and aligns with the data entered by the user. Key tasks and responsibilities would include: - Analyzing the date data flow within the Power App to understand the root cause of the discrepancy - Implementing a fix that ensures the date picked up is the same as the date entered - Verifying that the data is correctly being sent to Excel, reflecting the accurate date Ideal Skills &...

1- Co...data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the user with the option to unch...

I have a mysql database with boats, for each boat I generate HTML. Later, I need to print these pages on A3 format, each boat on a separate page. The printed pages will be used by the boat owners to give visitors information about the boat. See this page (example for 2 boats): Can you improve the HTML: • The layout should be attractive, with background colors, en all nice aligned. • Please use colors also used in this website: • If I print the HTML, each boat should be on 1 page in A3 format • Above the QR-code there should be a short text: Scan mij!. You only need to improve the HTML! (program to generate html not in scope)

This project aims to create an online shop selling sports-themed apparel specifically designed for all age brackets, from children to adults. Requirements: - Extensive experience in the field of e-commerce and familiarity with platform development. - Solid understanding of current fashion trends, with an emphasis on sports-related clothing. - Ability to target marketing efforts across a wi...maximize user shopping experience. - Strong understanding of the competitive sports clothing market. Successful execution of this project requires a holistic approach, integrating supply chain management, web design, consumer trend analysis and niche marketing efforts. Freelancers applying for this project should have a relevant portfolio to share, showcasing their experience in the relevant f...

...25 YouTube shorts per month, ensuring high-quality and engaging content. Work closely with the content team to understand the vision and goals for each short. Incorporate feedback and revisions to ensure client satisfaction. Keep up-to-date with industry trends and best practices in short-form video editing. Requirements: Proficiency in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro). Strong attention to detail and ability to maintain brand consistency. Creativity and ability to think outside the box to create compelling content. Excellent time management skills to meet deadlines consistently. Previous experience with YouTube Shorts or similar short-form video platforms is a plus. Payment: Collective payment of 4000 rupees per month. Each short will be c...

I am seeking an adept Python developer to conceptualize a face and sign detection system using OpenCV for a vital POC project. The platform for this project will be the Windows OS. Requirements: - Proficiency in Python and OpenCV. - Experience with face detection and ...knowledge of computer vision techniques. - Proven track record of developing high-performance applications on Windows platform. Ambition: - Develop a face detection system with medium level of facial detection accuracy (85-95%). - The system should be built with OpenCV and Python for our POC. Please ensure your bid include: - Previous projects of similar nature. - Estimation of the completion date. - Your method to accomplish this task. Looking forward to collaborating with skilled and dedicated developers. ...

I am seeking a skilled professional who can expertly integrate Xero with KOST Quotation Software. The ideal candidate has a deep understanding of both platforms and their capabilities. This role will require the successful candidate to develop: - A system to import customer data from KOST Quotation Software into Xero - A feature to sync invoices between the two platforms - A function to create quotations using the integrated system These functions should sync automatically without manual intervention from me. Previous experience with Xero and KOST Quotation Software, and an understanding of the requirements of automatic data syncing for large scale accounting and financial data, would be highly beneficial for this project.

...logically categorize and structure product data for easy retrieval and comprehension. - **Attention to Detail**: High level of accuracy in data entry and organization. ### Timeline - The project should be completed within 2 weeks from the start date. ### Budget - The budget for this project is negotiable based on experience and proposed delivery schedule. ### Application Process - Please submit a proposal outlining your approach to the project, any similar projects you have worked on, and your availability to start. Include your rate and estimated time to complete the project. This brief aims to guide the freelancer through the process of creating an organized and detailed representation of our furniture packages, ensuring clarity and utility for both our internal team...

I'm looking for an experienced developer proficient in screen scraping techniques to carefully extract unspecified data from a Website and accurately populate a MySQL table. The specific data type to be extracted will be clarified upon project initiation. Since there is no specific time frame for this project, I prioritize accuracy and detail over speed. Key skills and experience: - Proficiency in web scraping techniques - Experience with MySQL - Attention to detail - Ability to handle unspecified and unexpected data types - Patience and persistence without a strict time limit.

I'm lookin...website is an E-commerce platform that needs a complete overhaul. Your main responsibilities will include: - Removing outdated product images and replacing them with fresh, high-quality images. - Revamping the overall design and layout of the site to give it a modern and professional look. - Reviewing the product information and making necessary updates to ensure all content is accurate and up to date. Ideal candidates should have a strong background in web development, particularly in E-commerce sites, and must have experience with website revamping and content management. Please note that I plan to update the website quarterly, so I'm looking for a long-term partnership. If you have a good track record of E-commerce site management and revamping, I'...

I'm looking for an expert who can help me streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you hav...

I'm looking for a Salla developer to set up my online store. The project entails creating a store with custom product options, a payment gateway, and inventory management features. Key Requirements: - Platform: Salla - Features: Customizable product options, Payment gateway integration, Inventory management Custom Product Options: - Text Fields: for customers to personalize products - Dropdown Menus: for product variations - Image Upload Capability: so customers can add images to their orders I need a developer with Salla experience to ensure a smooth and successful implementation. The ideal candidate should have a good understanding of e-commerce, particularly in customizing product options, and expertise in Salla platform. Looking forward to hearing from capable and exp...

I'm lookin...website is an E-commerce platform that needs a complete overhaul. Your main responsibilities will include: - Removing outdated product images and replacing them with fresh, high-quality images. - Revamping the overall design and layout of the site to give it a modern and professional look. - Reviewing the product information and making necessary updates to ensure all content is accurate and up to date. Ideal candidates should have a strong background in web development, particularly in E-commerce sites, and must have experience with website revamping and content management. Please note that I plan to update the website quarterly, so I'm looking for a long-term partnership. If you have a good track record of E-commerce site management and revamping, I'...

I'm in search of a skilled software developer to join my team on a full-time basis. The project comes with no strict deadline, giving you the flexibility to perform at your own pace and deliver top-quality work. Key Requirements: - Proficiency in software development - Ability to work full-time - Strong communication skills to collaborate with team effectively

Looking for a proficient developer to create a chat system that truly enhances user engagement across multiple platforms including mobile, web, and desktop. Using languages like NodeJS and tools like Kubernetes, with the ability to integrate APIs, your skills will be thoroughly utilised. This project requires unique expertise in: - Real-time, live chat functionality using NodeJS - WhatsApp integration - Building on multiple platforms like mobile, web, and desktop - Focus on backend architecture Please note, there are no specific design aesthetics for this project as the focus will essentially be on the backend architecture. This is however an excellent opportunity for those well-versed in creating efficient, engaging, realtime chat systems. Full brief given after showing expe...

I'm looking fo...professional iOS app developer to build a medical diagnostic assistance application. Key Features: - The primary function of the app will be to provide diagnostic assistance for a range of general medical conditions. - The app should leverage AI and machine learning to enhance its diagnostic capabilities. Requirements: - Experience in developing iOS applications, particularly in the health or AI fields. - Proficiency in AI and machine learning technologies. - Familiarity with health data security standards and regulations would be beneficial. The ideal candidate should be able to create a user-friendly and reliable application that can provide accurate diagnostic assistance to the user. Please share your relevant experience and previous projects...

As an entrepreneur managing a Shopify store, I need expert assistance with uploading a CSV file containing several product details onto my store. Ideal freelancer would: - Submit detailed project proposals showcasing their problem-solving approach and roadmap for the task. - Illustrate technical adeptness in dealing with Shopify's backend. - Display prior experience with product uploads onto e-commerce platforms, preferably Shopify. The CSV file does not require any modifications before uploading, so the task predominantly calls for a smooth, error-free upload process that ensures all product data is correctly reflected on the store. Understanding the intricacies of product data management on Shopify will be a plus.

I require a knowledgeable individual to seamlessly upload all products to my new Shopify store from a CSV file, which contains product names, images, and descriptions. The expert will also set up an organized system for p...products to my new Shopify store from a CSV file, which contains product names, images, and descriptions. The expert will also set up an organized system for product collections, categorised by product types. Key Requirements: - Proficient in utilizing FTP files for shopify product upload - Skilled in Shopify product collection organization - Effective mastery of CSV file usage with specified fields including product names, images, and descriptions. Looking forward to reliable bids. Please, only bid if you are fully capable and have handled similar tasks. ...

...graphical elements of a plane. Key Requirements: -2d space program -button to create plane in the center with 4 vertices -two textboxes as array in x and y to duplicate the plane in x and y -import button to import video in mp4 /gif and assign it to the plane as matrial /texture - ability to zoom out and in and move in the scene with select all ability as box can be generated by lift click of mouse and drag -button to combine all planes together with having 4 vertices ( as new plane with same matrial) -text box to write a value that will expand the 2d space accordingly infinitly without limit -import/Export button in obj -ability to duplicate the plane with ctrl+d and move it -optimezed performence( can run and duplicate large times in 192 ram, 48 cpu super comp...

...as even minor misconfigurations can have severe security implications. - **Troubleshooting Connectivity Issues**: The freelancer should be proficient in identifying and resolving connectivity issues. Quick and efficient troubleshooting skills are paramount to keep my network running smoothly. - **Implementing New Security Policies**: I need to ensure that my security policies are always up-to-date. The candidate should have experience in implementing new security policies, as well as a solid understanding of current security trends. The perfect candidate for this project will possess a deep understanding of Fortinet Firewall technology, a proven track record in network security, and a meticulous attention to detail. Strong communication skills are a must, as they will be requi...

We are a company specializing in custom training programs tailored to our clients' needs. Our fo...meetings and project status updates with the project team. - Monitor project progress and manage any changes or issues that arise. - Collaborate closely with instructional designers, subject matter experts, and other stakeholders to ensure project alignment with client requirements. **Required Skills and Experience:** - Proven experience as a project manager in learning and development or related fields. - Proficiency in using project management tools, specifically Kantata OX (or similar tools). - Strong organizational and communication skills. - Ability to manage multiple projects simultaneously and prioritize tasks effectively. - Experience in coordinating resources and leading...

I'm looking to create a compelling PowerPoint presentation that elucidates the evolving trends in mood disorders. Key Contents: - An engaging introduction along with a concise background and clear definition of mood disorders. - Up to date statistics and trends pertaining to mood disorders. - A well-informed segment detailing common symptoms and how a diagnosis typically takes shape. - A thoughtful analysis of varying treatment options including medication therapies, psychotherapy and lifestyle changes, along with a deliberation on their effectiveness. Ideal Skills: - In-depth knowledge of psychology, especially mood disorders. - Solid PowerPoint skills for creating visually appealing slides. - Ability to communicate complex concepts in a simple, understandable manner. - ...

I...performance. The access to the server should be via ssh keys only. Also provide information on how to set up permissions for individual Laravel projects in /var/www folder. - Database Server: Set up a MySQL database server. Create a database and a user with appropriate permissions and ensure everything is secure. - Security: Implement necessary security measures to harden the servers and ensure the installation is safe from common vulnerabilities. Ideal candidates should have: - Proficiency in Linux server administration, particularly Ubuntu. - Extensive experience setting up Nginx and MySQL. - Strong understanding of web server and database server security. - Good communication skills to ensure clear documentation of the setup process. Please include relevant experi...

...include: - Setting up a permanent redirect: The redirect should be set up in a way that search engines and users are directed to the new URL without any indication of the original one. - Maintaining sync with the original website: The redirection should automatically update to reflect any changes on the original website. This is crucial as it ensures that the redirect remains accurate and up-to-date. - Ensuring the redirection is seamless and fast: The process must be smooth and without delays, ensuring a seamless user experience. Ideal skills and experience for this job include: - Proficiency in web development and server-side scripting - Experience with URL masking and permanent redirection - Knowledge of tools and techniques for automatic syncing of websites - Attention to d...

...in customer service is desired. - The freelancer should be able to handle phone inquiries and provide assistance to customers. - The expected workload is less than 10 hours per week, cca 1 hour / day, every working day is needed. Important: Part-time job: every work day, somewhen between 9am and 4pm CET, you’d have to: • you have to call the fresh orders, who just bought something in our client's web shop, reach them and tell them we’re thankful for their order, now it’s confirmed, and that they should be at home on the expcted shipping date so the package will be delivered. • call those who didn’t pick up the day before • if the customer has any question regarding his/her order, than you can look it up in the client&rsquo...

...committed to any specific technology. We are open to using various tools. The common core should be as follows: Upon clicking the appropriate button in CRM, a survey should be created, which we can then provide to the trainees to fill out after the training. The survey should include individual training attributes transferred from CRM entities - such as the training name, training date, and trainer's name. Other fields like training rating will be constant for each survey. The survey link should be generated and displayed in CRM, and there should also be an option to send it to the email address of the trainer conducting the training. A QR code should be generated for the survey link. Survey results should be saved to a separate table in CRM, which will contain infor...

I'm looking for a talented graphic designer to create an elegant and modern e-card save the date for my wedding. MUST include: 1. must be landscape/horizontal design 2. must say "Aarti & Akash" 3. must say "save the date" 4. must have Jan 18 and 19, 2025 5. must have San Diego, CA 6. color - match the photo you choose 7. design - elegance and modern aesthetic. Optional: 1. include the wedding logo 2. include the calendar 3. multiple photos ***Attached are ideas we came up with already. you can make something new OR improve on those designs. Please provide a draft of a save-the-date!

I'm running a MySQL database and looking for an expert to help me optimize the query performance. Key responsibilities: - Analyzing the current database structure and configurations to identify areas that need optimization. - Implementing efficient indexing strategies and query tuning to enhance the query performance. - Providing insights and recommendations on how to maintain and keep the optimized database running smoothly. Ideal skills and experience: - Proven experience in MySQL database management and optimization. - Strong understanding of database performance metrics and monitoring tools. - Familiarity with indexing strategies and query tuning techniques. - Excellent problem-solving and analytical thinking capabilities. This role requires a professional who ca...

I'm in need of a skilled .NET developer with a strong background in C# to create a robust web application. Key Funct...Data Processing and Storage: Efficiently manage and process data within the system, ensuring it's stored and retrieved accurately and securely. - Real-time Data Updates: Implement real-time updates for seamless user experience and accurate information delivery. Ideal Skills: - Proficient in C# and ASP.NET for web development. - Angular JS for front end - Strong understanding of web application development and best practices. - Experience with user authentication, data processing, and real-time data updates is highly desired. Please provide examples of your previous work and how it aligns with the requested functionalities. PS: Its a full...

...features required are: - Online Payment Integration: Enable users to make payments for services within the app. - Patient Reviews and Ratings: A feature for patients to rate and review doctors. - Push Notifications: Appointment reminders should be sent to patients. - Patient can choose the date and time of appointment to book along with queue no. and once doctor start the shift it got information, Third-party API integrations: - Google Maps: To provide location services. - Firebase: To use for real-time updates in the database. The ideal freelancer for this role should possess considerable experience in Flutter app development, UX/UI design, database management, and integration of various third-party services APIs. Sound knowledge in developing Healthcare-theme...

Hi Noor, as per our previous chats, we will create a milestone for the first month of full time data research service

I'm in need of a professional who can design and develop a custom dashboard software with two distinct views. The first view will be for our customers, allowing them to input specific data which will be reflected to us as administrators. Key Features: - Two distinct views for customer and admin - Customer view: Customers can : - Fill in order details - Submit data to admin - Admin view...Receive and review customer inputs - search easily to find the data. - Filtering - Dashboard Information section: - Specific information not disclosed - Product name - Quantity Ideal Skillset: - Proficient in web development - Experience in dashboard design and customization - Strong in data handling and submission - Excellent communication for addressing specific dat...

Dicari admin yang bisa kerja full time daerah tangerang gading serpong

...text input for data logging purposes. Specifically, the plugin should be competent enough to extract critical information such as Full Name, Passport Number, and Expiration Date from a passport profile image. Adding to this, the functionality to handle multiple passport profile images is a prerequisite. Each user profile should be able to manage and store multiple passport images with smooth efficiency. Key skills and experience: - Exceptional knowledge of WordPress plugin development - Comprehensive understanding of image to text conversion techniques - High-level coding skills, able to extract specific fields from complex images - An ability to implement complex functionality, such as handling multiple uploads per user profile. Only those well-versed in...

I'm seeking a skilled medical writer to create a detailed and engrossing article on "End-tidal Carbon Dioxide Monitoring in Patients Undergoing Cardiopulmonary Resuscitation". This task requires an individual with a deep understanding of medical principles and technologies, e...and cardiopulmonary resuscitation. The document must: - Total approximately 2700 words - Be delivered within a 48 hour period - Show progress updates every six hours - The budget is $80 - Example file has been provided - Instruction file is also provided The perfect candidate will: - Possess a high level of expertise in medical research - Provide evidence of past work, particularly in related fields Applicants without the required skills or experience, or those unable to meet the delivery ...

DUE DATE: MAY 3,2024 Dynamic Trading Strategy Design: • will provide auxiliary materials ( 2 files ) and Jupyter Notebooks (“ Regression for Pair ” are related to this project. • Design an improved version of the pairs trading strategy (will share with freelancer chosen) by including more stocks in your strategy. • You can consider using the top 100 stocks () and their daily close price during the period of 2019 - 2020 [Note: you may not have access to all the stocks from Yahoo Finance during this period; please explain how you handle this issue]. • Explain whether dimension reduction techniques are needed. • Explain how you measure the performance. • Please show both the in-sample and out-of-sample performance. • Show evi...