Read sql file in python pandas työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Dataset + python + finance concepts
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
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.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
I am looking for an expert programmer with proficiency in Python to develop a face swap API. The script provided in the link below implements and sets up the face swap functionality on Amazon AWS ec2. You can input two images, and the output will be one image with the faces swapped.
I’m looking for a 3D Designer to create me a Unity Obeject, imagine a dome similar to one from the Simpsons Movie. The dome MUST be able to be reshaped and resized without affecting the quality of it and it must have its own textures (see through and reflective) also in 4K
I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoDB no sql
I'm in need of a Python developer to help with the creation of a straddle strategy for Bank Nifty. This project will also involve the backtesting of this strategy for the past 5 years with a particular focus on the forward values of the strategy. I'm looking for someone with previous experience in this area who can also provide valuable insights into the benefit of this strategy. Key Requirements: - Expertise in Python and financial market analysis - Experience in creating straddle strategies for stock market indices - Proficiency in backtesting strategies using historical data - Ability to generate an Excel spreadsheet for backtesting report - Strong analytical skills for detailed transaction-level report - Strategy will be discu...
I am looking for someone to develop an option trading system for me using python. I have my own strategy and need the system to be partially automated. The strategy requires implementation of various option trading strategies such as covered calls, iron condors, and straddles. Unfortunately, I do not have any historical data for backtesting so the system will need to be developed without this. Please ensure that the automation is able to handle variations in the market, and that the system is reliable and secure. I look forward to discussing the project further with qualified freelancers.
...analyst with expertise in SQL and R to conduct a thorough review and testing of a recently completed data analysis project. The successful candidate will be responsible for evaluating the accuracy and completeness of the work, ensuring all requirements are met, and identifying any potential issues or opportunities for improvement. Responsibilities: Review the SQL queries and R scripts used in the project for accuracy and efficiency. Test the data outputs to ensure they align with the project requirements. Verify that all analysis reports are complete and adhere to the specified guidelines. Provide a detailed report outlining any issues found, confirming requirement fulfillment, and suggesting any potential upgrades or improvements. Requirements: Proven ex...
I am seeking an expert in Python to design a basic face recognition attendance system. This project integrates a MySQL database, driven by a Python-based face recognition component. Ideal skills for the project include: - Proficiency in Python - Experience with OpenCV, TensorFlow, Dlib, or comparable libraries - Proficiency with MySQL databases Primary tasks will be: - Developing the face recognition component - Creating and integrating a MySQL database schema - Making informed suggestions regarding model training Your expertise and creative solutions will play a huge role in this project. I look forward to your ideas!
I'm seeking a Python developer experienced with SSH to create a script that enables network configuration and system monitoring tasks. Key skills/Experience: - Proficient in Python programming - Familiarity with SSH and its operation
I am looking for an expert programmer with proficiency in Python and hands-on experience in automation scripting. The task at hand involves the development of two specific scripts. The first one is to create user profiles on the GoLogin browser, while the second one calls for logging into to simulate human-like texting behavior to a specified phone number. Key requirements include: - Developing the scripts in Python - Enabling the scripts to be operable from the Windows command line - Incorporating Selenium for successful implementation Ideal skills would include: - Proficiency in Python - Experience with Windows Command Line operations - Familiarity with Selenium for web automation While Selenium is a mandatory requirement for this p...
I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.
I'm in need of a skilled data migration python specialist to help me move text and attachments data from my current on-premises server to another on-premises server. Key Requirements: - Experience with migrating text and attachments from one jira data centre instance to anotyer jira data centre instance - Proficiency in fetching data from source jira API and posting to target JIRA API - Ability to ensure the migration is completed securely and efficiently Fix this program. import requests import json # Source Jira instance src_jira_url = "(link unavailable)" src_token = "src_token" # Destination Jira instance dst_jira_url = "(link unavailable)" dst_token = "dst_token" # Get all issues from source Jira instance src_issue...
I'm looking for a Python expert with hands-on experience in financial data optimization. The goal of this project is to create a Python code that can optimize assets based on a user's profile and risk preferences. Key Responsibilities: - Create a Python code that finds the optimal asset mix for a user's portfolio by balancing returns and risks. - Work with available financial data, including stock prices, bond yields, and cryptocurrency data. Ideal Candidate: - Proven experience in using Python libraries, such as PyPortfolioOpt, QuantLib, Zipline and Riskfolio-Lib. - Strong understanding of financial data and its analysis. - Experience in building algorithms for optimising assets. This project requires a freelancer who ca...
...algorithms in order to develop a successful trading strategy. Key project requirements: - Build a Forex trading robot that can operate independently - Use my past order data to analyze and improve trading strategy - Implement machine learning algorithms to enhance the robot's trading capabilities Ideal skills and experience for this job include: - Proficiency in programming languages commonly used in trading robot development (e.g., Python, C++) - Expertise in working with Forex market data and trading platforms - Experience in creating and implementing machine learning algorithms for trading purposes - Strong understanding of automated trading systems and their functionalities Please bid if you have a solid track record in develo...
...searching for an accomplished electrical engineer and coder who possesses advanced technical abilities in circuit design, analysis, and programming microcontrollers, namely with Raspberry Pi. These skills are necessary for the fruitful completion of the project. Key Responsibilities: - Design creativeness is a must as I place an emphasis on compact-sized micro-circuits. - Robustness is critical in order to effortlessly connect to external devices. - Implementing GPIO pins for sensor integration requires comprehensive expertise. - Responsibility includes diagnosing and troubleshooting electrical systems when the need arises. The successful freelancer will ideally have substantial experience in Python as this is the preferred programming tool for this project...
As a Python backend developer, I'm looking for someone who can help me build a personal project. This project involves audio, specifically real-time audio processing and analysis. We need this backend for a web app that will send audio data over websocket connection to your backend. Your backend should accept the stream and transcribe it on the server and then store the text in postgresql database and then convert the transcribed text to audio using tts and send it back as a stream to the user over the same ws session/consumer that initiated it. This pipeline should have min latency and hence we prefer using local speech to text and text to speech instead of making external api calls. We could also use external services using apis if the quality of these services is n...
Looking for a specialist with experience on examsoft xmzx files. Need to be timely since i need to be able to see the file in advance.
I am looking for a voiceover artist to read a text message aloud in a casual tone. The accent should be subtly Slovak, not too strong and the recording should take less than a minute. The purpose is not for a greeting message, a video, or a phone system prompt, simply for reading a written text. The ideal candidate will have: - Experience with voice acting - Ability to provide a subtle Slovak/Russian accent yet only subtle still a English voice - Ability to capture a casual tone in their delivery - Capability to deliver the work quickly. Script: Hi Dylan how are you, sorry did not get back to you last night been in meetings all day.. I was supposed to have money by today it’s around 12.6M aed … 3.5m dollar but my guy that’s supposed to be c...
I'm in need of a skilled developer who can create an automation tool for a game on Windows using Python. The primary aim of this tool would be to automate simple, repetitive in-game tasks. i would like to use this library as i think it ill be a good base to work from
Simple Shopify Store Fix: Need Logo, Copyright and Credit Card Icons centered on Footer of Shopify Store, For Both Desktop and Mobile Version. Look at photos attached. This is a very simple fix that will take less than 5 minutes if you read the description instead of just making an automatic bid. I will not consider any proposals over $20.
We're seeking freelance programmers with a flexible skill set as the specific programming languages and project objectives weren't defined. An ability to adapt to various programming languages would be ideal, encapsulating yet not limited to Java, Python, and C++. As the project's main target and functionality weren't specified, experienced bidders with diverse backgrounds in creating mobile apps, website development, and software application building would be preferred. This project may contain elements like user authentication, database integration, and payment processing. It's important you're adaptable and comfortable with possible modifications as the project progresses.
talk Bot using Generative AI platform and RAG for knowledge base, knowledge base on pdf file we can add (add, delete, delete), using python, and can integrations with omni channel like WhatsApp business, telegram, or bind to a website, solutions should be in bahasa Indonesia users
...seeking a proficient Python data analyst who can unlock interesting trend patterns within a dataset using machine learning models. Your expertise will be instrumental in making sense of the underlying trends that the raw data contains. The main responsibilities will include: - Scrutinizing the datasets rigorously in order to identify trend patterns - Deploying machine learning models for an in-depth analysis The nature of the data is undisclosed at this juncture, which adds an element of challenge to the project. Therefore, a flexible analyst capable of working with different data types will be ideal for this role. Remember, the key objective is to highlight trend patterns within the given dataset efficiently and accurately. Someone with experience in...
...seeking a proficient Python data analyst who can unlock interesting trend patterns within a dataset using machine learning models. Your expertise will be instrumental in making sense of the underlying trends that the raw data contains. The main responsibilities will include: - Scrutinizing the datasets rigorously in order to identify trend patterns - Deploying machine learning models for an in-depth analysis The nature of the data is undisclosed at this juncture, which adds an element of challenge to the project. Therefore, a flexible analyst capable of working with different data types will be ideal for this role. Remember, the key objective is to highlight trend patterns within the given dataset efficiently and accurately. Someone with experience in...
France French Recording Project We have a project, that needs Native France French speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
...where I need proficient Python developers to join my team. The project involves two main aspects: Text to Speech and Speech to Text development: - fix existing code - API integrations - using elevenlabs and assemblyai - Integration of voice to text and text to voice features - Experience in developing RAG web applications Data Analysis: - Strong analytical skills and experience in handling data - Able to provide insights and make recommendations based on data - Proficient in Python data analysis libraries In particular, I need the voice to text and text to voice functionality to be focused on converting text to speech. Ideal candidates for this project should have: - Proficiency in Python, with a strong focus on web developmen...
I am looking for a skilled Python programmer to assist with various tasks. Experience with data analysis and visualization, web scraping and automation, as well as Python application development would be preferred. The purpose of this project is not specified, so a versatile skill set is required. Proficiency in Python, Django, and Flask would be advantageous.
...We want our app to have the following features. - Create unique music based on user input information (speed, type, length...). - Create music based on the voice provided by the user - Change the voice of music provided by the user to the voice provided by the user Skills expected of you 1. Strong background in machine learning, deep learning, and neural networks. 2. Experience with audio signal processing and familiarity with audio data preprocessing techniques. 3. Proficiency in Python and experience with machine learning libraries such as TensorFlow, PyTorch, and Keras. 4. Knowledge of music theory and composition is a plus. 5. Experience with voice synthesis technologies such as WaveNet, Tacotron, or similar frameworks. 6. Familiarity with data augmentation lib...
...comprehensive experience in using Elementor to help me create an engaging and creative website. This is for my client who wants a fresh redesign of their website with a fresh and professional look. The website is a very basic 5 page website with no extra functionality required other than a basic contact form. I have already made a start on the project but no longer have time to complete it so I need to outsource the project. The website is a basic travel/retreat website I have already installed and set everything up I just need the winning bidder to create a great redesign of the site using Elementor. The winning bidder must have previous experience with Elementor for Wordpress with previous proof of work/portfolio. Please start your bid with the word rebel so I know you ...
I need help transcribing six handwritten pages in Spanish into a Word document. The handwriting is mostly clear, but there are some parts that are hard to read. I'm comfortable with the transcriber using their best judgment to decipher these parts. Additionally, there are no specific formatting requirements. Ideal skills and experience for this project: - Fluent in Spanish - Strong transcription skills, particularly with handwritten text - Attention to detail and ability to make informed decisions in cases of uncertainty.
I am seeking an experienced 3D designer to produce a STL file for a custom fan shroud for a KA-Box Goldshell miner. Your design should improve cooling performance and accommodate a 4 inch duct. Provided image is how I would like the design to look Measurements of the miner and distance in between screw holes can be provided if needed. The goal is to create a fan shroud that is not only functional, but also aesthetically pleasing. Expertise in 3D design and a solid understanding of cooling mechanisms in tech equipment will be advantageous.
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and ...
...interface similar to figma and with the functions below. *Does not need to be identical to figma, but maintain logic. Link Figma: How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and
I'm looking for an experienced developer who can work on an Android application with significant social ne...an experienced developer who can work on an Android application with significant social networking features. The app should have user profiles and authentication, as well as friend connections and messaging features. Ideal skills and experience: - Proficient in Python, with expertise in developing Android applications - Familiar with social networking app development - Experience with implementing user profiles, authentication, friend connections, and messaging Please only apply if you have a strong background in both Android and Python development, with a portfolio that demonstrates similar projects. Your understanding of social networking ...
I'm currently working on a printer port monitor and encountering an issue where it crashes the spooler. As a result, I need expert help to navigate this issue. Ideally, this person should have a strong background in low-level Windows C++ development. Key responsibilities include: - Investigating the root cause behind the spooler crashes - Guide towards the successful completion of the project Desired experience and skills: - Extensive experience with Windows C++ programming, particularly at a low level. - Understanding the complex nuances of printer operations, including how spooler functions. - Ability to clearly communicate troubleshooting strategies and solutions This project offers a unique opportunity for a skilled Windows C++ developer to showcase and develo...
Descrição do Projeto: Estamos buscando um especialista em análise de dados e me...diretrizes para integração no sistema de agendamento existente. Recomendações práticas para ajustes na operação e estratégia de controle de pragas baseadas nos resultados da análise. Habilidades Necessárias: Forte experiência em análise de dados e estatística. Conhecimento profundo em meteorologia e modelagem climática. Capacidade de integrar e manipular grandes conjuntos de dados. Experiência com Python, R ou outra linguagem de programação estatística. Excelentes habilidades de comunicação e relatório. Orçamento: Negociáve...
