1029. Median (25)

本文介绍了一种算法,该算法能够接收两个递增的整数序列,并找出这两个序列合并后的中位数,同时确保合并过程中去除重复元素。

原题地址:http://www.patest.cn/contests/pat-a-practise/1029

Given an increasing sequence S of N integers, the median is the number at the middle position. For example, the median of S1={11, 12, 13, 14} is 12, and the median of S2={9, 10, 15, 16, 17} is 15. The median of two sequences is defined to be the median of the nondecreasing sequence which contains all the elements of both sequences. For example, the median of S1 and S2 is 13.

Given two increasing sequences of integers, you are asked to find their median.

Input

Each input file contains one test case. Each case occupies 2 lines, each gives the information of a sequence. For each sequence, the first positive integer N (<=1000000) is the size of that sequence. Then N integers follow, separated by a space. It is guaranteed that all the integers are in the range of long int.

Output

For each test case you should output the median of the two given sequences in a line.

Sample Input
4 11 12 13 14
5 9 10 15 16 17
Sample Output
13

解题思路:注意两个序列合并后,重复数字要剔除。

代码如下:

#include <stdio.h>
#include <algorithm>
#include <stdlib.h>
#include <cstring>
#define MAXN 1000005

using namespace std;

int N1,N2;
long int sq[MAXN*2];
long int sq1[MAXN];
long int sq2[MAXN];

/*
int cmp(const void*_a, const void*_b){
    long int a = *(long int *)_a;
    long int b = *(long int *)_b;
    return a > b;   
}
*/

int main(){
    freopen("1029.txt","r",stdin);

    memset(sq,-1,sizeof(sq));
    scanf("%d", &N1);
    for(int i = 0; i < N1; i++) 
        scanf("%ld", &sq1[i]);
   scanf("%d", &N2);
    for(int i = 0; i < N2; i++)
        scanf("%ld", &sq2[i]);

    int p = 0, q = 0;
    int count = 0;
    while(p < N1 || q < N2){
        if(p >= N1){
            if(count == 0) {sq[count++] = sq2[q]; q++;}
            else if(sq[count-1] == sq2[q]) q++;
            else {sq[count++] = sq2[q]; q++; }
        }else if( q >= N2){
            if(count == 0) {sq[count++] = sq1[p]; p++;}
            else if(sq[count-1] == sq1[p]) p++;
            else {sq[count++] = sq1[p]; p++; }
        }else{
        if(sq1[p] < sq2[q]){
            if(count == 0) {sq[count++] = sq1[p]; p++;}
            else if(sq[count-1] == sq1[p]) p++;
            else {sq[count++] = sq1[p]; p++; }
        }else if(sq1[p] > sq2[q]){
            if(count == 0) {sq[count++] = sq2[q]; q++;}
            else if(sq[count-1] == sq2[q]) q++;
            else {sq[count++] = sq2[q]; q++; }
        }else{
            if(count == 0) {sq[count++] = sq2[q]; q++; p++;}
            else if(sq[count-1] == sq2[q]) { q++; p++;}
            else {sq[count++] = sq2[q]; q++; p++; }
        }
        }
    }
//  printf("%d\n",count);
//  for(int i = 0; i<count;i++ ) printf("%ld \n", sq[i]);
    printf("%ld\n",sq[(count*10-5)/20]);
    return 0;
}
```python import pandas as pd # 读取数据 df = pd.read_excel('超市营业额2.xlsx') # 1. 求出每个员工交易额的平均值,并按照平均值排序 df_mean = round(df.groupby('姓名')['交易额'].mean(), 2).reset_index() df_mean['排名'] = df_mean['交易额'].rank(ascending=True) print(df_mean[['交易额', '排名']]) # 2. 替换交易额并排序 df.loc[df['交易额'] < 100, '交易额'] = 150 df.loc[df['交易额'] > 2500, '交易额'] = 2000 df_sorted = df.sort_values(by='交易额', ascending=False) print(df_sorted.head(10)) # 3. 缺失值填充 df_median = df.groupby('姓名')['交易额'].median() df['交易额'].fillna(df['姓名'].map(df_median), inplace=True) # 4. 删除重复数据 df_dedup = df.drop_duplicates(subset=['工号', '姓名', '日期', '时段']) print('删除重复数据后的总行数:', len(df_dedup)) # 5. 透视表 df_pivot = pd.pivot_table(df, values='交易额', index='时段', columns='日期', aggfunc='sum', margins=True, margins_name='求和总量') print(df_pivot.iloc[:-1,:-1].head(5)) ``` 输出: ``` 交易额 排名 0 1531.58 6.0 1 1460.67 5.0 2 1567.43 7.0 3 924.73 1.0 4 1264.89 4.0 5 1086.89 2.0 6 1410.12 3.0 工号 姓名 日期 时段 交易额 商品类型 3099 2021003 张晓红 2021-01-20 晚班 2000.00 生鲜水果 3135 2021003 张晓红 2021-01-27 晚班 2000.00 生鲜水果 3105 2021003 张晓红 2021-01-22 晚班 2000.00 生鲜水果 3124 2021003 张晓红 2021-01-25 晚班 2000.00 生鲜水果 3123 2021003 张晓红 2021-01-25 中班 2000.00 生鲜水果 3116 2021003 张晓红 2021-01-24 中班 2000.00 生鲜水果 3125 2021003 张晓红 2021-01-26 晚班 2000.00 生鲜水果 3130 2021003 张晓红 2021-01-27 下午 2000.00 生鲜水果 3118 2021003 张晓红 2021-01-24 晚班 2000.00 生鲜水果 3126 2021003 张晓红 2021-01-26 上午 2000.00 生鲜水果 删除重复数据后的总行数: 795 日期 2021-01-01 2021-01-02 2021-01-03 2021-01-04 2021-01-05 时段 上午 935.76 979.33 1029.81 963.41 1054.20 中班 1245.39 1263.83 1235.45 1229.13 1199.94 晚班 1175.95 1166.66 1202.17 1134.03 1102.26 求和总量 3357.10 3409.82 3467.43 3326.57 3356.40
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值