l******9
发帖数: 579 | 1 【 以下文字转载自 Statistics 讨论区 】
发信人: light009 (light009), 信区: Statistics
标 题: count unique values in file with 1 million rows
发信站: BBS 未名空间站 (Sat Apr 12 16:11:22 2014, 美东)
I need to count the unique values in one column in EXCEL 2010.
The worksheet has 1 million rows and 10 columns. All cell values are string
or numbers.
I used the solution at Count unique values in a column in Excel
=SUMPRODUCT((A2:A1000000<>"")/COUNTIF(A2:A100000,A2:A1000000&""))
But, it runs so long time that the EXCEL is almost ... 阅读全帖 |
|
b**********5
发帖数: 7881 | 2 最基本的word count， 大家都知道怎么写
但如果现在是一个text document， 不但要word count， 还要output那个word的
sentence number， 我应该怎么写？
比如：
a ab c d e. ab d. e
output:
a : {1, 1} (count is 1, and appeared in the first sentence)
ab: {2, 1, 2} {count is 2, and appeared in the first/second sentence)
... |
|
h******n
发帖数: 2795 | 3 如果购买日期较近，譬如说小于一个月，可以通过交易平台交涉。
直接提供你获得的shutter counts数据。
比较关键的一点：该相机在出售的时候，卖家有没有著名shutter counts数，如果没有
注明，那么你也无法以shutter counts偏高交涉。如果已经注明，那么你可以以收到的
实物与商品描述不符，提出退货或退款诉求。通过Amazon和Ebay（paypal），可以容易
获得赔偿，但其他平台则说不清。
你这种情况，很大的可能性是卖家使用软件刷了shutter counts。你可以很容易百度或
Google到这款软件。 |
|
C******l
发帖数: 859 | 4 谢谢，我先给卖家联系一下
如果购买日期较近，譬如说小于一个月，可以通过交易平台交涉。
直接提供你获得的shutter counts数据。
比较关键的一点：该相机在出售的时候，卖家有没有著名shutter counts数，如果没有
注明，那么你也无法以shutter counts偏高交涉。如果已经注明，那么你可以以收到的
实物与商品描述不符，提出退货或退款诉求。通过Amazon和Ebay（paypal），可以容易
获得赔偿，但其他平台则说不清。
你这种情况，很大的可能性是卖家使用软件刷了shutter counts。你可以很容易百度或
Google到这款软件。 |
|
A*******t
发帖数: 40 | 5 有两个表，一个是Inventory，一个是SaleHistory，靠SKU可join在一起。
Inventory
-------------------
SKU Stock DateIn
SC101 1 2010/03/10
SC101 1 2010/04/20
SC102 1 2011/02/03
...
...
SaleHistory
--------------------
SKU SONum DateSold
SC101 00201 2010/08/19
SC102 00202 2010/08/20
SC102 00203 2010/08/21
...
...
现需要这样一个Report来展示库存>10的所有SKU的销售情况
SKU UnitsLeft UnitsSold
SC101 2 1
SC102 1 2
...
虚心请教如何用SQL实现... 如果只有一个表一个Count就出来了。但是两个表joint在
一起，如果用下列Query，结果总是不对头：
SELE... 阅读全帖 |
|
l******9
发帖数: 579 | 6 【 以下文字转载自 Statistics 讨论区 】
发信人: light009 (light009), 信区: Statistics
标 题: count unique values in file with 1 million rows
发信站: BBS 未名空间站 (Sat Apr 12 16:11:22 2014, 美东)
I need to count the unique values in one column in EXCEL 2010.
The worksheet has 1 million rows and 10 columns. All cell values are string
or numbers.
I used the solution at Count unique values in a column in Excel
=SUMPRODUCT((A2:A1000000<>"")/COUNTIF(A2:A100000,A2:A1000000&""))
But, it runs so long time that the EXCEL is almost ... 阅读全帖 |
|
l******9
发帖数: 579 | 7 【 以下文字转载自 Statistics 讨论区 】
发信人: light009 (light009), 信区: Statistics
标 题: count unique values in file with 1 million rows
发信站: BBS 未名空间站 (Sat Apr 12 16:11:22 2014, 美东)
I need to count the unique values in one column in EXCEL 2010.
The worksheet has 1 million rows and 10 columns. All cell values are string
or numbers.
I used the solution at Count unique values in a column in Excel
=SUMPRODUCT((A2:A1000000<>"")/COUNTIF(A2:A100000,A2:A1000000&""))
But, it runs so long time that the EXCEL is almost ... 阅读全帖 |
|
h**h
发帖数: 488 | 8 其实我想要的是这样的，count以后会出现这样的结果，
ID Code Count
01 111 4
01 112 3
01 113 2
01 114 1
02 112 4
02 111 3
02 114 2
02 113 1
每个ID之想保留count前2名的，就是选成。
ID Code Count
01 111 4
01 112 3
02 112 4
02 111 3
因为有的ID拥有的code非常多，不想全保留。 |
|
w*******r
发帖数: 349 | 9 都给出non dup observation 的count
试验了一下，这个count （unique）好像更快，但是网上没有任何文章
不知道哪位了解这个 count （unique）
另外，最快得出non-dup index 的observation 是什么方法？？
多谢 |
|
w*******y
发帖数: 60932 | 10 Puffs Ultra Soft and Strong Facial Tissues 336-Count 4 Pack $7.64 free
shipping from Amazon
The deal on this one is YMMV. The listing calls for 336 count 4 Pack. If you
enlarge the Picture it shows a total of 6 Boxes totaling 336 Tissues. The
listing states 4 Pack, 336 Count . So hence YMMV, you may somehow get a
total of 4 boxes = 336 ( Not sure they even make them in that size? ) or 24
boxes of 56 tissues
Link:
http://www.amazon.com/Puffs-Strong-Facial-Tissues-336-Count/dp/B003YZOEO6/ref=pd_ec... 阅读全帖 |
|
|
|
|
w*******y
发帖数: 60932 | 14 Luxury Collection 600-Thread Count Damask Sheet Set::
http://www.kohls.com/kohlsStore/bedandbath/sheets/luxury/PRD~c9727/Luxury Collection 600Thread Count Damask Sheet Set.jsp
original $59.99-179.99
sale $29.99-$44.99
Use coupon NEXTORDER20 & FREECCDEC for 20% off and free shipping
respectively.
You'll sleep soundly using this Luxury Collection sheet set. The damask
striped pattern will match a variety of comforters and other bedding
coordinates. Count on quality when you use this bed sheet set.... 阅读全帖 |
|
|
|
|
|
|
w*******y
发帖数: 60932 | 20 184 Count - Swaddlers Dry Max Diapers, Size 2:
http://www.amazon.com/Pampers-Swaddlers-Diapers-Size-Count/dp/B
You will have to select your size and count to put the right item in your
cart.
Use Amazon Mom Discount with Sub & Save (30% off)
Use 20% off Coupon code Found in "Parenting Magazine pg. 81 of the Dec. 2010
issue"
OR
Use $10 off Amazon Baby Coupon code found in the "Parenting Early Years -
February 2011" issue
Use 2 - $1.50 Coupons found on Coupon Page (Keep refreshing coupon page
u... 阅读全帖 |
|
|
|
w*******y
发帖数: 60932 | 23 Splenda No Calorie Sweetener, 400-Count Packets $7.31 free shipping from
Amazon
Use Subscribe and Save and Promo Code SPLENDAP
Splenda No Calorie Sweetener, 400-Count Packets:
http://www.amazon.com/Splenda-Calorie-Sweetener-400-Count-Packe
#productPromotions" target="_blank">Splenda No Calorie Sweetener, 400-Count
Packets
|
|
|
w*******y
发帖数: 60932 | 25 Amazon
Not in stock now, but can be ordered for future delivery
2-pack 18-count Stayfree Ultra Thin Pads, Regular with Wings (36-total)
$4.76 - 30% off code FAVBRAND
= $3.33
28-count Stayfree Maxi Pads, Overnight with Wings:
http://www.amazon.com/Stayfree-Overnight-Wings-28-Count-Package
$3.99- 30% off code FAVBRAND
= $2.79
|
|
w*******y
发帖数: 60932 | 26 Bigelow Green Tea, 12-Count K-Cups (Pack of 3) $10.90 free shipping with
Prime (FSSS) from amazon
Pack of 3, count of cups-12. Total 36
Bigelow Green Tea creates a fragrant, light and mellow brew; An excellent
source of healthy antioxidants
Hand-picked green tea grown in higher-elevation gardens
Gluten free, with no calories and no carbohydrates; Kosher Parve
Blended and packaged in the U.S.A.
3-Pack 12-CountBigelow Green Tea, 12-Count K-Cups:
http://www.amazon.com/Bigelow-12-Count-K-Cups-Keurig... 阅读全帖 |
|
w*******y
发帖数: 60932 | 27 60-Count Finish Powerball Tablets Fresh Scent $8.31 free shipping from
Amazon
Use Subscribe and Save and $1 Off Coupon found on Product Page
A pack of 60-Count
The revolutionary Pre-soaking Powerball bursts into action to help soften
the toughest food residues like baked-on lasagna and dried-on oatmeal for
easy removal
Powerful cleaners remove even the toughest stains like coffee and tea and
gently scrub your dishes, glasses and silverware sparkling clean
Rinse Agent action helps rinse away res... 阅读全帖 |
|
d**z
发帖数: 3577 | 28 【 以下文字转载自 Stock 讨论区 】
发信人: dmjz (东门虎西门豹), 信区: Stock
标 题: Chinese Hedge Fund Launches Swell As Count Nears 25,000!
发信站: BBS 未名空间站 (Tue Dec 29 06:27:35 2015, 美东)
By Mark Melin on December 28, 2015 2:10 pm
Chinese Hedge Fund Launches Swell As Count Nears 25,000!
Chinese Hedge fund – As looser regulation has swept across China, new hedge
fund launches are surging at an unheard of pace. This all comes at a time
when some of the larger hedge fund managers have “gone incommunicado,” or
worse yet, “mis... 阅读全帖 |
|
r******e
发帖数: 146 | 29 Not only do I agree with the author of the article, I also think the "real"
medal count should count the real number of gold medals that are distributed
. Like one basketball medal should count something like 16. That is the only
fair way to determine which country is more successful. |
|
a****y
发帖数: 69 | 30 WomenCount and Committee to Count Every Vote ’08
release statement on RBC decision
Committee to Count Every Vote ’08
Comments on Decision of RBC
Thirty members of the Rules & Bylaws Committee of the Democratic National
Committee came to Washington on Saturday, May 31, with a promise to fairly
resolve a crisis that threatens the very legitimacy of our democratic
electoral process. The Committee to Count Every Vote ’08 and its
supporters came to Washington to ensure that the RBC lived up to that |
|
d**z
发帖数: 3577 | 31 【 以下文字转载自 Stock 讨论区 】
发信人: dmjz (东门虎西门豹), 信区: Stock
标 题: Chinese Hedge Fund Launches Swell As Count Nears 25,000!
发信站: BBS 未名空间站 (Tue Dec 29 06:27:35 2015, 美东)
By Mark Melin on December 28, 2015 2:10 pm
Chinese Hedge Fund Launches Swell As Count Nears 25,000!
Chinese Hedge fund – As looser regulation has swept across China, new hedge
fund launches are surging at an unheard of pace. This all comes at a time
when some of the larger hedge fund managers have “gone incommunicado,” or
worse yet, “mis... 阅读全帖 |
|
d**z
发帖数: 3577 | 32 【 以下文字转载自 Stock 讨论区 】
发信人: dmjz (东门虎西门豹), 信区: Stock
标 题: Chinese Hedge Fund Launches Swell As Count Nears 25,000!
发信站: BBS 未名空间站 (Tue Dec 29 06:27:35 2015, 美东)
By Mark Melin on December 28, 2015 2:10 pm
Chinese Hedge Fund Launches Swell As Count Nears 25,000!
Chinese Hedge fund – As looser regulation has swept across China, new hedge
fund launches are surging at an unheard of pace. This all comes at a time
when some of the larger hedge fund managers have “gone incommunicado,” or
worse yet, “mis... 阅读全帖 |
|
m******8
发帖数: 41 | 33 leetcode上的count and say这题，是一个什么思路？我在另一个帖子上有看到这题的
代码，但是我水平较低，主要想请教一下这题是什么思路。
Count And Say
The count-and-say sequence is the sequence of integers beginning as follows:
1, 11, 21, 1211, 111221, ...
1 is read off as "one 1" or 11.
11 is read off as "two 1s" or 21.
21 is read off as "one 2, then one 1" or 1211.
Given an integer n, generate the nth sequence.
Note: The sequence of integers will be represented as a string.
我看到的帖子是在，http://www.mitbbs.com/article_t/JobHunting/32147785.html
谢谢 |
|
j******2
发帖数: 362 | 34 请问这题的count(i)究竟咩意思？
二爷为何说这题跟O(1) add(), del(), rand() data structure 那题一样？恕愚钝。
难道是：用random产生0到size()间的整数i，然后遍历整个set，凡count(j)>count(
i)的，delete之并存之。然后delete(i)。最后把delete的其他数又insert进去。
感觉很不efficient但是题目不要求complexity的话也可以。 |
|
Y*****o
发帖数: 1173 | 35 【 以下文字转载自 EB23 讨论区 】
发信人: Yaoayao (Yaoayao), 信区: EB23
标 题: 大家都来签这个-Remove Dependent Count ！！
发信站: BBS 未名空间站 (Thu Jul 31 23:42:55 2014, 美东)
http://wh.gov/lMNjz
需要在8.21 之前征到十万签名， 目前才七百多！！！ 正在排着的EB23 和配偶，还有
即将排队的都应该来签一个！！
Use the executive powers to fix the broken immigration system for legal
immigrants
We are creating this petition to bring to your attention the following issue
that can help eliminate the backlog in Employment Based green cards.
Elimination of Dependents from Employment〣ased Coun... 阅读全帖 |
|
Y*****o
发帖数: 1173 | 36 【 以下文字转载自 EB23 讨论区 】
发信人: Yaoayao (Yaoayao), 信区: EB23
标 题: 大家都来签这个-Remove Dependent Count ！！
发信站: BBS 未名空间站 (Thu Jul 31 23:42:55 2014, 美东)
http://wh.gov/lMNjz
需要在8.21 之前征到十万签名， 目前才七百多！！！ 正在排着的EB23 和配偶，还有
即将排队的都应该来签一个！！
Use the executive powers to fix the broken immigration system for legal
immigrants
We are creating this petition to bring to your attention the following issue
that can help eliminate the backlog in Employment Based green cards.
Elimination of Dependents from Employment〣ased Coun... 阅读全帖 |
|
H******i
发帖数: 5 | 37 class Solution:
# @return a string
def countAndSay(self, n):
if n==1:
return '1'
pre=self.countAndSay(n-1)
start=0
next=''
while start
count=0
cur=pre[start]
while start
count+=1
start+=1
next=next+str(count)+cur
return next
|
|
Y*****o
发帖数: 1173 | 38 【 以下文字转载自 EB23 讨论区 】
发信人: Yaoayao (Yaoayao), 信区: EB23
标 题: 大家都来签这个-Remove Dependent Count ！！
发信站: BBS 未名空间站 (Thu Jul 31 23:42:55 2014, 美东)
http://wh.gov/lMNjz
需要在8.21 之前征到十万签名， 目前才七百多！！！ 正在排着的EB23 和配偶，还有
即将排队的都应该来签一个！！
Use the executive powers to fix the broken immigration system for legal
immigrants
We are creating this petition to bring to your attention the following issue
that can help eliminate the backlog in Employment Based green cards.
Elimination of Dependents from Employment〣ased Coun... 阅读全帖 |
|
Y*****o
发帖数: 1173 | 39 【 以下文字转载自 EB23 讨论区 】
发信人: Yaoayao (Yaoayao), 信区: EB23
标 题: 大家都来签这个-Remove Dependent Count ！！
发信站: BBS 未名空间站 (Thu Jul 31 23:42:55 2014, 美东)
http://wh.gov/lMNjz
需要在8.21 之前征到十万签名， 目前才七百多！！！ 正在排着的EB23 和配偶，还有
即将排队的都应该来签一个！！
Use the executive powers to fix the broken immigration system for legal
immigrants
We are creating this petition to bring to your attention the following issue
that can help eliminate the backlog in Employment Based green cards.
Elimination of Dependents from Employment〣ased Coun... 阅读全帖 |
|
w*s
发帖数: 60 | 40 How do you guys count the paper citations?
1. add up all citations from all papers?
2. Only count the citations from papers from others?
3. Are the citation counts from the google scholor website trustable?
Thanks again! |
|
g********e
发帖数: 1142 | 41 CS领域。
烂会貌似很缺reviewer，但就怕不count，瞎耽误工夫，只能每天下班搞会，很累的。
。。
杂志review肯定count，但review一篇杂志差不多能review两个会议了，毕竟不需要写
那么多comments。。。
要是烂会的review也count，我就好好review几个会的。。。
多谢多谢1 |
|
l*******n
发帖数: 8388 | 42 一张绿卡只有一个category，不会被count twice。
EB2被count 两次是说 140 被uscis count twice：2类的140 和降级的3类140. 这个在
demand和inventory data不完整或者没有的情况下（如放水），而又需要推进排期，可
能会被奥本拿来当一个指定排期的辅助数据。那有可能排期的推进会慢于本来该进的。
当然，一旦开始放水， 奥本更看重demand data。 |
|
z******y
发帖数: 969 | 43 140 double count, 485不会DOUBLE count吧。 绿卡count又不是看140的。 |
|
g*******a
发帖数: 1383 | 44 ok here is a summary, pretty much gooo has covered them all
1. the numbers (one, two, three and four) are beats
so if you have four beats per measure, then count to four
2. if you add "&", then you are counting the eighth notes,
it's also the hi-hat/ride cymbal beats (for regular rock)
3. if you add "e" "a" then it's sixteenth.
4. why they use these letters? probably for easy continous
pronouncation
5. for triplets, count "one trip-let, two trip - let" etc
a lot of ballads use this like "you are |
|
a**y
发帖数: 6501 | 45 去了 http://shuttercounter.com/
得到如下结果:
Image Count 2162944
Image Count 2 463616
Internal Serial Number 00000000
Image Count 3 128
我还是更新下firmware先 |
|
e**o
发帖数: 131 | 46 I wrote a little JSP + MySQL web application, which is a scheduler. tested it
on my PC and worked OK. But when I moved it to Sun Solaris, always got strange
error message when trying to add meeting. Weird enough, it has no problem when
I tried to add new user or add new tasks. The error is as the title:
Column count doesn't match value count at row 1
I have to post it online by this week and the only available server with JSP
engine is that one.
Please, any guru can help me with that? Thx a lot. |
|
j***3
发帖数: 142 | 47 【 以下文字转载自 Statistics 讨论区 】
发信人: j1123 (2134), 信区: Statistics
标 题: [Mysql] how to return NULL count in group by query
发信站: BBS 未名空间站 (Wed Jun 30 09:45:08 2010, 美东)
I have a table like this:
color size fruit
red big apple
red small apple
green big apple
yellow small orange
red small orange
when I do:
select color, size, count(*) group by color, size;
I got:
red big 1
red small 2
green big 1
yellow small 1
but what I need is to also return the NULL group count su |
|
t****t
发帖数: 6806 | 48 EARS系列设定idle3的timeout是8秒. 即什么都不做8秒钟, 磁头就park. 然后再使用时
就会load count+1 (SMART C1 count (193)).
解决方法: 到WD下载一个叫wdidle3的工具, 装在USB key上, 启动DOS, 把idle3 count
改成300. 改成0(disable)似乎不行, 跳得更厉害, 速度也受到影响. wdidle3说是只能
对几款硬盘有效, 但是据说对EARS系列绿盘都有用.
----最近折腾绿盘心得. |
|
f********a
发帖数: 1109 | 49 【 以下文字转载自 JobHunting 讨论区 】
发信人: fololunsia (我心飞扬), 信区: JobHunting
标 题: 请问：Auto_Ptr、Smart Ptr 和 Reference Counting是什么关系？
发信站: BBS 未名空间站 (Mon Jun 4 20:21:49 2007)
经常有人说auto pointer就是reference counting的一种。又有人说不对，smart
pointer才是。我也搞糊涂了。google了一下也没有什么结果。
请教一下，Auto_Ptr、Smart Ptr 和 Reference Counting 之间是什么关系？ |
|
h**o
发帖数: 548 | 50 I calculated count of system call using both
procsystime -a -p
and
dtrace -n 'syscall:::entry { @Execs["program name"] = count(); }'
Why the result of counts are totally different, are they comparing the same
thing?
Another question:
how to compare CPU usage of other functions?
procsystime compares only system call,
hotuser compares only user functions. But how to compare all functions?
Thanks. |
|
