Right. I was also able to put all columns in a string and then use writerow().
Thanks.
Regards,
Mahmood
On Saturday, January 15, 2022, 10:33:08 PM GMT+1, alister via Python-list
wrote:
On Sat, 15 Jan 2022 20:56:22 + (UTC), Mahmood Naderan wrote:
> Hi,
> I use the fol
Hi,
I use the following line to write some information to a CSV file which is comma
delimited.
f = open(output_file, 'w', newline='')
wr = csv.writer(f)
...
f.write(str(n) + "," + str(key) + "\n" )
Problem is that key is a string which may contain ',' and this causes the final
CSV file to have
Hi
I have a csv file like this
V0,V1,V2,V3
4,1,1,1
6,4,5,2
2,3,6,7
And I want to search two rows for a match and find the column. For
example, I want to search row[0] for 1 and row[1] for 5. The corresponding
column is V2 (which is the third column). Then I
>I can help you narrow it down a bit. The problem actually occurs inside
>this function call somehow. You can verify this by doing this:
>
>
>fig,axes = plt.subplots(2,1, figsize=(20, 15))
>
>print ("axes[0].get_figure()=",axes[0].get_figure())
>
>You'll find that get_figure() is returning None, wh
Hi
I asked a question some days ago, but due to the lack of minimal producing
code, the topic got a bit messy. So, I have decided to ask it in a new topic
with a clear minimum code.
With Pandas 1.2.3 and Matplotlib 3.3.4, the following plot() functions returns
error and I don't know what is wr
>Your example isn't minimal enough for me to be able to pin it down any
>better than that, though.
Chris,
I was able to simply it even further. Please look at this:
$ cat test.batch.csv
Value,Value
10,2
5,2
10,2
$ cat test.py
import pandas as pd
import csv,sys
import matplotlib
import matplot
>I installed the latest pandas, although on Python 3.10, and the script
>worked without a problem.
Yes as I wrote it works with 1.3.3 but mine is 1.2.3.
I am trying to keep the current version because of the possible future
consequences. In the end maybe I have to upgrade the pandas.
Regards,
>The best way to get
>assistance here on the list is to create a minimal, self-contained,
>run-able, example program that you can post in its entirety here that
>demonstrates the issue.
I created a sample code with input. Since the code processes a csv file to
group input rows, I also included t
>And what is the result of plot()? Is it a valid object, or is it None?
Well the error happens on the plot() line. I tried to print some information
like this:
print("axes=", axes)
print("axes[0]=", axes[0])
print("cnt=", cnt)
print("row=", row)
ax1 = row.plot( fontsize=fon
>It's not saying get_axes doesn't exist because of version skew, it's
>saying that the object returned by the call to the left of it
>(get_figure()) returned None, and None doesn't have methods
>
>Something isn't set up right, but you'll have to trace that through.
Do you think the following
Hi
I am using the following versions
>>> import matplotlib
>>> print(matplotlib. __version__)
3.3.4
>>> import pandas as pd
>>> print(pd.__version__)
1.2.3
>>> import sys
>>> sys.version_info
sys.version_info(major=3, minor=8, micro=10, releaselevel='final', serial=0)
In my code, I use axes in
> (see
> https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html)
Got it. Thanks.
Regards,
Mahmood
--
https://mail.python.org/mailman/listinfo/python-list
Hi
While reading a csv file, some cells have values like '1,024' which I mean they
contains thousand separator ','. Therefore, when I want to process them with
row = df.iloc[0].astype(int)
I get the following error
ValueError: invalid literal for int() with base 10: '1,024'
How can I fi
>>> df.iloc[1].name
Correct I also see that 'df.index[1]' works fine.
Thanks.
Regards,
Mahmood
--
https://mail.python.org/mailman/listinfo/python-list
Hi
In the following dataframe, I want to get the index string by specifying the
row
number which is the same as value column.
Value
global loads 0
global stores 1
local loads 2
For example, `df.iloc[1].index.name` should return "global store
>The second argument of pd.concat is 'axis', which defaults to 0. Try
>using 1 instead of 0.
Unfortunately, that doesn't help...
dict[name] = pd.concat( [dict[name],values], axis=1 )
{'dummy': Value
M1 0
M2 0
M3 0, 'K1':Value Value
0 10.0NaN
15.0NaN
2
>Try this instead:
>
>
> dict[name] = pd.concat([dict[name], values])
OK. That fixed the problem, however, I see that they are concatenated
vertically. How can I change that to horizontal? The printed dictionary in the
end looks like
{'dummy': Value
M1 0
M2 0
M3 0, 'K1':
In the following code, I am trying to create some key-value pairs in a
dictionary where the first element is a name and the second element is a
dataframe.
# Creating a dictionary
data = {'Value':[0,0,0]}
kernel_df = pd.DataFrame(data, index=['M1','M2','M3'])
dict = {'dummy':kernel_df}
# dummy -
Hi
I have some lines in a text file like
ADD R1, R2
ADD3 R4, R5, R6
ADD.MOV R1, R2, [0x10]
If I grep words with this code
for line in fp:
if my_word in line:
Then if my_word is "ADD", I get 3 matches. However, if I grep word with this
code
for line in fp:
for word in line.split():
Yes thank you. The package is not compatible with 3.x.
Regards,
Mahmood
On Saturday, December 21, 2019, 1:40:29 AM GMT+3:30, Barry
wrote:
> On 20 Dec 2019, at 15:27, Mahmood Naderan via Python-list
> wrote:
>
> Hi
>
> I can install collect with pip for
Hi
I can install collect with pip for python2.7
$ pip install --user collect
Collecting collect
Using cached
https://files.pythonhosted.org/packages/cf/5e/c0f0f51d081665374a2c219ea4ba23fb1e179b70dded96dc16606786d828/collect-0.1.1.tar.gz
Collecting couc
OK thank you very much. As you said, it seems that it is too late for my python
script.
Regards,
Mahmood
On Monday, June 5, 2017 10:41 PM, Dennis Lee Bieber
wrote:
On Mon, 5 Jun 2017 14:46:18 + (UTC), Mahmood Naderan via Python-list
declaimed the following:
>>if the cell
>if the cell is an Excel date, it IS stored as a numeric
As I said, the "shape" of the cell is similar to date. The content which is
"4-Feb" is not a date. It is a string which I expect from cell.value to read it
as "4-Feb" and nothing else.
Also, I said before that the file is downloaded from
Maybe... But specifically in my case, the excel file is exported from a web
page. I think there should be a way to read the content as a pure text.
Regards,
Mahmood
--
https://mail.python.org/mailman/listinfo/python-list
Hello guys,
With openpyxl, it seems that when the content of a cell is something like
"4-Feb", then it is read as "2016-02-04 00:00:00" that looks like a calendar
conversion.
How can I read the cell as text instead of such an automatic conversion?
Regards,
Mahmood
--
https://mail.python.org/m
Hello guys...
With openpyxl, it seems that when the content of a cell is something like
"4-Feb", then it is read as "2016-02-04 00:00:00" that looks like a calendar
conversion.
How can I read the cell as text instead of such an automatic conversion?
Regards,
Mahmood
--
https://mail.python.org/
Consider this output
[root@cluster ~]# pip --version
pip 9.0.1 from /opt/rocks/lib/python2.6/site-packages/pip-9.0.1-py2.6.egg
(python 2.6)
[root@cluster ~]# easy_install --version
distribute 0.6.10
[root@cluster ~]# find /opt -name python
/opt/rocks/lib/graphviz/python
/opt/rocks/bin/python
/opt
Well yes. It looks in other folders
>>> import openpyxl
# trying openpyxl.so
# trying openpyxlmodule.so
# trying openpyxl.py
# trying openpyxl.pyc
# trying /usr/lib64/python2.6/openpyxl.so
# trying /usr/lib64/python2.6/openpyxlmodule.so
# trying /usr/lib64/python2.6/openpyxl.py
# trying /usr/lib64
Well, on rocks there exist multiple pythons. But by default the active is 2.6.6
$ python -V
Python 2.6.6
I have to say that the script doesn't modify sys.path. I only use sys.argv[]
there
I can put all dependent modules in my project folder but that will be dirty.
Regards,
Mahmood
On Tues
Thanks. I will try and come back later.
Regards,
Mahmood
On Tuesday, May 30, 2017 2:03 PM, Paul Moore wrote:
On Tuesday, 30 May 2017 08:48:34 UTC+1, Mahmood Naderan wrote:
> No idea?...
>
>
> Regards,
> Mahmood
>
>
> On Tuesday, May 30, 2017 1:06
Hello,
Although I have installed a package via pip on a centos-6.6, python interpreter
still says there is no such package!
Please see the output below
$ python exread2.py input.xlsx tmp/output
Traceback (most recent call last):
File "/home/mahmood/excetest/exread2.py", line 1, in
from openpyxl
No idea?...
Regards,
Mahmood
On Tuesday, May 30, 2017 1:06 AM, Mahmood Naderan via Python-list
wrote:
Hello,
How it is possible to embed a package in my project? I mean, in my python
script I have written
import openpyxl
So, the user may not have installed that package and doesn&#
Hello,
How it is possible to embed a package in my project? I mean, in my python
script I have written
import openpyxl
So, the user may not have installed that package and doesn't understand what is
pip!
Please let me know the instructions or any document regarding that.
Regards,
Mahmood
--
Thank you very much. I understand that
Regards,
Mahmood
On Friday, May 26, 2017 5:01 AM, Cameron Simpson wrote:
On 25May2017 20:37, Mahmood Naderan wrote:
>Cameron, thanks for the points. In fact the file name contains multiple '_'
>characters. So, I appreciate what
Hi guys,
Cameron, thanks for the points. In fact the file name contains multiple '_'
characters. So, I appreciate what you recommended.
filenames = {}
for name in glob.glob('*chunk_*'):
left, right = name.rsplit('_', 1)
if left.endswith('chunk') and right.isdigit():
fi
OK guys thank you very much. It is better to sort them first.
Here is what I wrote
files = glob.glob('*chunk*')
sorted=[[int(name.split("_")[-1]), name] for name in files]
with open('final.txt', 'w') as outf:
for fname in sorted:
with open(fname[1]) as inf:
for line in
>Yup. Make a list of all the file names, write a key function that
>extracts the numbery bits, sort the list based on that key function, and
>go to town.
>
>Alternatively, when you create the files in the first place, make sure
>to use more leading zeros than you could possibly need.
>xxx_chun
Hi,
There are some text files ending with _chunk_i where 'i' is an integer. For
example,
XXX_chunk_0
XXX_chunk_1
...
I want to concatenate them in order. Thing is that the total number of files
may be variable. Therefore, I can not specify the number in my python script.
It has to be "for all
Thanks a lot for suggestions. It is now solved.
Regards,
Mahmood
--
https://mail.python.org/mailman/listinfo/python-list
Excuse me, I changed
csv.writer(outstream)
to
csv.writer(outstream, delimiter =' ')
It puts space between cells and omits "" around some content. However, between
two lines there is a new empty line. In other word, the first line is the first
row of excel file. The second line is empty ("\
Thanks. That code is so simple and works. However, there are things to be
considered. With the CSV format, cells in a row are separated by ',' and for
some cells it writes "" around the cell content.
So, if the excel looks like
CHR1 11,232,445
The output file looks like
CHR1,"11,232,4
I wrote this:
a = np.zeros((p.max_row, p.max_column), dtype=object)
for y, row in enumerate(p.rows):
for cell in row:
print (cell.value)
a[y] = cell.value
print (a[y])
For one of the cells, I see
NM_198576.3
['NM_198576.3' 'NM_198576.3' 'NM_198576.3' 'NM_1985
Hi,
I used the old fashion coding style to create a matrix and read/add the cells.
W = load_workbook(fname, read_only = True)
p = W.worksheets[0]
m = p.max_row
n = p.max_column
arr = np.empty((m, n), dtype=object)
for r in range(1, m):
for c in range(1, n):
d = p.cell(row=r, colu
>a = numpy.zeros((ws.max_row, ws.max_column), dtype=float)
>for y, row in enumerate(ws.rows):
> a[y] = [cell.value for cell in row]
Peter,
As I used this code, it gave me an error that cannot convert string to float
for the first cell. All cells are strings.
Regards,
Mahmood
--
https://
Hi,
I am confused with that. If you say that numpy is not suitable for my case and
may have large overhead, what is the alternative then? Do you mean that numpy
is a good choice here while we can reduce its overhead?
Regards,
Mahmood
--
https://mail.python.org/mailman/listinfo/python-list
On Wed, 5/10/17, Peter Otten <__pete...@web.de> wrote:
Subject: Re: Out of memory while reading excel file
To: python-list@python.org
Date: Wednesday, May 10, 2017, 6:30 PM
Mahmood Naderan via Python-list wrote:
> Well actually cells are treated as
strings and not integer
n-list@python.org
Date: Wednesday, May 10, 2017, 3:48 PM
Mahmood Naderan via Python-list wrote:
> Thanks for your reply. The
openpyxl part (reading the workbook) works
> fine. I printed some debug
information and found that when it reaches the
> np.array, after some 10 seconds,
t
, May 10, 2017 7:25 PM, Peter Otten <__pete...@web.de> wrote:
Mahmood Naderan via Python-list wrote:
> Hello,
>
> The following code which uses openpyxl and numpy, fails to read large
> Excel (xlsx) files. The file si 20Mb which contains 100K rows and 50
> colu
Hello,
The following code which uses openpyxl and numpy, fails to read large Excel
(xlsx) files. The file si 20Mb which contains 100K rows and 50 columns.
W = load_workbook(fname, read_only = True)
p = W.worksheets[0]
a=[]
m = p.max_row
n = p.max_column
np.array([[i.value for i in j] for
OK. I did that but it fails! Please see the stack
D:\ThinkPad\Documents\NetBeansProjects\ExcelTest>pyinstaller exread.py
96 INFO: PyInstaller: 3.2.1
96 INFO: Python: 3.6.1
98 INFO: Platform: Windows-10-10.0.14393-SP0
103 INFO: wrote D:\ThinkPad\Documents\NetBeansProjects\ExcelTest\exread.spec
Hi,
I have simple piece of code which uses two libraries (numpy and openpyxl). The
script is called from another application. Currently, if someone wants to run
my program, he has to first install the python completely via its installer.
Is there any way to pack my .py with all required librarie
Hello,
I have downloaded python-3.6.1-amd64.exe and it is fine to install it through
GUI. However, I want to write a batch file to install it via command line.
Since the installation process is interactive, it seems that the auto-install
batch file is difficult. What I want to do is:
set python
Dear all,I am using GEM5, a simulator, which uses python for reading
configuration files.
For example in Caches.py
http://repo.gem5.org/gem5/file/7d95b650c9b6/configs/common/Caches.py#l31
a class L1cache is defined which we can set its parameters (size, assoc, ...).
The BaseCache is fully define
Tebeka
To: comp.lang.pyt...@googlegroups.com
Cc: python mailing list ; Miki Tebeka
; Mahmood Naderan
Sent: Friday, October 7, 2011 5:41 PM
Subject: Re: passing multiple string to a command line option
Seems like self.ptype is a type that has __init__ with no arguments (other than
self).
You
redecls(self, code):
self.ptype.swig_predecls(code)
def cxx_decl(self, code):
code('${{self.ptype.cxx_type}} ${{self.name}};')
// Naderan *Mahmood;
- Original Message -
From: Miki Tebeka
To: comp.lang.pyt...@googlegroups.com
Cc: python mailing list ; Mahmood Na
Dear developers,
Suppose I have this list in command line options:
... -b b1,b2,b3
Here is what I wrote:
parser = optparse.OptionParser()
# Benchmark options
parser.add_option("-b", "--benchmark", default="", help="The benchmark to be
loaded.")
process = []
benchmarks = options.benchmark.split(',
Well, login plain did the job:
session = smtplib.SMTP(smtpserver)
session.ehlo()
session.esmtp_features["auth"] = "LOGIN PLAIN"if AUTHREQUIRED:
session.login(smtpuser, smtppass)
// Naderan *Mahmood;
________
From: Mahmood Naderan
To: pytho
: python-list@python.org
Sent: Sun, August 22, 2010 5:50:00 PM
Subject: Re: Running python script before user login
On Sunday 22 August 2010, it occurred to Mahmood Naderan to exclaim:
> I am trying to execute this script before login:
>
> #!/bin/sh
> date > /home/mahmood/dateatboot
close()
...
After boot there is no .ip.txt file.
// Naderan *Mahmood;
From: Thomas Jollans
To: python-list@python.org
Sent: Sun, August 22, 2010 3:17:57 PM
Subject: Re: Running python script before user login
On Sunday 22 August 2010, it occurred to Mahmood Naderan to exclai
Naderan *Mahmood;
From: Chris Rebert
To: Mahmood Naderan
Cc: python mailing list
Sent: Sun, August 22, 2010 1:28:45 PM
Subject: Re: Running python script before user login
On Sun, Aug 22, 2010 at 1:52 AM, Mahmood Naderan wrote:
> I have wrote a python script
I have wrote a python script and want to run it before user login. To do that,
I
have added it to the ubuntu startup file (init.d). However it seems that the
script doesn't work.
I want to know does python modules work before user login?
// Naderan *Mahmood;
--
http://mail.python.o
I have this script to send an email via SMTP:
import smtplib
smtpserver = 'smtp.server.com'
AUTHREQUIRED = 1# if you need to use SMTP AUTH set to 1
smtpuser = "username"# for SMTP AUTH, set SMTP username here
smtppass = "password"# for SMTP AUTH, set SMTP password here
RECIPIENTS ='recipi...@server
quot;interprets" the byte code.
>So, it's an interpreter that compiles the code first.
Thanks. I got it.
// Naderan *Mahmood;
From: Stephen Hansen
To: python-list@python.org
Sent: Fri, July 30, 2010 11:13:27 PM
Subject: Re: how python works
On
So is it a compiler or interpreter?
// Naderan *Mahmood;
From: Burton Samograd
To: python-list@python.org
Sent: Fri, July 30, 2010 10:36:56 PM
Subject: Re: how python works
Mahmood Naderan writes:
> I want to know how python executes a .py file. Someti
I want to know how python executes a .py file. Sometimes when I run a file, I
get an error that there is a syntax error. This shows that the parser read and
parse the whole file. Sometimes in the middle of the run I get an error
that another line has problem. So how does it work? if it doesn't c
, the above technique is acceptable if function() is very
>long-running (multiple seconds, at least).
yes, the code is long running.
Thanks
// Naderan *Mahmood;
From: Matteo Landi
To: Mahmood Naderan
Cc: python mailing list
Sent: Thu, July 29, 2010 5:12:58
Hi,
I want to measure a function run time. I read
http://docs.python.org/library/time.html but I am confused and don't know which
one is suitable. I don't know is daylight timing important or not or is Y2K
issue important for my case or not I also don't know how epoch time is
related to
.org
Sent: Fri, June 11, 2010 2:05:15 PM
Subject: Re: passing environment variable path to open command
Am 11.06.2010 10:39, schrieb Mahmood Naderan:
> Hi,
> I am new to python so my question may be very basic.
> Suppose I have a file (sc_1.sh) which the path to that file is in system path:
>
Hi,
I am new to python so my question may be very basic.
Suppose I have a file (sc_1.sh) which the path to that file is in system path:
SOMETHING=/home/mahmood/scripts
Now I want to open that file with respect to the environment variable:
import os
env = os.getenv("SOMETHING")
print env
69 matches
Mail list logo
