Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: Strange Problem when reading from excel
Post: RE: Strange Problem when reading from excel
It is a python module in a CAE software. I am reading with utils.XlsxOpen and utils.XlsxGetCellValue codes.
It is OK and I have the results, I checked with a new Excel file also and it is OK, but for ... |
|
faryad13 |
General Coding Help |
3 |
2,386 |
Nov-04-2020, 03:30 PM |
|
|
Thread: Strange Problem when reading from excel
Post: Strange Problem when reading from excel
Hi everybody
I faced one strange problem:
I have two similar excel file and I am trying to read some data from them, For the first excel file is OK and when I run the code I receive the value in a m... |
|
faryad13 |
General Coding Help |
3 |
2,386 |
Nov-04-2020, 03:03 PM |
|
|
Thread: Reading from Excel: value not formula!
Post: Reading from Excel: value not formula!
Hi everybody
I am trying to read some data from an excel file in python. Here is a part of my code:
def main():
xl_element = utils.XlsxOpen(r'C:\..........sheet1.xlsx' )
value_1=utils.XlsxGetCellVa... |
|
faryad13 |
General Coding Help |
0 |
2,347 |
Oct-28-2020, 09:52 PM |
|
|
Thread: SystemError: error return without exception set!!!
Post: RE: SystemError: error return without exception se...
yes....this was the problem.
when I closed the excel file it was OK again. Interesting!
Thank you. |
|
faryad13 |
General Coding Help |
3 |
3,645 |
Oct-23-2020, 02:27 PM |
|
|
Thread: SystemError: error return without exception set!!!
Post: SystemError: error return without exception set!!!
Hi everybody
I am trying to read s0me data from an excel file in python. Here is a part of my code:
def main():
xl_element = utils.XlsxOpen(r'C:\..........sheet1.xlsx' )
value_1=... |
|
faryad13 |
General Coding Help |
3 |
3,645 |
Oct-23-2020, 02:18 PM |
|
|
Thread: Trouble with converting list , dict to int values!
Post: RE: Trouble with converting list , dict to int val...
hello guys
i found what should i do
i solved it |
|
faryad13 |
General Coding Help |
7 |
3,747 |
Sep-04-2020, 06:25 AM |
|
|
Thread: How to make a list of values from a dictionary list?
Post: RE: How to make a list of values from a dictionary...
(Sep-03-2020, 02:15 PM)DeaD_EyE Wrote: Iterate over the elements, access the key "X" and append it to a new list.
results = []
for element in L:
...
# this is your taskhttps://docs.python.o... |
|
faryad13 |
General Coding Help |
2 |
2,064 |
Sep-03-2020, 03:45 PM |
|
|
Thread: How to make a list of values from a dictionary list?
Post: How to make a list of values from a dictionary lis...
Hello Guys
Good day
I have a list with dictionaries inside:
L=[{'X': 2593.75}, {'X': 2457.42}, {'X': 2593.75}, {'X': 2457.42}] <class 'list'>
How can I make a new list only with the values. I ... |
|
faryad13 |
General Coding Help |
2 |
2,064 |
Sep-03-2020, 01:27 PM |
|
|
Thread: Trouble with converting list , dict to int values!
Post: RE: Trouble with converting list , dict to int val...
(Sep-03-2020, 12:40 PM)deanhystad Wrote: I'm not sure if you could pack in any more errors into such a short line of code.
diff = abs (x(1)-(2))Start with x is a list. You cannot do x(). You can d... |
|
faryad13 |
General Coding Help |
7 |
3,747 |
Sep-03-2020, 12:52 PM |
|
|
Thread: Trouble with converting list , dict to int values!
Post: RE: Trouble with converting list , dict to int val...
(Sep-03-2020, 12:14 PM)buran Wrote: You really need to read some very basic things, e.g. working with dicts
https://python-forum.io/Thread-Basic-Dictionaries
Thanks for your advice, i am a beginner ... |
|
faryad13 |
General Coding Help |
7 |
3,747 |
Sep-03-2020, 12:21 PM |
|
|
Thread: Trouble with converting list , dict to int values!
Post: RE: Trouble with converting list , dict to int val...
(Sep-03-2020, 12:06 PM)DPaul Wrote: It is better to show us the code that fails.
But as a general observation, your list should have a name e.g. "L"
Then L(1) is a dictionary, not a value.
Paul
yes... |
|
faryad13 |
General Coding Help |
7 |
3,747 |
Sep-03-2020, 12:12 PM |
|
|
Thread: Trouble with converting list , dict to int values!
Post: Trouble with converting list , dict to int values!
Hello guys
good day
I have a list of 4 points with x values:
[{'X': 2593.75}, {'X': 2457.42}, {'X': 2593.75}, {'X': 2457.42}] <class 'list'>
for example x(1) is:
{'X': 2457.42} <cla... |
|
faryad13 |
General Coding Help |
7 |
3,747 |
Sep-03-2020, 11:08 AM |
|
|
Thread: A big for in for Loop!
Post: RE: A big for in for Loop!
(Sep-03-2020, 06:30 AM)bowlofred Wrote: 10000 isn't a large number for modern machines. Use a counter to count all the points. Then print all the points that have a count greater than 1.
from col... |
|
faryad13 |
General Coding Help |
5 |
2,249 |
Sep-03-2020, 08:09 AM |
|
|
Thread: A big for in for Loop!
Post: RE: A big for in for Loop!
(Sep-03-2020, 06:10 AM)buran Wrote: what object is used to represent a point - tuple/named tuple, custom class?
this line if x(i)=x(j) and y(i)=y(j) and z(i)=z(j) and p(i)=p(j) suggest you have sepa... |
|
faryad13 |
General Coding Help |
5 |
2,249 |
Sep-03-2020, 06:13 AM |
|
|
Thread: A big for in for Loop!
Post: A big for in for Loop!
Hello guys
good day
I have a list of near 10000 points with x,y,z coordinates and a fourth property which is 1 or 2 or 3 (let call it p).
The points are mostly in pair, I mean for almost 95% of points... |
|
faryad13 |
General Coding Help |
5 |
2,249 |
Sep-03-2020, 05:58 AM |