Python function to work with Google Sheets
1 . The name of the tables in Google Sheets.
The 2nd Coordinate the first cell table (e.g. “A1”)
3 . Coordinates of the last cell of the table (e.g. “D5”)
Returns the dictionary in the format:
by {
The name of the table: {
‘Royal_1-Stop_1’ : 12
‘Royal_1-Stop_2’ : 11
... →
‘Royal_4-Stock_3’ : 1}
The
An example of a table on which the aforementioned dictionary is formed in the added image.
Conditions of:
Use of gspread package
Use the method get in the gspread package.
Documentation: https://docs.gspread.org/en/latest/user-guide.html#getting-all-values-from-a-row-or-a-column
Applications 1
Client's review of cooperation with Illia V.
Python function to work with Google SheetsThe task is performed quickly and efficiently. I recommend cooperation.
Freelancer's review of cooperation with Volodimir Pohorily
Python function to work with Google SheetsA clear TZ with an example, I recommend.
-
Ready to write quickly and efficiently immediately after choosing me as an executive
-
445 28 1 Hello, ready to do, call me!
The work will be done qualityly!
I will be happy to cooperate!
-
94002 1264 1 10 Hello.Ready to implement the function.Will the url script table open?
-
389 15 3 Hello, ready to write your program, write, I'll be happy to collaborate
-
859 22 0 1 Ready to implement your project on the paton. Contact me to clarify details.
-
4189 123 0 Nothing complicated!
Let me write today, call me!
_________________________________________________
Current freelance projects in the category Python
Creation of a Human AI Assistant for Telegram groups### 1.1. Key Concept of the System The system must perform two main functions: #### 1. Client Communication Analysis The AI assistant must automatically analyze all communication in Telegram groups and understand the context of the conversation. In particular, the system… AI & Machine Learning, Python ∙ 1 hour 32 minutes back ∙ 14 proposals |
Black Ukraine (RP-project on base MTA)
1162 USD
|
Betting needs to create a bookmaker! WITH EXPERIENCEIt is necessary to develop a betting platform / bookmaker product based on a ready-made template. The main task is to adapt the template for a full-fledged bookmaker office: connect parsing of sports events and odds, implement a user personal account, balance, bets, transaction… Python, Web Programming ∙ 2 hours 8 minutes back ∙ 16 proposals |
Telegram automation of message distribution in chatsNeed to send messages to Telegram chats. To avoid bans. There are several hundred chats. To configure the frequency and variability of texts. Python, Bot Development ∙ 2 hours 19 minutes back ∙ 18 proposals |
Development of software with AIIt is necessary to develop software for automatic detection, capturing, and tracking of an object using a video camera and a rotating mechanism.Output data: Video camera with optics. Rotating device on two axes (azimuth/elevation angle). Servomotors controlled via Modbus… AI & Machine Learning, Python ∙ 1 day 9 hours back ∙ 16 proposals |