Breaking News: Grepper is joining You.com. Read the official announcement!

dynamic data uploader (xlsx, csv, pdf)

Tame Tarantula answered on September 12, 2023 Popularity 1/10 Helpfulness 1/10

answer dynamic data uploader (xlsx, csv, pdf)

dynamic data uploader (xlsx, csv, pdf)

Comment

import os
import streamlit as st
import pandas as pd
from tabula import read_pdf

def load_data(file):
    file_extension = os.path.splitext(file.name)[1].lower()
    if file_extension == ".csv":
        return pd.read_csv(file)
    elif file_extension in [".xlsx", ".xls"]:
        return pd.read_excel(file)
    elif file_extension == ".pdf":
        # Using tabula to read tables from PDF
        dfs = read_pdf(file, pages='all', multiple_tables=True)
        if dfs:
            # If there's only one table, return it
            if len(dfs) == 1:
                return dfs[0]
            # If there are multiple tables, ask the user which one(s) they want
            else:
                options = [f"Table {i}" for i in range(1, len(dfs) + 1)] + ["All"]
                selected_option = st.selectbox(
                    "Multiple tables detected. Please select the table you want to load:",
                    options=options
                )
                
                if selected_option == "All":
                    # Concatenate all tables vertically
                    return pd.concat(dfs, ignore_index=True)
                else:
                    table_index = options.index(selected_option)
                    return dfs[table_index]
        else:
            st.error("No tables found in PDF!")
            return None
    else:
        st.error("Unsupported file format!")
        return None

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: dynamic-data python uploader

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

Tame Tarantula

0 Answers Avg Quality 2/10

dynamic data uploader (xlsx, csv, pdf)

Contents

More Related Answers

dynamic data uploader (xlsx, csv, pdf)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.