Transform an excel file in two data frames, in Python

Suoritettu Julkaistu 1 vuosi sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

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!!

Python Tietojenkäsittely Tiedonsyöttö Excel Pandas

Projektin tunnus: #35879431

Tietoa projektista

23 ehdotusta Etäprojekti Aktiivinen 1 vuosi sitten

Myönnetty käyttäjälle:

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 Lisää

€18 EUR 1 päivässä
(195 Arvostelua)
6.4

23 freelanceria on tarjonnut keskimäärin €22 tähän työhön

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 Lisää

€20 EUR 1 päivässä
(248 arvostelua)
7.2
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 Lisää

€29 EUR 1 päivässä
(194 arvostelua)
6.2
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 2 päivässä
(21 arvostelua)
5.4
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 Lisää

€19 EUR 1 päivässä
(26 arvostelua)
5.0
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 Lisää

€30 EUR 1 päivässä
(10 arvostelua)
4.7
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 Lisää

€30 EUR 4 päivässä
(17 arvostelua)
4.1
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 Lisää

€8 EUR 1 päivässä
(15 arvostelua)
3.7
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 Lisää

€50 EUR 6 päivässä
(7 arvostelua)
3.4
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 3 päivässä
(9 arvostelua)
3.4
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 1 päivässä
(14 arvostelua)
3.8
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 Lisää

€25 EUR 2 päivässä
(2 arvostelua)
2.9
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 Lisää

€19 EUR 1 päivässä
(1 arvostelu)
2.0
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 . Lisää

€19 EUR 1 päivässä
(0 arvostelua)
2.1
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 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 Lisää

€25 EUR 4 päivässä
(0 arvostelua)
0.0