File size: 7,164 Bytes
f0de933 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 |
# 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!")
|