/TypeScript/How to get the table contents from a file in python

How to get the table contents from a file in python

import requests
import pandas as pd

txt_data = requests.get('https://downloads.usda.library.cornell.edu/usda-esmis/files/c821gj76b/n870zs10r/h989r4519/AgriPric-03-30-2017.txt').text
splited_data = txt_data.split('\n')

table_title = 'Prices Received for Field Crops and Fruits - United States: February 2017 with Comparisons'
END_TABLE_LINE = '-------------------------------------------'


def find_no_line_start_table(table_title,splited_data):
    found_no_lines = []
    for index, line in enumerate(splited_data):
        if table_title in line:
            found_no_lines.append(index)

    return found_no_lines

_, table_start = find_no_line_start_table(table_title,splited_data)


def get_start_data_table(table_start, splited_data):
    for index, row in enumerate(splited_data[table_start:]):
        if '(D)' in row:
            return table_start + index

def get_end_table(start_table_data, splited_data ):
    for index, row in enumerate(splited_data[start_table_data:]):
            if END_TABLE_LINE in row:
                return start_table_data + index

def row(l):
    l = l.split()
    number_columns = 5
    if len(l) >= number_columns: 
        data_row = [''] * number_columns
        first_column_done = False

        index = 0
        for w in l:
            if not first_column_done:
                data_row[0] = ' '.join([data_row[0], w])
                if ':' in w:
                        first_column_done = True
            else:
                index += 1
                data_row[index] = w

        return data_row

start_line = get_start_data_table(table_start, splited_data)
end_line = get_end_table(start_line, splited_data)

table = splited_data[start_line : end_line]

def take_table(txt_data):
    comodity = []
    price_2011 = []
    feb_2016 = []
    jan_2017 = []
    feb_2017 = []

    for r in table:
        data_row = row(r)
        if data_row:
            col_1, col_2, col_3, col_4, col_5 = data_row
            comodity.append(col_1)
            price_2011.append(col_2)
            feb_2016.append(col_3)
            jan_2017.append(col_4)
            feb_2017.append(col_5)

    table_data = {'comodity': comodity, 'price_2011': price_2011,
                  'feb_2016': feb_2016, 'jan_2017': jan_2017, 'feb_2017': feb_2017}
    return table_data

dict_table = take_table(txt_data)
pd.DataFrame(dict_table)

Source: stackoverflow.com

Similar codes

0 vote176 views2 answers
Check if breckets clossing properly
TypeScript
0 vote120 views1 answer
InsertSheet() at the beginning of active sheets google script
TypeScript
6 votes117 views3 answers
Property "'element'" does not exist on type 'htmlelement'.ts(2339)
TypeScript
2 votes149 views2 answers
How to close all ports angular
TypeScript
0 vote135 views1 answer
Nestjs get request header in guard
TypeScript
0 vote122 views2 answers
Moonspell (@moonspellofficial) • Instagram photos and videoswww.instagram.com › moonspellofficial 61.4k Followers, 619 Following, 2421 Posts - See Instagram photos and videos from Moonspell (@moonspellofficial)
TypeScript
0 vote124 views1 answer
Google sheets add all numbers in a column with condition
TypeScript
1 vote132 views1 answer
No directive found with exportAs 'matAutocomplete'
TypeScript
0 vote123 views1 answer
How can I create an array with a range of decimal increments in SwiftUI ?
TypeScript
0 vote135 views1 answer
Error on indexing the object in ts
TypeScript