excel-to-python-course
Student materials and handouts for Excel to Python course
파일 탐색기
최종 버전 다운로드 (.zip)- .keep
- .keep
- .keep
- 1-Data_Prep.ipynb
- cookiecutter.json
- sample_sales.xlsx
- sample_sales.xlsx
- sample_sales_sku.xlsx
- 1-Data-Exploration.ipynb
- Sales-Analysis-Exploration.ipynb
- sample_sales_details.xlsx
- sample_sales_details.xlsx
- 1-Accessor-Demo.ipynb
- 1-Boolean-Filter-Exercise.ipynb
- customer_levels.xlsx
- sample_sales.xlsx
- sample_sales_50_extra.xlsx
- sample_sales_updated.xlsx
- customer_levels.xlsx
- sample_sales.xlsx
- sample_sales_50_extra.xlsx
- sample_sales_excel_formulas.xlsx
- sample_sales_excel_formulas_orig.xlsx
- sample_sales_vlookup.xlsx
- 1-Aggregating-Grouping-Example.ipynb
- 1-Data-Prep-Add-Customer_Levels.ipynb
- 2019_customer_transactions.csv
- excel_complicated_document.xlsx
- TPS_report.xlsx
- 1-read-data-example-exercise.ipynb
- 2-write-excel-exercise.ipynb
- 3-large-file-reading.ipynb
- customer_rep_data.xlsx
- customer_master.xlsx
- invoice_data.xlsx
- commission_report.xlsx
- 1-Data-Prep-Customer.ipynb
- 2-Data-Prep-Customer-Sales.ipynb
- 3-Analysis-Model.ipynb
- requirements.in
- requirements.txt
- excel-to-python.png
- Afghanistan.csv
- Albania.csv
- Algeria.csv
- Andorra.csv
- Antigua and Barbuda.csv
- Argentina.csv
- Armenia.csv
- Aruba.csv
- Australia.csv
- Austria.csv
- Azerbaijan.csv
- Bahrain.csv
- Bangladesh.csv
- Barbados.csv
- Belarus.csv
- Belgium.csv
- Benin.csv
- Bhutan.csv
- Bolivia.csv
- Bosnia and Herzegovina.csv
- Brazil.csv
- Brunei.csv
- Bulgaria.csv
- Burkina Faso.csv
- Cambodia.csv
- Canada.csv
- Central African Republic.csv
- Chile.csv
- China.csv
- Colombia.csv
- Congo (Brazzaville).csv
- Congo (Kinshasa).csv
- Costa Rica.csv
- Cote d'Ivoire.csv
- Croatia.csv
- Cruise Ship.csv
- Cuba.csv
- Cyprus.csv
- Denmark.csv
- Djibouti.csv
- Dominican Republic.csv
- Ecuador.csv
- Egypt.csv
- Equatorial Guinea.csv
- Estonia.csv
- Eswatini.csv
- Ethiopia.csv
- Finland.csv
- France.csv
- French Guiana.csv
- Gabon.csv
- Gambia, The.csv
- Georgia.csv
- Germany.csv
- Ghana.csv
- Greece.csv
- Greenland.csv
- Guadeloupe.csv
- Guam.csv
- Guatemala.csv
- Guernsey.csv
- Guinea.csv
- Guyana.csv
- Holy See.csv
- Honduras.csv
- Hungary.csv
- Iceland.csv
- India.csv
- Indonesia.csv
- Iran.csv
- Iraq.csv
- Ireland.csv
- Israel.csv
- Italy.csv
- Jamaica.csv
- Japan.csv
- Jersey.csv
- Jordan.csv
- Kazakhstan.csv
- Kenya.csv
- Korea, South.csv
- Kuwait.csv
- Kyrgyzstan.csv
- Latvia.csv
- Lebanon.csv
- Liberia.csv
- Liechtenstein.csv
- Lithuania.csv
- Luxembourg.csv
- Malaysia.csv
- Maldives.csv
- Malta.csv
- Martinique.csv
- Mauritania.csv
- Mauritius.csv
- Mayotte.csv
- Mexico.csv
- Moldova.csv
- Monaco.csv
- Mongolia.csv
- Montenegro.csv
- Morocco.csv
- Namibia.csv
- Nepal.csv
- Netherlands.csv
- New Zealand.csv
- Nigeria.csv
- North Macedonia.csv
- Norway.csv
- Oman.csv
- Pakistan.csv
- Panama.csv
- Paraguay.csv
- Peru.csv
- Philippines.csv
- Poland.csv
- Portugal.csv
- Puerto Rico.csv
- Qatar.csv
- Republic of the Congo.csv
- Reunion.csv
- Romania.csv
- Russia.csv
- Rwanda.csv
- Saint Lucia.csv
- Saint Vincent and the Grenadines.csv
- San Marino.csv
- Saudi Arabia.csv
- Senegal.csv
- Serbia.csv
- Seychelles.csv
- Singapore.csv
- Slovakia.csv
- Slovenia.csv
- Somalia.csv
- South Africa.csv
- Spain.csv
- Sri Lanka.csv
- Sudan.csv
- Suriname.csv
- Sweden.csv
- Switzerland.csv
- Taiwan.csv
- Tanzania.csv
- Thailand.csv
- The Bahamas.csv
- The Gambia.csv
- Togo.csv
- Trinidad and Tobago.csv
- Tunisia.csv
- Turkey.csv
- Ukraine.csv
- United Arab Emirates.csv
- United Kingdom.csv
- Uruguay.csv
- US.csv
- Uzbekistan.csv
- Venezuela.csv
- Vietnam.csv
- Zambia.csv
- 2019_Sales_Total_Tabs.xlsx
- shipping_tables.xlsx
- shipping_tables_v2.xlsx
- text-field-examples.xlsx
- weather_summary_09_29_2020.xlsx
- 01-Large-File-Read.ipynb
- 02-Multi-Tab-Combine.ipynb
- 03-read-html-table.ipynb
- 04-table-lookup.ipynb
- 05-vlookup-1.ipynb
- 06-vlookup-2.ipynb
- 07-working-with-text.ipynb
- 08-loc-filters.ipynb
- 09-clipboard.ipynb
- 10-multi-file-read.ipynb
- .gitignore
- LICENSE
- README.md
# 설치 가이드
1. 코드 내려받기
git clone https://github.com/talkpython/excel-to-python-course
깃허브에서 프로젝트 코드 전체를 내 컴퓨터로 내려받습니다.
cd excel-to-python-course
방금 내려받은 프로젝트 폴더 안으로 이동합니다.
2. Python
쉬움 추천사전 준비물
pip install -r code/requirements.txt
requirements.txt 등에 명시된 파이썬 라이브러리를 설치합니다.
jupyter notebook
브라우저에서 노트북(.ipynb) 파일들을 열람하고 실행할 수 있는 Jupyter 화면을 켭니다.
에러 메시지 없이 실행되고 터미널에 안내 문구가 출력되면 정상입니다.
// repository documentation
Was this content helpful?
(0 ratings)