Đã hoàn thành

Transform an excel file in two data frames, in Python

Job Description:

Target:

Transform the data from an excel file ('[login to view URL]') in two data frames. This excel file have, normaly, different pages. Therefore, the python function should open the excel file and be able also to read excel pages.

Input:

The python function will receive as input an excel file, e.g: "[login to view URL]" or "[login to view URL]". The necessary information is between rows 134 and 205. However, the funtion should be able to search words and date and not just count rows.

key words to be able to find the information are:

"Formato Global"

"Cuentas No Consolidadas"

"Balance de situación"

"Cuentas de pérdidas y ganancias"

"Ratios formato global"

Output:

The python function will return two data frames, like in the ones in "[login to view URL]". The funtion that is used to read and open the excel file, have to be able to also read the pages from the excel file because, later, there will be implemented a loop to read all pages from an excel file.

Hints:

The lib "openpyxl" have some error to open excel files sometimes!!

Kĩ năng: Python, Xử lí dữ liệu, Nhập liệu, Excel, Pandas

Về khách hàng:
( 3 nhận xét ) Munich, Germany

ID dự án: #35879431

Được trao cho:

tadinhkien

Greetings! How are you today? Thanks for posting this job. I have checked your project description. ✅I'm AI engineer also Developer with 6+ years experiment.✅ I am very familiar to Deep learning such as Tensorflow an Thêm

€18 EUR trong 1 ngày
(186 Đánh Giá)
6.3

24 freelancer chào giá trung bình€22 cho công việc này

konanhenry1111

⭐⭐⭐⭐⭐⭐ I can start doing it right now ⭐⭐⭐⭐⭐⭐ if u check my reviws u will find me did the same project before also I have all these skills Data Processing, Python, Data Entry, Exceland Pandas trust me ✌️ I can do it ve Thêm

€20 EUR trong 1 ngày
(214 Nhận xét)
7.1
merinsinha

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 Thêm

€29 EUR trong 1 ngày
(191 Nhận xét)
6.1
eduardoherreral4

hi I have read your description carefully. ⭐ I have rich experiences in Python, Data Frame, Excel to Dataframe, Data entry. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly mes Thêm

€19 EUR trong 1 ngày
(26 Nhận xét)
5.0
benson2augustine

hi friend, iam a software developer by profession,iam working as a fullstack developer ,we can do it using python pandas and xlrd module if ur interested lets discuss

€30 EUR trong 2 ngày
(21 Nhận xét)
5.2
gajematthias

Hello! How are you? I'm glad to bid on your project. I'm a python expert with 8+ years experience and I'm very familiar with various libraries and packages including matplotlib,pyplot,selenium ,pandas,NLTK,tensorflow Thêm

€30 EUR trong 1 ngày
(10 Nhận xét)
4.7
maarijifitkhar5

Hi, I have gone through your project details and am ready to provide you a code which will deliver you the two parts from a single sheet of excel, to read and open the excel file. I am an Electrical Engineer and have Thêm

€8 EUR trong 1 ngày
(14 Nhận xét)
3.6
trzkairo

Hey, how's it going? I work with the development of web applications, automations, scrappers. Could you give me more details about what you need exactly?

€14 EUR trong 1 ngày
(3 Nhận xét)
3.4
GhoulamIlyasse

Hello, I am a highly skilled AI freelancer with experience in transforming data from excel files into data frames. I am confident that I can meet your needs for this project. I have extensive knowledge in Python and Thêm

€30 EUR trong 4 ngày
(10 Nhận xét)
3.5
eslamafify

Hello Hope everything is well with you.I read your job description and I'm able to do it with good quality of work. I did such projects before. Let's discuss more details.

€20 EUR trong 3 ngày
(7 Nhận xét)
3.2
Saurabhs2001

Hello there, I have hands on knowledge of python more than on year. I definitely do your task. reply as soon as possible. Thank you.

€10 EUR trong 1 ngày
(10 Nhận xét)
3.5
omemajawaid

Hi there, I have read your job description carefully and I’m confident I can do this project for you perfectly. I still have a few questions. Please leave a message on my chat so we can discuss the budget and deadline Thêm

€50 EUR trong 6 ngày
(3 Nhận xét)
2.8
corriganleojohn

Hi, Respected my client!!! I am an expert of this part and I am ready to work right now. I want to help you and I will complete your project perfectly on deadline. I understood your requirements fully but I have some Thêm

€19 EUR trong 1 ngày
(1 Nhận xét)
2.0
wilfrednjorog

Hello! I am professional writer with the vast skills and qualifications necessary for this job. I have experience in Pandas, Excel, Data Processing, Data Entry and Python. I am confident that I can produce high-quali Thêm

€25 EUR trong 2 ngày
(2 Nhận xét)
0.6
Muhammadzeesha59

Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Mysql , Sql , Oracle , Object Oriented Programming , Data Structure , Algorithms . Thêm

€19 EUR trong 1 ngày
(0 Nhận xét)
0.0
jaiprasadreddy

I can help you converting the xls file into dataframe and also provide a simple UI for you for future usecase of similar task.

€20 EUR trong 1 ngày
(0 Nhận xét)
0.0
mccarthr

Hello, I am a Engineer with experience transforming data frames in excel. I believe I would be a great fit to complete this project is a fast and effective manor.

€19 EUR trong 7 ngày
(0 Nhận xét)
0.0
juansecarvajal1

I’m a recently graduated programmer specialized in python, I’ve done that a couple of times, I only need the excel

€19 EUR trong 7 ngày
(0 Nhận xét)
0.0
jaanu1996

Hi, I'm expert in data processing, data entry,excel. I will reach your requirements with in the time. Regards. Jayanandini

€25 EUR trong 7 ngày
(0 Nhận xét)
0.0
Khawar000

Are you looking for a reliable and accurate data entry specialist? Look no further! I offer professional data entry services with experience in Microsoft Excel and Word, as well as Google Sheets and Docs. I am commit Thêm

€25 EUR trong 4 ngày
(0 Nhận xét)
0.0