Python generate excel report from database työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Dataset + python + finance concepts
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Task 1. Take these pages away from the HTML- sitemap: Al – käyttöehdot Al – Kiinteistönvälittäjän kilpailutus Al – kiitos Al – rekisteriseloste Al – tulos Al – Välityspalkkiovertailu Task 2. Enable our text-logo () to all affiliate pages. It is not enabled on our affiliate templates now.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
I need a skilled programmer for a crucial task: changing all website links and references from . to .au. The project is intended for an existing business site. Additionally, we will require the professional to update SEO settings in all lines of code to reflect the .au domain replacing . Key Responsibilities: - Convert all references of . to .au throughout the entire website - Update SEO settings to accommodate the new domain - Ensure smooth transition without any loss of data or functionality Ideal Candidate: - Proficient in web development and coding - Extensive experience with SEO and domain migration - Attention to detail to ensure no broken links or missing references - Excellent communication skills to provide updates and seek clarification - Familiarity with the
[Deadline Saturday 5 pm EST] Hello, I am trying to create some supervised models in Python based on this Kaggle data set I have started however struggling to finalize the code; Preliminary Data Exploration: Explore the data, and provide some basic summary statistics and two or three visualizations. Describe/show something interesting and/or surprising about the data. This exploration should not be exhaustive, just a highlight of a few interesting things about your data set. If you need to reduce the size of your data to fit now is the time to do that. Data Exploration: shall include a bulleted or numbered list of proposed specific data explorations you intend to carry out (include visualization). These insights are things that
...of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools and software. - Excellent organizational and time-management skills. - Strong communicat...
I need a command-line program that can convert .mpz files to .xlsx files. The program should be written in Python. Key Requirements: - Input: The program should take a .mpz file as input. - Output: The extracted files should be converted to .xlsx format. - Handling: The program should be able to handle files up to 200mb in size. Skills/Experience Required: - Proficient in Python programming - Experience with file handling and conversion Note: A graphical user interface is not required, the program should be command-line only.
Hello, look for an expert programmer to import data from a json, there is a lot of data that includes various data, image, title, categories, tags, etc. and some go in custom fields. I want to take the images from a folder within my own server or use them in that same folder. Please read the description carefully and tell me price and time.
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...
I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diver...
I am seeking an expert to develop a comprehensive marketing plan through Google Ads, Facebook and LinkedIn ads for a home loan aggregation company. The primary goal is to generate customer leads and Direct selling Agent leads in Hyderabad, Delhi, and Mumbai. Key Tasks: - Keyword research: Identify and suggest relevant keywords that are likely to drive customer leads. - Budget Allocation: Determine an effective budget per city in rupees for the Google Ads , Facebook and LinkedIn campaigns. - Targeting: Tailor the strategy specifically to these cities, ensuring maximum reach and impact. Ideal Skills and Experience: - Extensive experience in Google Ads, Facebook and LinkedIn for lead generation. - A strong understanding of the Indian market and its nuances, particularly in Hyderab...
I have ongoing work related to our previous project 'Custom Vibrant Artwork Creation from Photo'
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a ke...
I'm in need of an expert who can maximize the reach and visibility of my videos on YouTube. Key Responsibilities: - Increase video views to drive traffic - Improve video ranking on YouTube - Optimize videos for s...engines I'm aiming to build an audience and enhance engagement through these video optimizations. Ideal Skills: - Proven experience in YouTube video promotion and SEO - Deep understanding of YouTube's algorithm - Ability to strategize and implement improvements quickly - Strong analytical skills to measure success and adapt strategies Tasks: - take completed videos and upload to Youtube account - generate SEO, description, hashtags etc Payments will be per uploaded and finalized video with all keywords and description. I am expceting to pay $1 per vid...
Hi, I need a script that scrolls down page and clicks mail buttons then clicks next page then does the same. I think python maybe?
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement...
We are seeking an experienced Flutter developer to integrate 's video and call streaming serv...seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear f...
I'm looking for a skilled professional that can generate an AI-powered Classic Hip-Hop rap song based on a rap I've written and my voice. The song I would like to be AI-generated should be between 3 and 5 minutes in length. Key Requirements: - The freelancer should be capable of using AI tools to transform my voice into a captivating Classic Hip-Hop rap song. - The final output should maintain the essence of the original rap I've written while being in line with Classic Hip-Hop style. - I will provide the background music for the rap song. Ideal Skills and Experience: - Proven experience in using AI for music production - Strong understanding of Classic Hip-Hop music style - Excellent audio editing skills - Creativity in transforming text into music Please respo...
I'm looking to automate podcast transcription service. 1. I need a service to follow Podcast Rss Feeds and listen for new episodes 2. I need Listen Notes to download the podcast audio file 3. I need Chatgpt to transcribe the audio file 4. I need an output of the transcribed text made into a google do...output of the transcribed text made into a google document 5. I need Chatgpt re-write the transcribed text into an article with a Title, meta text and the content of the article. 6. I need the re-written article to be saved in a Google document 7. I need the document to be re-written in 8. I need the re-written document by saved in google document You should know python and have api integration skill set you should know how to use and the process flow
I am looking for a professional with experience in AWS API Gateway, Python, and possibly other related technologies to troubleshoot and fix a persistent connection issue I'm facing. Requirements include: - In-depth knowledge of AWS API Gateway, for REST API specifically - Solid experience with Python, as my backend system is built using this language The issue I'm having involves regular 'connection refused' errors when trying to fetch data from the API. This has been an ongoing issue, and I need an expert who can identify the root cause and implement a solution to ensure reliable, uninterrupted connectivity. It would be beneficial if you have experience in troubleshooting and resolving similar API Gateway issues in the past. A proactive approa...
I need a skilled professional to manually upload 1000 products from our online eBay store to our Magento 2 website. Requirements: - The products will include information such as title number, description, images, sku number, and prices. - You need to ensure that the listings are accurately and completely transferred from eBay to Magento 2. - There's no need to optimize images for web before uploading. Simply uploading as is will suffice. - Please use the existing product descriptions. Ideal Skills and Experience: - Proficiency in using Magento 2, including product management. - Experience in data entry and manual product uploads. - Attention to detail to ensure that all product information is accurately transferred. - Ability to follow instructions carefully and respe...
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
I'm on the lookout for a diligent freelancer to help in testing the gameplay balance of our latest PC game. The core focus of your responsibilities will be: - **Gameplay Testing:** Deep dive into the gameplay, ensuring the mechanics are engaging and balanced. - **Balance Issues Identification:** Critically analyze and report on gameplay balance. This involves playing through the levels, understanding the game mechanics, and identifying areas that feel too easy or too challenging. - **Feedback & Suggestions:** Provide constructive feedback on how to improve gameplay balance. Your insights will be invaluable in tuning game mechanics to enhance the player experience. **Ideal Skills and Experience:** - Proven experience in PC game testing, particularly gameplay aspects. - Kee...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email add...
I need a Python developer to create a bot that scrapes data from APIs on an hourly basis. - The bot's primary function is to scrape data - The data will be sourced from APIs - The bot needs to run on an hourly basis Ideal candidate: - Proficient in Python and API data scraping - Familiarity with creating bots - Able to ensure smooth hourly operation, possibly using a scheduling library such as APScheduler
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I need a master of Photoshop to expertly remove an object that is centrally placed in my photo. The object to be removed is distinctly separate, none of the elements in the image overlap or intertwine with it. The ideal freelancer for this project should possess: - Exceptional Photoshop skills, particularly in object removal - Keen eye for detail to maintain the integrity of the remaining elements - Experience in image manipulation and restoration projects. Your goal is to make the final image look as natural as possible, as if the object was never there to begin with. Efficiency and promptness is appreciated.
Simple authentication and authorization app wirh sample user/role in python/flex/dynmoDB hosted in aws ec2 instance.
I have an Amazon security audit and they require a Penetration Test of my windows desktop application. What I need is a automated tool to test and provide a report that shows my application does not have security issues and is not accessible from the web. There is no end-point to my application as it is not web facing and is a stand alone application. This is to satisfy Amazon security review. I'm looking for a skilled professional to conduct a penetration test on my Windows desktop application. Key Requirements: - Conduct a automated penetration test specifically tailored for a Windows desktop application. - Ensure the test covers all potential vulnerabilities and security risks. - Provide detailed reports on the findings, including any exploits, weaknesses, a...
I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go ...
I need a React developer to build a frontend for a Student Management System. Key Project Details: - Two Types of Users: The...admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Proficiency in React - Previous experience in building CRUD applications - Understanding of user access control and reporting functionalities - Ability to work with provided APIs - Deadline-oriented with excellent communication. If you're confident in your React skills, have experience in similar projects, and can meet the deadline, I'd li...
