Spaces:
Build error
Build error
| # How can I add row to an iterable dataset | |
| #π€Datasets | |
| #This is the first time xbilek25 has posted β letβs welcome them to our community! | |
| #xbilek25 | |
| #2 | |
| #9h | |
| #I need any working option to add row to a dataset, where streaming=True. While working with normal dataset I define new item and use code like this: | |
| #tmp_dataset = tmp_dataset.add_item(new_item), but i canβt figure out how to do this while my dataset is streaming=True. | |
| #Can anyone help me to find solution, please? | |
| if st.checkbox('Show Anatomy Table'): | |
| st.markdown(""" | |
| ## Anatomy Head to Toe Table with Body Organs Costly Conditions, Spending, CPT Codes and Frequency | |
| | Table Num | Body Part | Organ/Part | Description | π Costly Condition | π° Spending (billions) | CPT Range Start | CPT Range Finish | Frequency | | |
| |-----------|------------------|----------------------|-------------------------------|------------------------------|------------------------|-----------------|------------------|----------------| | |
| | 1 | π§ Head | π§ Brain | Controls mental processes | π¨ Anxiety & Depression | 210 | 90791 | 90899 | 1 in 5 | | |
| | 2 | π Eyes | ποΈ Optic Nerve | Vision | π Cataracts | 10.7 | 92002 | 92499 | 1 in 6 (over 40 years) | | |
| | 3 | π Ears | π Cochlea | Hearing | π’ Hearing Loss | 7.1 | 92502 | 92700 | 1 in 8 (over 12 years) | | |
| | 4 | π Nose | π Olfactory Bulb | Smell | π€§ Allergies | 25 | 31231 | 31294 | 1 in 3 | | |
| | 5 | π Mouth | π Tongue | Taste | π¦· Dental Issues | 130 | 00100 | 00192 | 1 in 2 | | |
| | 6 | π« Neck | π¦ Thyroid | Metabolism | π¦ Hypothyroidism | 3.1 | 60210 | 60271 | 1 in 20 | | |
| | 7 | πͺ Upper Body | β€οΈ Heart | Circulation | π Heart Disease | 230 | 92920 | 93799 | 1 in 4 (over 65 years) | | |
| | 8 | πͺ Upper Body | π« Lungs | Respiration | π· Chronic Obstructive Pulmonary Disease | 70 | 94002 | 94799 | 1 in 20 (over 45 years) | | |
| | 9 | πͺ Upper Body | π· Liver | Detoxification | πΊ Liver Disease | 40 | 47000 | 47999 | 1 in 10 | | |
| | 10 | πͺ Upper Body | πΉ Kidneys | Filtration | π Chronic Kidney Disease | 110 | 50010 | 50999 | 1 in 7 | | |
| | 11 | πͺ Upper Body | π Pancreas | Insulin secretion | π¬ Diabetes | 327 | 48100 | 48999 | 1 in 10 | | |
| | 12 | πͺ Upper Body | π½οΈ Stomach | Digestion | π₯ Gastroesophageal Reflux Disease | 17 | 43200 | 43289 | 1 in 5 | | |
| | 13 | πͺ Upper Body | π‘οΈ Spleen | Immune functions | π©Έ Anemia | 5.6 | 38100 | 38199 | 1 in 6 | | |
| | 14 | πͺ Upper Body | π« Blood Vessels | Circulation of blood | π Hypertension | 55 | 40110 | 40599 | 1 in 3 | | |
| | 15 | 𦡠Lower Body | π Colon | Absorption of water, minerals | π Colorectal Cancer | 14 | 45378 | 45378 | 1 in 23 | | |
| | 16 | 𦡠Lower Body | π½ Bladder | Urine excretion | π§ Urinary Incontinence | 8 | 51700 | 51798 | 1 in 4 (over 65 years) | | |
| | 17 | 𦡠Lower Body | π Reproductive Organs | Sex hormone secretion | ποΈ Endometriosis | 22 | 56405 | 58999 | 1 in 10 (women) | | |
| | 18 | π¦Ά Feet | π― Nerve endings | Balance and movement | π€ Peripheral Neuropathy | 19 | 95900 | 96004 | 1 in 30 | | |
| | 19 | π¦Ά Feet | π‘οΈ Skin | Temperature regulation | π Skin Cancer | 8.1 | 96910 | 96999 | 1 in 5 | | |
| | 20 | π¦Ά Feet | πͺ Muscles | Movement and strength | ποΈββοΈ Musculoskeletal Disorders | 176 | 97110 | 97799 | 1 in 2 | | |
| """) | |
| import streamlit as st | |
| import pandas as pd | |
| # Load dataset | |
| def load_data(): | |
| return pd.read_csv('anatomy_dataset.csv') | |
| # Save dataset | |
| def save_data(df): | |
| df.to_csv('anatomy_dataset.csv', index=False) | |
| # CRUD Operations | |
| def add_data(df): | |
| # Add a row to the dataframe (Example) | |
| # You can modify this function to take input from the user | |
| new_row = {'Table Num': 21, 'Body Part': 'New Part', 'Organ/Part': 'New Organ', 'Description': 'New Description', | |
| 'Costly Condition': 'New Condition', 'Spending (billions)': 0, 'CPT Range Start': 0, 'CPT Range Finish': 0, | |
| 'Frequency': 'New Frequency'} | |
| df = df.append(new_row, ignore_index=True) | |
| return df | |
| def update_data(df): | |
| # Update a row in the dataframe (Example) | |
| # Implement the update logic based on your requirements | |
| if not df.empty: | |
| df.at[0, 'Description'] = 'Updated Description' | |
| return df | |
| def delete_data(df): | |
| # Delete a row from the dataframe (Example) | |
| # Implement the delete logic based on your requirements | |
| if not df.empty: | |
| df = df.drop(df.index[0]) | |
| return df | |
| # Streamlit UI | |
| st.title("Anatomy Head to Toe CRUD Operations") | |
| # Display the table if checkbox is checked | |
| if st.checkbox('Show Anatomy Table'): | |
| df = load_data() | |
| st.markdown("## Anatomy Head to Toe Table with Body Organs Costly Conditions, Spending, CPT Codes and Frequency") | |
| st.dataframe(df) | |
| # CRUD operation buttons | |
| col1, col2, col3, col4 = st.columns(4) | |
| if col1.button('β Add'): | |
| df = load_data() | |
| df = add_data(df) | |
| save_data(df) | |
| if col2.button('π Update'): | |
| df = load_data() | |
| df = update_data(df) | |
| save_data(df) | |
| if col3.button('β Delete'): | |
| df = load_data() | |
| df = delete_data(df) | |
| save_data(df) | |
| if col4.button('πΎ Save'): | |
| df = load_data() | |
| save_data(df) | |
| st.success("Data saved to CSV!") | |