"함수 array count value()"의 두 판 사이의 차이

잔글 (봇: 자동으로 텍스트 교체 (-source +syntaxhighlight))
7번째 줄: 7번째 줄:


==POSIX Shell==
==POSIX Shell==
<source lang='bash'>
<syntaxhighlight lang='bash'>
FRUITS="Banana Orange Apple Orange Orange "
FRUITS="Banana Orange Apple Orange Orange "
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange'
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange'
# 3
# 3
</source>
</syntaxhighlight>


==PHP==
==PHP==
[[category: PHP]]
[[category: PHP]]
{{참고|PHP array_count_value()}}
{{참고|PHP array_count_value()}}
<source lang='PHP'>
<syntaxhighlight lang='PHP'>
function array_count_value($arr, $val) {
function array_count_value($arr, $val) {
return count(array_filter($arr, function($v) use($val) {return $v==$val;}));
return count(array_filter($arr, function($v) use($val) {return $v==$val;}));
23번째 줄: 23번째 줄:
echo array_count_value($fruits, 'Orange');
echo array_count_value($fruits, 'Orange');
# 3
# 3
</source>
</syntaxhighlight>
<source lang='PHP'>
<syntaxhighlight lang='PHP'>
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
$acvs = array_count_values($fruits);
$acvs = array_count_values($fruits);
echo $acvs['Orange'];
echo $acvs['Orange'];
# 3
# 3
</source>
</syntaxhighlight>


==Python==
==Python==
[[category: Python]]
[[category: Python]]
{{참고|Python count()}}
{{참고|Python count()}}
<source lang='Python'>
<syntaxhighlight lang='Python'>
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']
print( fruits.count('Orange') )
print( fruits.count('Orange') )
# 3
# 3
</source>
</syntaxhighlight>


==Perl==
==Perl==
[[category:Perl]]
[[category:Perl]]
<source lang='perl'>
<syntaxhighlight lang='perl'>
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
print $k = grep { $_ eq 'Orange'  } @fruits;
print $k = grep { $_ eq 'Orange'  } @fruits;
# 3
# 3
</source>
</syntaxhighlight>


==SQL==
==SQL==
52번째 줄: 52번째 줄:
===MySQL===
===MySQL===
[[category: MySQL]]
[[category: MySQL]]
<source lang='console'>
<syntaxhighlight lang='console'>
mysql> SELECT * FROM fruits;
mysql> SELECT * FROM fruits;
+--------+
+--------+
64번째 줄: 64번째 줄:
+--------+
+--------+
5 rows in set (0.00 sec)
5 rows in set (0.00 sec)
</source>
</syntaxhighlight>
<source lang='console'>
<syntaxhighlight lang='console'>
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange';
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange';
+----------+
+----------+
73번째 줄: 73번째 줄:
+----------+
+----------+
1 row in set (0.00 sec)
1 row in set (0.00 sec)
</source>
</syntaxhighlight>


==같이 보기==
==같이 보기==
*[[array_count_values()]]
*[[array_count_values()]]
*[[array length]]
*[[array length]]

2020년 11월 2일 (월) 02:32 판

  다른 뜻에 대해서는 array length 문서를 참조하십시오.
  다른 뜻에 대해서는 PHP count() 문서를 참조하십시오.
count()
array_count_value()

1 POSIX Shell

Bash
Copy
FRUITS="Banana Orange Apple Orange Orange "
echo $FRUITS | tr ' ' '\n' | grep -c 'Orange'
# 3

2 PHP

PHP
Copy
function array_count_value($arr, $val) {
	return count(array_filter($arr, function($v) use($val) {return $v==$val;}));
}
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
echo array_count_value($fruits, 'Orange');
# 3
PHP
Copy
$fruits = array('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
$acvs = array_count_values($fruits);
echo $acvs['Orange'];
# 3

3 Python

Python
Copy
fruits = ['Banana', 'Orange', 'Apple', 'Orange', 'Orange']
print( fruits.count('Orange') )
# 3

4 Perl

Perl
Copy
my @fruits = ('Banana', 'Orange', 'Apple', 'Orange', 'Orange');
print $k = grep { $_ eq 'Orange'  } @fruits;
# 3

5 SQL

5.1 MySQL

Console
Copy
mysql> SELECT * FROM fruits;
+--------+
| value  |
+--------+
| Banana |
| Orange |
| Apple  |
| Orange |
| Orange |
+--------+
5 rows in set (0.00 sec)
Console
Copy
mysql> SELECT COUNT(*) FROM fruits WHERE value='Orange';
+----------+
| COUNT(*) |
+----------+
|        3 |
+----------+
1 row in set (0.00 sec)

6 같이 보기