'잡동사니'에 해당되는 글 13812건
- 2025.07.14 호빵 맛집
- 2025.07.13 올리브 풀빌라
- 2025.07.12 가구 레일 교체
- 2025.07.11 csvtool
- 2025.07.10 더운데 덥지 아니하다?
- 2025.07.09 절래절래
- 2025.07.09 송파 스피어
- 2025.07.08 risc-v sbc
- 2025.07.08 esp32 계열 정리
- 2025.07.07 어우 더워. 습해!!!
개소리 왈왈/육아관련 주저리2025. 7. 14. 19:13
개소리 왈왈/육아관련 주저리2025. 7. 13. 18:25
개소리 왈왈/육아관련 주저리2025. 7. 12. 21:42
내 속옷 넣는 서랍장이랑
애들 속옷 넣는 서랍장이 무너져서
어찌 맞겠지 생각에 좀더 폭이 넓은걸로 해서 구매하고
오늘 배송받아 드라이버로 한땀한땀 교체!
아내도 나도 만족!
만원에 레일 3개에 배송비 들인거 치고는 꽤 만족스럽다.
[링크 : http://itempage3.auction.co.kr/DetailView.aspx?ItemNo=C337662970&frm3=V2]
'개소리 왈왈 > 육아관련 주저리' 카테고리의 다른 글
| 호빵 맛집 (0) | 2025.07.14 |
|---|---|
| 올리브 풀빌라 (0) | 2025.07.13 |
| 더운데 덥지 아니하다? (0) | 2025.07.10 |
| 송파 스피어 (0) | 2025.07.09 |
| 어우 더워. 습해!!! (0) | 2025.07.07 |
Linux/Ubuntu2025. 7. 11. 18:05
awk로 쇼할 바에는 이게 최고구만
[링크 https://packages.debian.org/search?keywords=csvtool]
+
2025.07.31
csv 파일에서 특정 셀을 뽑아내서 합계를 구하려는데
mlr과 csvtool을 gpt가 추천해줘서 찾아보게 됨
| NAME csvtool - tool for performing manipulations on CSV files from shell scripts SYNOPSIS csvtool [options] command [command-args] input.csv... |
| $ csvtool --help csvtool - Copyright (C) 2005-2006 Richard W.M. Jones, Merjis Ltd. - Copyright (C) 2007- Richard W.M. Jones & Christophe Troestler csvtool is a tool for performing manipulations on CSV files from shell scripts. Summary: csvtool [-options] command [command-args] input.csv [input2.csv [...]] Commands: col <column-spec> Return one or more columns from the CSV file. For <column-spec>, see below. Example: csvtool col 1-3,6 input.csv > output.csv namedcol <names> Assuming the first row of the CSV file is a list of column headings, this returned the column(s) with the named headings. <names> is a comma-separated list of names. Example: csvtool namedcol Account,Cost input.csv > output.csv width Print the maximum width of the CSV file (number of columns in the widest row). height Print the number of rows in the CSV file. For most CSV files this is equivalent to 'wc -l', but note that some CSV files can contain a row which breaks over two (or more) lines. setcolumns cols Set the number of columns to cols (this also makes the CSV file square). Any short rows are padding with blank cells. Any long rows are truncated. setrows rows 'setrows n' sets the number of rows to 'n'. If there are fewer than 'n' rows in the CSV files, then empty blank lines are added. head rows take rows 'head n' and 'take n' (which are synonyms) take the first 'n' rows. If there are fewer than 'n' rows, padding is not added. drop rows Drop the first 'rows' rows and return the rest (if any). Example: To remove the headings from a CSV file with headings: csvtool drop 1 input.csv > output.csv To extract rows 11 through 20 from a file: csvtool drop 10 input.csv | csvtool take 10 - > output.csv cat This concatenates the input files together and writes them to the output. You can use this to change the separator character. Example: csvtool -t TAB -u COMMA cat input.tsv > output.csv paste Concatenate the columns of the files together and write them to the output. Example: csvtool paste input1.csv input2.csv > output.csv pastecol <column-spec1> <column-spec2> input.csv update.csv Replace the content of the columns referenced by <column-spec1> in the file input.csv with the one of the corresponding column specified by <column-spec2> in update.csv. Example: csvtool pastecol 2-3 1- input.csv update.csv.csv > output.csv join <column-spec1> <column-spec2> Join (collate) multiple CSV files together. <column-spec1> controls which columns are compared. <column-spec2> controls which columns are copied into the new file. Example: csvtool join 1 2 coll1.csv coll2.csv > output.csv In the above example, if coll1.csv contains: Computers,$40 Software,$100 and coll2.csv contains: Computers,$50 then the output will be: Computers,$40,$50 Software,$100, square Make the CSV square, so all rows have the same length. Example: csvtool square input.csv > input-square.csv trim [tlrb]+ Trim empty cells at the top/left/right/bottom of the CSV file. Example: csvtool trim t input.csv # trims empty rows at the top only csvtool trim tb input.csv # trims empty rows at the top & bottom csvtool trim lr input.csv # trims empty columns at left & right csvtool trim tlrb input.csv # trims empty rows/columns all around sub r c rows cols Take a square subset of the CSV, top left at row r, column c, which is rows deep and cols wide. 'r' and 'c' count from 1, or from 0 if -z option is given. replace <column-spec> update.csv original.csv Replace rows in original.csv with rows from update.csv. The columns in <column-spec> only are used to compare rows in input.csv and update.csv to see if they are candidates for replacement. Example: csvtool replace 3 updates.csv original.csv > new.csv mv new.csv original.csv transpose input.csv Transpose the lines and columns of the CSV file. format fmt Print each row of the files according to the format 'fmt'. Each occurrence of "%i" or "%(i)" (where 'i' is a number) in 'fmt' is replaced by the content of column number 'i' (remember that the leftmost column is numbered 1 in the traditional spreadsheet fashion). A literal percent is obtained by doubling it. The usual escape sequences \n, \r, and \t are recognized. Example: csvtool format '%(1) -> %8%%\n' input.csv call command This calls the external command (or shell function) 'command' followed by a parameter for each column in the CSV file. The external command is called once for each row in the CSV file. If any command returns a non-zero exit code then the whole program terminates. Tip: Use the shell command 'export -f funcname' to export a shell function for use as a command. Within the function, use the positional parameters $1, $2, ... to refer to the columns. Example (with a shell function): function test { echo Column 1: $1 echo Column 2: $2 } export -f test csvtool call test my.csv In the above example, if my.csv contains: how,now brown,cow then the output is: Column 1: how Column 2: now Column 1: brown Column 2: cow readable Print the input CSV in a readable format. Column specs: A <column-spec> is a comma-separated list of column numbers or column ranges. Examples: 1 Column 1 (the first, leftmost column) 2,5,7 Columns 2, 5 and 7 1-3,5 Columns 1, 2, 3 and 5 1,5- Columns 1, 5 and up. Columns are numbered starting from 1 unless the -z option is given. Input files: csvtool takes a list of input file(s) from the command line. If an input filename is '-' then take input from stdin. Output file: Normally the output is written to stdout. Use the -o option to override this. Separators: The default separator character is , (comma). To change this on input or output see the -t and -u options respectively. Use -t TAB or -u TAB (literally T-A-B!) to specify tab-separated files. Options: -t Input separator char. Use -t TAB for tab separated input. -u Output separator char. Use -u TAB for tab separated output. -o Write output to file (instead of stdout) -z Number columns from 0 instead of 1 -help Display this list of options --help Display this list of options |
'Linux > Ubuntu' 카테고리의 다른 글
| 기본 터미널 변경하기 (0) | 2025.09.22 |
|---|---|
| intel dri 3? (0) | 2025.08.12 |
| ubuntu dhcp lease log (0) | 2025.07.01 |
| 우분투에서 스타크래프트 시도.. 실패 (0) | 2025.06.28 |
| netplan (0) | 2025.03.06 |
개소리 왈왈/육아관련 주저리2025. 7. 10. 22:56
개소리 왈왈/직딩의 비애2025. 7. 9. 22:51
근 2년 만에 스타를 했더니
점심시간 내내 졌다 ㅋㅋㅋㅋ
'개소리 왈왈 > 직딩의 비애' 카테고리의 다른 글
| 압박붕대 (2) | 2025.08.25 |
|---|---|
| 어우 피곤 (0) | 2025.08.05 |
| 난 멀하고 싶은걸까? (1) | 2025.06.27 |
| 이번달 k-pass 환급액은 적겠군.. (0) | 2025.06.26 |
| 외근 (0) | 2025.06.17 |
개소리 왈왈/육아관련 주저리2025. 7. 9. 16:44
회사가 의왕시인데 40도.. 크헉 어쩐지 덥더라
그게 중요한게 아니라 기사를 보다보니 희한한게 있어서 찾아보게 되었는데 송파 석촌호수에 있다고
[링크 : https://www.hani.co.kr/arti/society/environment/1206906.html]
[링크 : https://songpa.newstool.co.kr/view.php?eid=8934&aid=15904]
'개소리 왈왈 > 육아관련 주저리' 카테고리의 다른 글
| 가구 레일 교체 (0) | 2025.07.12 |
|---|---|
| 더운데 덥지 아니하다? (0) | 2025.07.10 |
| 어우 더워. 습해!!! (0) | 2025.07.07 |
| 또 피곤 (0) | 2025.07.06 |
| 피곤 (0) | 2025.07.05 |
embeded/risc-v2025. 7. 8. 11:56
ubuntu canonical 그룹에서 지원한다고 하지만,
13.6만원대에 라즈베리 3B 성능이라...
[링크 : https://www.starfivetech.com/en/site/boards]
[링크 : https://www.jeffgeerling.com/blog/2023/risc-v-business-testing-starfives-visionfive-2-sbc]
'embeded > risc-v' 카테고리의 다른 글
| risc-v sv39 (0) | 2023.11.18 |
|---|---|
| milk-v duo(risc-v) (0) | 2023.11.18 |
| 부품 도착! + 주문 취소! (0) | 2023.11.02 |
| 오늘의 지름 (0) | 2023.11.01 |
| risc-v 저가보드 / sipeed maix amigo (0) | 2023.11.01 |
embeded/esp322025. 7. 8. 11:07
ESP32 / ESP32-S 만 xtensa 계열이고, 나머지는 RISC-V 계열이다.
특이하게 C5/C6/C61 에서는 802.11ax 까지 지원하고, C5만 802.11ac를 지원한다.
| ESP32-P4 | ESP32-S3 | ESP32-S2 | ESP32-C5 | ESP32-C6 | ESP32-C61 | ESP32-C3 | ESP32-C2 | ESP32-H4 | ESP32-H2 | ESP32 | |
| wifi | bgn | bgn | bgn/ac/ax | bgn/ax | bgn/ax | bgn | bgn | bgn | |||
| BLE | 5.0 | 5.3 | 5.3 | 5.0 | 5.0 | 5.0 | 5.4 | 5.0 | 4.2/classic | ||
| arch | RISC-V | Xtensa | Xtensa | RISC-V | RISC-V | RISC-V | RISC-V | RISC-V | RISC-V | RISC-V | Xtensa |
| core | dual | dual | single | single | single | single | single | single | Dual | Single | Single/Dual |
| clock(MHZ) | 400 | 240 | 240 | 240 | 160 | 160 | 160 | 120 | 96 | 96 | 240 |
[링크 https://products.espressif.com/static/Espressif%20SoC%20Product%20Portfolio.pdf]
'embeded > esp32' 카테고리의 다른 글
| esp32 benchmark (0) | 2025.11.18 |
|---|---|
| esp32 lvgl (0) | 2025.11.15 |
| esp32devkitc v4 (0) | 2025.01.06 |
| esp32cam sdio wifi (0) | 2024.09.11 |
| esp32 wifi/bt on linux (0) | 2024.08.13 |
개소리 왈왈/육아관련 주저리2025. 7. 7. 23:04
