Spaces:
Sleeping
Sleeping
File size: 3,108 Bytes
c5a4946 31c84ff 750295a 31c84ff 750295a 31c84ff 750295a 31c84ff 750295a 31c84ff 750295a 31c84ff 750295a 31c84ff 5db6c8a 31c84ff 5db6c8a 31c84ff 133d765 a732bb1 31c84ff |
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 |
import streamlit as st
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import random
import requests
st.markdown("""
<style>
/* Set a soft background color */
body {
background-color: #eef2f7;
}
/* Style for main title */
h1 {
color: #00FFFF;
font-family: 'Roboto', sans-serif;
font-weight: 700;
text-align: center;
margin-bottom: 25px;
}
/* Style for headers */
h2 {
color: #FFFACD;
font-family: 'Roboto', sans-serif;
font-weight: 600;
margin-top: 30px;
}
/* Style for subheaders */
h3 {
color: #ba95b0;
font-family: 'Roboto', sans-serif;
font-weight: 500;
margin-top: 20px;
}
.custom-subheader {
color: #00FFFF;
font-family: 'Roboto', sans-serif;
font-weight: 600;
margin-bottom: 15px;
}
/* Paragraph styling */
p {
font-family: 'Georgia', serif;
line-height: 1.8;
color: #FFFFFF;
margin-bottom: 20px;
}
/* List styling with checkmark bullets */
.icon-bullet {
list-style-type: none;
padding-left: 20px;
}
.icon-bullet li {
font-family: 'Georgia', serif;
font-size: 1.1em;
margin-bottom: 10px;
color: #FFFFF0;
}
.icon-bullet li::before {
content: "✔️";
padding-right: 10px;
color: #b3b3ff;
}
/* Sidebar styling */
.sidebar .sidebar-content {
background-color: #ffffff;
border-radius: 10px;
padding: 15px;
}
.sidebar h2 {
color: #495057;
}
/* Custom button style */
.streamlit-button {
background-color: #00FFFF;
color: #000000;
font-weight: bold;
}
</style>
""", unsafe_allow_html=True)
st.title("📊 Handling Excel Files 📊")
st.markdown("Excel is a tool for organizing and analyzing data in a structured table format using rows and columns. It's commonly used for storing and analyzing datasets. 📈", unsafe_allow_html=True)
st.subheader("📂 How to read an Excel file?")
rcode = '''
df = pd.read_excel(r"/Users/rajbunny/Downloads/FSI-2023-DOWNLOAD.xlsx")
'''
st.code(rcode, language="python")
st.subheader("📑 How to read an Excel file with multiple sheets?")
mcode = '''
df = pd.read_excel(r"/Users/rajbunny/Downloads/Book3.xlsx", sheet_name=[0, 1, 2])
'''
st.code(mcode, language="python")
st.subheader("💾 How to save DataFrame back to Excel?")
scode = '''
with pd.ExcelWriter(r'/Users/rajbunny/Downloads/untitled_folder.xlsx', mode="x") as f2:
df[0].to_excel(f2, sheet_name='student_info')
df[1].to_excel(f2, sheet_name='sem1')
df[2].to_excel(f2, sheet_name='sem2')
'''
st.code(scode, language="python")
st.subheader("📝 To view the coding part of the Jupyter notebook:")
if st.button("🚀 Open Jupyter Notebook"):
notebook_url = "https://github.com/raj2216/my-code/blob/main/exel.ipynb"
st.markdown(f"[Click here to go to the Jupyter notebook] {notebook_url}", unsafe_allow_html=True)
|