read from file

[mcgrim]

just to make sure.
This code

file=open('kwh.dat','r')
yearmonthday=[]; kwh1=[]
for i in file:
    tempsplit=i.split(" ")
    yearmonthday.append(tempsplit[0])


    kwh1.append(str(tempsplit[1])) # or kwh1.append((tempsplit[1]))
print(kwh1)
print(yearmonthday)

produces this output
['st', 'line']
['1', '2nd']

and if I change the 6th line with

kwh1.append(int(tempsplit[1]))

I get the error mentioned above.

So are you saying that with this current code I should be obtaining the right outcome?
What do you think is wrong?

---

one more thing I think is worth mentioning:
I am trying to import this file by clicking on the arrow
on the top middle of the spyder compiler
and once I write the file name I want to import,
I get this message:

unsupported file extension '.dat'
Would you like to import it anyway?
(by selecting a known file format)


and it still does not work no matter what I select.

[buran]

I am saying that whatevewer file you read, it looks like this

Output:
1 st line
2nd line

ring any bells?

[mcgrim]

first of all,
what exactly should I write in my compiler to get the output you just listed?
Secondly,
What should I write to obtain on the console all those numbers that I pasted in my
previous post contained in the file?
Moreover, what can you tell me about my issue with importing the file
I mentioned above?
Is it relevant for me to accomplish my task? If so, what should I do ?

[buran]

what exactly should I write in my compiler to get the output you just listed?

What I listed is my guess based on the output provided by you:

print(kwh1)
and
print(yearmonthday)

give only the following outcome:

['st', 'line']
['1', '2nd']

to print the whole file, run:

with open('kwh.dat','r') as my_file:
    for line in my_file:
        print(line)

this will print file content line by line

What should I write to obtain on the console all those numbers that I pasted in my
previous post contained in the file?

as I said your code should work, given that you read the correct file

Moreover, what can you tell me about my issue with importing the file
I mentioned above?
Is it relevant for me to accomplish my task? If so, what should I do ?

I don't use Spider, but I don't see why I would need to import anything

[mcgrim]

I used the code you wrote

with open('kwh.dat','r') as my_file:
    for line in my_file:
        print(line)

and now I am getting

Output:
1 st line 

2nd line 

but what I am really trying to do, is to print two lists
and I want to be able to see the results in my console.
the list kwh1 should print

Output:
327384
326351
 325478
 324789
 324089
323185
322040
320915
319494
.
.
.
.
etc

and yearmonthday
should print

Output:
2015-11-01 
2015-10-01 
2015-09-01 
2015-08-01 
2015-07-01 
2015-06-01 
2015-05-01 
2015-04-01
.
.
.
etc

Now, how come I am not able to print these values?
Where is the problem with my code?
If you say that my code is correct, how come I am not able
to see these two lists?

[buran]

I cannot explain it more clear - the file that you read has the content I guessed and you just confirmed it.
You need to read from the correct file to get the output you want. Obviously you have more than one file with same name in different locations and the file that you read is not the one you think you read.

[mcgrim]

Thank you.
Now is clear.