M
M
Mastak1lla2020-06-02 17:30:06
Python
Mastak1lla, 2020-06-02 17:30:06

Parsing Excel and performing operations on data from a specific row?

1. | Full name | mail | date
2. | Full name | mail | date
3. | Full name | mail | date

There is such a table, how can I parse it and access the data of the cells, in fact, we need an algorithm and which modules to use. And the task, for example, is to compare the system date with the date from the 4th column of excel, and if it matches, display the full name on the screen where it matches. Thank you.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Z
zexer, 2020-06-02
@zexer

https://pandas.pydata.org/pandas-docs/stable/refer...

K
Korben5E, 2020-06-04
@Korben5E

This operation is called Filter, on the Data tab
Insert an empty line at the top of the list and turn on the filter

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question