Hello,
I tried to loop through pandas data frame.
However I receive an error message.
with a code like this:
one error is unexpected EOF while parsing,
another is row is not define.
Please advise or does someone have a working example of how to loop through a pandas data frame ?
inp = pd.DataFrame([{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}])
df = pd.DataFrame(inp)
print (df)
for index, row in df.iterrows():
print(row['c1'], row['c2'])
The creation of the dataframe can be simplified but everything works fine for me
import pandas as pd
inp = [{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}]
df = pd.DataFrame(inp)
print(df)
Output:
c1 c2
0 10 100
1 11 110
2 12 120
for index, row in df.iterrows():
#print(index)
#print(row)
print(row['c1'], row['c2'])
print()
Output:
10 100
11 110
12 120
I am getting this exact error message running the second part of your code.
I don't know why.
Quote:for index, row in df.iterrows():
File "<ipython-input-5-d488e4dd19c4>", line 1
for index, row in df.iterrows():
^
SyntaxError: unexpected EOF while parsing
That´s interesting.
Maybe there is some unknown (invisible) character in front of this code?
Please use a new cell (i assume you are using Jupyter notebook)
and do not copy paste but type code into it.
(Sep-01-2019, 06:19 PM)ThomasL Wrote: [ -> ]That´s interesting. Maybe there is some unknown (invisible) character in front of this code? Please use a new cell (i assume you are using Jupyter notebook) and do not copy paste but type code into it.
I did retype it and use instead of c1, c2, d1, d2.
I am not using Jupyter, but Spyder.
(Sep-01-2019, 06:19 PM)ThomasL Wrote: [ -> ]That´s interesting. Maybe there is some unknown (invisible) character in front of this code? Please use a new cell (i assume you are using Jupyter notebook) and do not copy paste but type code into it.
I found out what happen.
I was running the code line by line is why I got those message.
When I run them as chunks it works. Thanks !