Working with files
11 USD Write a function that takes the path to a CSV file as input and returns the path to a new file.
Ensure that if the file at the path provided to the function does not exist (try/except).
The function iterates through the rows of the file, performing the following actions for each one:
* Round values in numeric columns to whole numbers
* Replace yes/no with YES/NO
* If a value in a row is missing, print to the console the row where and which value is missing (In row 5, value 3 is missing).
* Insert "-" instead of the missing value
* Write the row to the new file.
Return the path to the new file with all changes!
Also attach the file you received
1. Count how many values are yes and no (by any method, you can read the file yourself or use any libraries).
2. Calculate the average, min, and max values for the fields num1, num2 (by any method, you can read the file yourself or use any libraries).
3. Using XlsxWriter, save the .csv from the main task as .xlsx. Make the first row (headers) bold and fill the header cells with some color. Fill the cells with yes in green. Fill the cells with no in red.
Applications 1
Client's review of cooperation with Andrii Panichuk
Working with filesEverything is great! The task was completed professionally and within the agreed timeframe. Thank you for the quality approach to work!
Freelancer's review of cooperation with Yevhen Inchevsky
Working with filesThank you for the project!
I am ready to work more!
-
1 day11 USD
1495 13 0 1 day11 USD
Good evening! I can take this order! Contact me privately. I hope for cooperation!
-
1 day11 USD
95312 1270 1 10 1 day11 USD
Hello. I have extensive experience with Python. I am ready to complete the task.
-
1 day11 USD
139 4 1 1 day11 USD
No problem, I will help you write something similar, I have extensive experience working with csv/xlsx files, write to me, I will complete the project as quickly and efficiently as possible.
-
1 day11 USD
1970 45 3 1 1 day11 USD
Good afternoon!
I am ready to write a script for working with csv files. I have a good knowledge of python, clean code.
-
1 day11 USD
1558 37 3 1 1 day11 USD
Good day. I have extensive experience working with Python. I have worked with both CSV and .xlsx multiple times. I will do it quickly and with high quality. I would be happy to collaborate.
-
1 day11 USD
105 1 day11 USD
And once again good evening, and I can complete this task with the files.
-
4 days11 USD
3392 84 0 4 days11 USD
Ready to take it on.
Write to me, we will discuss the order details.
I will implement it in Python.
-
1 day11 USD
3097 50 1 1 day11 USD
Good evening
I am ready to complete this work
Write to me, I will be happy to help
READY
READY
-
1 day11 USD
3020 73 4 2 1 day11 USD
Good evening! I have experience = I can do it!!!! Contact me!!!!!!
-
1 day11 USD
626 6 0 1 day11 USD
Good evening, I am ready to do all your labs for 500 UAH each, write to me in private messages, I will do everything if they are in Python. I have gone through something similar myself.
-
Це якась домашня робота студента?
-
Зараз ai може написати таке, у вас же є детальний опис:)) Виглядає як якась лабораторна робота
-
Current freelance projects in the category Databases & SQL
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 1 day 22 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 4 days 2 hours back ∙ 55 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 4 days 3 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (Penetr
Project Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 4 days 15 hours back ∙ 10 proposals |
Database synchronization
Synchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 4 days 21 hours back ∙ 13 proposals |
Odessa