Transform an excel file in two data frames, in Python
Ngân sách €8-30 EUR
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!!
Được trao cho:
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
24 freelancer chào giá trung bình€22 cho công việc này
⭐⭐⭐⭐⭐⭐ 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
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
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
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
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
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
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?
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
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.
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.
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
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
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
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
I can help you converting the xls file into dataframe and also provide a simple UI for you for future usecase of similar task.
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.
I’m a recently graduated programmer specialized in python, I’ve done that a couple of times, I only need the excel
Hi, I'm expert in data processing, data entry,excel. I will reach your requirements with in the time. Regards. Jayanandini