Input, Output, Features, and Parameters.
Required Input
1. Output File: One data file.
Supported input formats are .xlsm, .xls, xlsm, .csv, .tsv, and .json
2. Input Files: as many data files (dataframe) as you would like to process.
Supported input formats are .xlsm, .xls, xlsm, .csv, .tsv, and .json
Optional Input
3. Enter a Python statement, or multiple statements. Also a text file that contains a list of statements can be used as input.
4. When input file multiple sheets, you can select which sheet to be processed.
5. You can designate which row you can use as header (variable) for your processing.
6. You can specify a column to be used as the index of the dataframe.
7. You can specify which column(s) to be or not to be processed.
8. You can determine specific pandas datatypes for your column.
9. You can determine what character to use to separate your data (default is comma).
10. You can specify encoding technology of the input file (default is UTF-8).
11. You can select to either show or hide the index column in your output file.
How to set parameters
When handling multiple input data files, you must respect the input file sequence to set parameters for each one of the input files.
pandas-III plugin parameters are 100% compatible to pandas read_excel specifications
Please refer the parameters on the right in the pandas document above.
- Sheet Name →sheet_name
- Header Row →header
- Index Col →index_cols
- Use Col →usecols
- Data Type →dtypes
Text from Image
- AD LDAP
- Adv Send Email
- Arithmetic Op
- Attach Image
- AWS Textra Rekog
- Bot Collabo
- Chatwork Notification
- Clipboard
- Convert CharSet
- Convert Image
- Create Newfile
- Detect CharSet
- Drag and Drop
- Email IMAP ReadMon
- Email Read Mon
- Env Check
- Env Var
- Excel Advanced
- Excel AdvII
- Excel AdvIII
- Excel Copy Paste
- Excel Formula
- Excel Macro
- Excel Newfile
- Fairy Devices mimi AI
- File Conv
- File Folder Op
- File Status
- Folder Monitor
- Folder Structure
- Google Calendar
- Google Cloud Vision API
- Google Drive
- Google Sheets
- Google Token
- Google Translate
- Google TTS
- Html Extract
- IBM Speech to Text
- IBM Visual Recognition
- JSON Select
- LINE Notify
- MS Azure Text Analytics
- MS Word Extract
- NAVER OCR
- Newuser-SFDC
- PANDAS I
- pandas II
- pandas III
- PANDAS profiling
- Parsehub
- Password Generate
- PDF2Doc
- PDF Miner
- PDF SplitMerge
- PowerShell
- Print 2 Image
- QR Generate
- QR Read
- Regression
- REST API
- Rossum
- Scrapy Basic
- Screen Snipping
- Simple SFDC
- Slack
- Speed Test
- SQL
- SSH Command
- SSH Copy
- String Manipulation
- Telegram
- Tesseract
- Time Stamp
- Web Extract
- Work Calendar
- XML Extract
- Xtracta Get Doc
- Xtracta Tracking
- Xtracta Upload
- ZipUnzip