Re: How to solve the given problem?

2022-02-10 Thread NArshad
-ChrisA: You don't reply if you have problems. When I don't find any solution elsewhere then only I place in this group -Christian: One problem of different type requires the same elaboration. Q. What technique of statistics or numerical computation or general mathematics to use to solve this

How to solve the given problem?

2022-02-09 Thread NArshad
Assume that there is a pattern of feeding for a special fish in a day (10 hours a day) as below: 150100303030202010 55 Today, the fish is fed in the second hour 60 unit instead of 100 unit Accidently. Implement some methods to d

PermissionError: [Errno 13] Permission denied: 'Abc.xlsx'

2022-02-09 Thread NArshad
When I enter data using Tkinter form in an Excel file when the excel file is closed there is no error but when I enter data using Tkinter form when the excel is already open following error comes: Exception in Tkinter callback Traceback (most recent call last): File "C:\Users\Dani Brothers\A

Re: What to write or search on github to get the code for what is written below:

2022-01-31 Thread NArshad
What about CGI? Do you know any Library Management System based on CGI just like the one on Django? -- https://mail.python.org/mailman/listinfo/python-list

Re: What to write or search on github to get the code for what is written below:

2022-01-24 Thread NArshad
On Sun, 23 Jan 2022 09:17:38 +1100, Chris Angelico <> declaimed the following: > >Absolutely agree with making a console app first. Though I rather >suspect the OP doesn't want to write any code at all. > I am not writing any code because I don’t know what code to do next. Still, I have made a

Re: What to write or search on github to get the code for what is written below:

2022-01-22 Thread NArshad
The user is going to enter the book name as the input of an HTML form on a website and I have to check whether the book is present or not in the Excel table. openpyxl preferred pandas is also fine anything left. Case sensitivity is not required. I tried to find code or tutorial on google searc

Re: What to write or search on github to get the code for what is written below:

2022-01-20 Thread NArshad
- I will try to follow all that you people are saying, but it will take time or next time. The chance of concurrency is very less. Kindly don't write big descriptions. - The weblink Avi Gross has given is very useful. -- https://mail.python.org/mailman/listinfo/python-list

Re: What to write or search on github to get the code for what is written below:

2022-01-18 Thread NArshad
Avi Gross: What does the website "https://mail.python.org/mailman/listinfo/python-list"; do? Can I use this for the discussions which I require? -- https://mail.python.org/mailman/listinfo/python-list

Re: What to write or search on github to get the code for what is written below:

2022-01-17 Thread NArshad
Avi Gross: -“They just were hoping someone would post complete code and they could then move on without learning anything.” This is due to the time factor -- https://mail.python.org/mailman/listinfo/python-list

Re: What to write or search on github to get the code for what is written below:

2022-01-15 Thread NArshad
What Dennis Lee is saying I will see to it later. Right now what mrabarrnett is saying is of use. Why does the code written below is not giving any output? xls = ExcelFile('ABC.xlsx') df = xls.parse(xls.sheet_names[0], index_col=1) x=df.to_dict() print (x) Only the contents o

Re: What to write or search on github to get the code for what is written below:

2022-01-13 Thread NArshad
- “if you are deploying to something like Heroku for the application -- the Excel file will have to be deployed also, and no one except your application will be able to see it there. Under this situation, there is no reason/excuse to keep the data in the very inefficient format you've defined i

Re: What to write or search on github to get the code for what is written below:

2022-01-12 Thread NArshad
-“How are the relevant cells identified in the spreadsheet?” The column headings are: BOOK_NAME BOOK_AUTHOR BOOK_ISBN TOTAL_COPIES COPIES_LEFT BORROWER’S_NAME ISSUE_DATE RETURN_DATE -“It's often the case that the cells on the first row contain text as column labels.” These I have written above

Re: What to write or search on github to get the code for what is written below:

2022-01-10 Thread NArshad
Using openpyxl is pretty straightforward: from openpyxl import load_workbook wb = load_workbook(spreadsheet_path) sheet = wb.active # Reading the values in cells: print('Cell A1 contains', sheet['A1'].value) print('Cell A2 contains', sheet['A2'].value) print('Cell B1 contains', sheet['B1'].valu

Re: What to write or search on github to get the code for what is written below:

2022-01-09 Thread NArshad
-Whose time?? My time I do not have not time to switch to a database but if necessary I can use the database to make changes in Excel column entries. -No changes?? I cannot change the column names. -“maybe the point is that at any time one has to be able to re-export to the original excel

Re: What to write or search on github to get the code for what is written below:

2022-01-09 Thread NArshad
On Friday, 7 January 2022 at 02:59:17 UTC+5, alister wrote: > On Thu, 6 Jan 2022 10:55:30 -0800 (PST), NArshad wrote: > > > All this is going to be in python’s flask and HTML only > > > > 1. First, I have to check in the Excel sheet or table whether the book > >

What to write or search on github to get the code for what is written below:

2022-01-07 Thread NArshad
All this is going to be in python’s flask and HTML only 1. First, I have to check in the Excel sheet or table whether the book user has entered is present in the book bank or not. 2. If a book is present and the quantity of the required book is greater than 0 (COPIES_LEFT column in excel file)

AttributeError: 'NoneType' object has no attribute 'get'

2022-01-05 Thread NArshad
How to correct what is written below: Exception in Tkinter callback Traceback (most recent call last): File "C:\Users\Dani Brothers\Anaconda3\lib\tkinter\__init__.py", line 1705, in __call__ return self.func(*args) File "D:/Python/Book Bank/New folder/PyCharm/Final/Excel.py", line 57, in