CODEWITHSUNDEEP
pythonarrays
Sjcarlso
Sjcarlso

Reputation: 119

How to Open a Text File and Create an Array in Python

I have a text file called Orbit 1 and I need help opening it and then creating three separate arrays. I'm new to Python and have been having difficulty with this aspect. Here are the first few rows of my text file. There are 1112 rows including the header.

Year    Month   Day Hour    Minute  Second  Millisecond Longitude   Latitude    Altitude
2019    3   17  5   55  55  0   108.8730074 50.22483151 412.6226898
2019    3   17  5   56  0   0   108.9895097 50.53642185 412.7368197
2019    3   17  5   56  5   0   109.1078294 50.8478274  412.850563
2019    3   17  5   56  10  0   109.2280101 51.15904424 412.9640113
2019    3   17  5   56  15  0   109.3500969 51.47006828 413.0772319
2019    3   17  5   56  20  0   109.4741362 51.78089533 413.1901358
2019    3   17  5   56  25  0   109.6001758 52.09152105 413.3025291
2019    3   17  5   56  30  0   109.728265  52.40194099 413.414457
2019    3   17  5   56  35  0   109.8584548 52.71215052 413.5259984
2019    3   17  5   56  40  0   109.9907976 53.02214489 413.6371791

I desire to open this text file to create three arrays called lat[N], long[N], and time[N] where N is the number of rows in the file. I ultimately want to be able to determine what the latitude, longitude, and time is at any point. For example, lat[0] should return 50.22483151 if working properly. In addition, for the time, I would need to convert to decimal hours and then create the array.

Essentially I need help with opening this text file I have and then creating the three arrays.

I've tried this method for opening the file, but I get stuck when trying to write the array and I think I may not be opening the file correctly.

import numpy as np
 
file_name = 'C:\\Users\\Saman\\OneDrive\\Documents\\Orbit 1.txt'

data = []
with open(file_name) as file:
    next(file)
    for line in file:
        row = line.split()
        row = [float(x) for x in row]
        data.append(row)

Upvotes: 0

Views: 332

Answers (2)

DYZ
DYZ

Reputation: 57033

The most effortless way to solve your problem is to use Pandas:

import pandas as pd
df = pd.read_table('Orbit 1.txt', sep=r'\s+')
df['Longitude']
#0    108.873007
#1    108.989510
#2    109.107829
#3    109.228010
#4    109.350097
#5    109.474136
#6    109.600176
#7    109.728265
#8    109.858455
#9    109.990798

Once you get a Pandas DataFrame, you may want to use it for the rest of the data processing, too.

Upvotes: 1

ubaid shaikh
ubaid shaikh

Reputation: 453

file_name = 'info.txt'

Lat=[]
Long=[]
Time=[]
left_justified=lambda x: x+" "*(19-len(x))
right_justified=lambda x: " "*(19-len(x))+x

with open(file_name) as file:
    next(file)
    for line in file:
        data=line.split()
        Lat.append(data[8])
        Long.append(data[7])
        hrs=int(data[3])
        minutes=int(data[4])
        secs=int(data[5])
        total_secs=secs+minutes*60+hrs*3600
        Time.append(total_secs/3600)
        
print(left_justified("Time"),left_justified("Lat"),left_justified("Long"))
for i in range(len(Lat)):
    print(left_justified(str(Time[i])),left_justified(Lat[i]),left_justified(Long[i]))

Try this

Upvotes: 0

Related Questions