User contributions for Bacchas
Jump to navigation
Jump to search
- 21:04, 9 September 2020 diff hist +725 N Merge files based on ID, then do calculation Created page with "<pre> import pandas as pd import plotly.express as px ## pip install plotly excel_book1a = 'Purchases - Home A.xlsx' excel_prices = 'PriceBook.xlsx' df_prices = pd.read_excel..."
- 21:01, 9 September 2020 diff hist +156 Python Excel Related
- 15:54, 3 September 2020 diff hist +908 Conditional Search Multiple Excel Files current
- 15:52, 3 September 2020 diff hist +46 Python Excel Related →Conditional Search Multiple Excel Files
- 22:17, 2 September 2020 diff hist 0 N Category:Python Created blank page current
- 22:16, 2 September 2020 diff hist +487 N Combine multiple excel files into One Created page with "<pre> import glob import os import pandas as pd file = input('File Path: ') pth = os.path.dirname(file) extension = os.path.splitext(file)[1] print(pth) files = glob.glob(os.p..." current
- 22:15, 2 September 2020 diff hist +96 Python Excel Related
- 19:34, 2 September 2020 diff hist +1,697 How to Split an Excel File into multiple sheets or multiple files current
- 16:25, 2 September 2020 diff hist +46 Conditional Search Multiple Excel Files
- 16:25, 2 September 2020 diff hist +46 Merge Excel Spreadsheet with same columns current
- 16:25, 2 September 2020 diff hist +46 Clean up excel data current
- 16:24, 2 September 2020 diff hist −1 How to Split an Excel File into multiple sheets or multiple files
- 16:24, 2 September 2020 diff hist 0 How to Split an Excel File into multiple sheets or multiple files
- 16:23, 2 September 2020 diff hist +47 How to Split an Excel File into multiple sheets or multiple files
- 16:22, 2 September 2020 diff hist +81 N How to Split an Excel File into multiple sheets or multiple files Created page with "<pre> </pre> ==Back To Top - Category== Category:Python"
- 16:21, 2 September 2020 diff hist +146 Python Excel Related
- 22:22, 1 September 2020 diff hist +81 N Conditional Search Multiple Excel Files Created page with "<pre> </pre> ==Back To Top - Category== Category:Python"
- 18:19, 1 September 2020 diff hist −1 Python Excel Related →Conditional Search Multiple Excel Files
- 18:19, 1 September 2020 diff hist +172 Python Excel Related
- 16:25, 1 September 2020 diff hist +543 N Merge Excel Spreadsheet with same columns Created page with "=Merge two spreadsheets= '''Merge two or more spreets from different files with similar columns, but choose which columns you want to include in the merge''' <pre> import pan..."
- 16:22, 1 September 2020 diff hist +48 Python Excel Related
- 16:21, 1 September 2020 diff hist +20 Clean up excel data
- 16:21, 1 September 2020 diff hist +20 Coursera Google Python Automation Course →Back To Top - Category current
- 16:21, 1 September 2020 diff hist +20 Python Data Mining →Back To Top - Category current
- 16:20, 1 September 2020 diff hist +20 Python Web Scraping current
- 16:20, 1 September 2020 diff hist +20 Python Functions →Back To Top - Category current
- 16:20, 1 September 2020 diff hist +20 Python Problems and Solutions →Back To Top - Category current
- 16:20, 1 September 2020 diff hist +20 Control Flow, if statements etc.. →Back To Top - Category current
- 16:19, 1 September 2020 diff hist +20 Perform IO with Text Files →Back To Top - Category current
- 16:19, 1 September 2020 diff hist +20 Object and Data Structure Basics current
- 16:19, 1 September 2020 diff hist +21 Python Software installation
- 16:18, 1 September 2020 diff hist +47 Clean up excel data
- 19:39, 24 August 2020 diff hist +450 N Clean up excel data Created page with "<pre> import pandas as pd excel_file = 'docs/baddata.xlsx' df = pd.read_excel(excel_file) #print(df.head(2)) #test on one column #df['Name'] = df['Name'].str.replace(r'\W',""..."
- 19:38, 24 August 2020 diff hist +25 N Python Excel Related Created page with "=Clean up excel data="
- 19:37, 24 August 2020 diff hist +26 Python
- 20:19, 31 July 2020 diff hist +2 Bash →[Ubuntu File System Commands]
- 20:15, 31 July 2020 diff hist +37 Bash →File Commands
- 19:00, 31 July 2020 diff hist +203 N Text File Commands Created page with "== Search multiple files for text, then replace it in all returned files== find . -type f -name "*.html" -exec sed -i 's/thommack\*//g' {} + == Bash menu-Main_Page..."
- 18:56, 31 July 2020 diff hist +58 Bash
- 15:44, 31 July 2020 diff hist +149 File Commands
- 21:56, 28 July 2020 diff hist 0 Bash →File Commands
- 15:38, 24 July 2020 diff hist +2 Image Scripts →Bash menu- Home current
- 15:38, 24 July 2020 diff hist +43 Sample Scripts
- 15:37, 24 July 2020 diff hist +18 Centos OS current
- 15:36, 24 July 2020 diff hist +18 Image Scripts →Bash menu- Home
- 15:28, 24 July 2020 diff hist +320 File Commands →Find files x days old and delete them
- 15:28, 24 July 2020 diff hist −58 Sample Scripts →Find Directory sizes
- 15:27, 24 July 2020 diff hist −242 Sample Scripts →Find files over a certain size
- 15:27, 24 July 2020 diff hist +1,699 File Commands →Rename files adding the creation date as prefix
- 15:26, 24 July 2020 diff hist −1,468 Sample Scripts