Find Jobs
Hire Freelancers

Parse an Excel file and add fields to a MySQL DB

$30-250 USD

Teljesítve
Kiadva ekkor: körülbelül 1 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
Hello, I'm looking for a coder to make a Python script to do the following: 1. open the [login to view URL] file (sample) 2. parse the columns highlighted in yellow inside the sample file: 3. Add the entries into a MySQL Database/Table. IMPORTANT NOTES: - You will need to use the "[login to view URL]" as the reference for the database structure. - For any missing database field or error, please add or fix the "[login to view URL]" file - Please add a database field with the timestamp that the entry has been added in the following format: dd-mm-yyyy - The script will run in a low-memory and one vCPU virtual machine (1 GB), so please ensure the code is optimized to run in low specs VMs. - Please don't bid a low amount; once you have been assigned the winning bid, negotiate to a higher amount. - Other files will not have highlighted columns. This is to identify the required fields easily in this sample file. Attached - [login to view URL] - [login to view URL]
Projektazonosító: 36369160

A projektről

57 ajánlat
Távolról teljesíthető projekt
Aktiválva: 1 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
$0 USD 1 napon belül
4,9 (493 értékelés)
7,8
7,8
57 szabadúszó adott átlagosan $157 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Can you please share the database schema also?
$140 USD 1 napon belül
4,8 (115 értékelés)
7,1
7,1
Felhasználó avatár
Hello, I am interested to build a Python script that will automate this task. It will read the data in spreadsheet, process it and store the columns you need to your MySQL database. I have very good experience in the field and I am sure I can get this job done as soon as possible with best results. I am ready to start immediately and deliver the script in 2 days. I looked at your sample files and I am confident that I can get the task done. I am asking for only $100 for this task. Eagerly looking forward to working with you!
$80 USD 2 napon belül
5,0 (127 értékelés)
6,4
6,4
Felhasználó avatár
⭐⭐⭐⭐⭐ Hi there, I am full stack python developer with 7+ years of experience in website and desktop app and game development. I have read the details and checked both attached excel and .sql file as well, an easy job for me. Have a look at my profile for my portfolio and similar projects I've completed with reviews. Message me, we can discuss further details over chat.
$180 USD 2 napon belül
4,9 (56 értékelés)
6,2
6,2
Felhasználó avatár
Hello, I am an expert in Python/pandas and SQL. I think I would be a great fit for your project. I am available right away. Best, Borut
$140 USD 7 napon belül
5,0 (48 értékelés)
6,3
6,3
Felhasználó avatár
yeah i m expert with the DBMS so i can do that job ready to start work form now
$300 USD 2 napon belül
4,9 (24 értékelés)
5,9
5,9
Felhasználó avatár
Hello there, I am experienced in web scraping and to build script or a windows desktop application by using python. I am also experienced in large data scraping from the given website, by pass IP, Captcha, and anti bot or cloud flair protection. Please message me to discuss more regarding this project. Best Regards
$140 USD 7 napon belül
5,0 (25 értékelés)
5,7
5,7
Felhasználó avatár
Hi there. ⭐⭐ I am a full stack Developer ⭐⭐ with experience in Excel, Javascript, Shell Scripting, AWS, MY SQL, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many similar projects as i have a team of enthusiastic developers. We strive to give our best. Please contact to discuss in detail.
$120 USD 1 napon belül
5,0 (36 értékelés)
5,3
5,3
Felhasználó avatár
I can make python script as per your requirement. Please initiate a message so that i can clear few queries.
$150 USD 5 napon belül
4,9 (17 értékelés)
5,3
5,3
Felhasználó avatár
"Hi, I am an expert in Python. Can create the parse Excel features based on your requirement Skills: NodeJs, Python, PHP Please message me for further discussions. Thanks!"
$85 USD 2 napon belül
4,6 (82 értékelés)
5,8
5,8
Felhasználó avatár
Hi I have read your description carefully. ⭐ I have rich experiences in Xls to SQL, DB schema, MySQL, MS SQL server. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly message me. Thank you.
$50 USD 2 napon belül
4,9 (34 értékelés)
5,5
5,5
Felhasználó avatár
I can parse the excel and store data in db. Greetings, I have gone through your project description. I find myself as a perfect fit for this job. I am working as a Python Developer from last 2 year. Some of my expertise is in the fields: 1. Web Scraping/Web Automation - Selenium, Scrapy, Requests, Beautifulsoup 2. AI and ML 3. Web Designing 4. Wordpress 5. Data Science 6. C/C++ 7. SQL I will be available 24/7 to assist you during the project. So lets discuss more about it over chat. Yours Faithfully, Jaibhan Singh Gaur,
$30 USD 2 napon belül
5,0 (73 értékelés)
5,4
5,4
Felhasználó avatár
Hi there, I am an ML engineer. I can start right away and deliver within the deadline. So, Let’s have a quick conversation. I can be more specific once we get all the requirements and information required to execute the project. Thank you!!
$250 USD 7 napon belül
5,0 (39 értékelés)
5,1
5,1
Felhasználó avatár
Hi there! I'd be glad to get this Python script written for you and I can make sure its done to meet all your requirements. I've already looked at the Excel file and the sample database file you've attached and everything is clear to me. Only thing I need to get confirmed are the following: 1) the time stamp field you've wanted to add to the database. Should it simply be a field containing the data on which the records were parsed and added to the database file and contain only the date (not the time), in the format you've given? 2) what operating system you would be running this script under and what version of Python you are using? Please confirm this and I'd be ready to start working on this right away. Thank you and I look forward to helping you out with this Python script! My profile in brief: * Over 15 years of professional experience in programming, which includes extensive experience in Python programming * Rated among the top 1% of all freelancers * Successfully completed over 100 projects on the platform and maintain a 5 star rating * Maintain a 100% on-time project completion record * English fluency at a native speakers level * A full-time freelancer who puts 100% attention and dedication into a project once accepted * Please check my profile by clicking on my username for more information
$200 USD 2 napon belül
5,0 (15 értékelés)
5,2
5,2
Felhasználó avatár
Experienced python developer, can with all our requirement to transfer excel entries in MySQL databases
$160 USD 3 napon belül
5,0 (11 értékelés)
4,7
4,7
Felhasználó avatár
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experience. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$190 USD 7 napon belül
4,8 (12 értékelés)
5,0
5,0
Felhasználó avatár
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$150 USD 3 napon belül
4,4 (74 értékelés)
5,6
5,6
Felhasználó avatár
Parse an Excel file and add fields to a MySQL DB Hello Andre A., I would like to grab this opportunity and will be dedicated to your work till you get 100% satisfied with the tasks. I have 10+ years of experience on Python, SQL, MySQL, Database Programming. You can check out my freelancer portfolio section. I will also share my portfolio on further demand over a chat. Please come over chat and discuss your requirements in a detailed way. Thanks & Regards, Ali K.
$140 USD 7 napon belül
5,0 (6 értékelés)
4,6
4,6
Felhasználó avatár
Hello, I am interested in your project and can create a Python script to parse the required columns from the provided Excel file and add them to the MySQL database according to the given specifications. I will ensure that the code is optimized to run on a low-memory virtual machine with one vCPU. I will also add a database field for the timestamp in the specified format. Please let me know if you have any questions or concerns. Thank you for considering my bid. Best regards
$140 USD 2 napon belül
5,0 (17 értékelés)
4,5
4,5
Felhasználó avatár
hi there we are professional web developers. we can put data from excel to database yellow highlighted. kindly come in chat so we can start working on it now. thank you
$50 USD 1 napon belül
5,0 (15 értékelés)
4,2
4,2
Felhasználó avatár
Hello I am a professional python developer. My main specializations are automation, web scrapers and bots development. I have already developed over 200 scrapers. From the simplest (for example, a competitor's price collector) to complex parsers (with authorization, bypassing captcha, rotating ips and others) which can collect millions of products from amazon. I have done web scrapers for: - Amazon - Instagram - Facebook - Google - Twitter - LinkedIn - Pinterest - Walmart - And many others For scraping I use: - Python - Requests - BeautifulSoup - Selenium - Scrapy - Pyautogui - Undetected Chromedriver - Rotating ips I can bypass: - CloudFlare - IP blocking - Captcha - Authorization required - Other limitations Django / PostgreSQL For big scraping projects I usually use Django with PostgreSQL. This allows us to store information in a database for further processing and use. I also set up an administration area which allows us to check the data and set up scraper configs. If you need a professional solution in this area - I am ready to cooperate. I am ready to make a sample script before we start Regards, Oleg
$30 USD 7 napon belül
4,9 (9 értékelés)
4,1
4,1

Az ügyfélről

MOZAMBIQUE zászlója
Maputo, Mozambique
5,0
15
Fizetési mód hitelesítve
Tagság kezdete: szept. 17, 2017

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.