te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>python - Drop NaN values from dataframe imported from excel - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>python - Drop NaN values from dataframe imported from excel - Stack Overflow

    python - Drop NaN values from dataframe imported from excel - Stack Overflow

    programmeradmin4浏览0评论

    I am trying to import my data from excel in to python using Pandas. I then want to plot the data. At the moment I am struggling with blank values in my data. Source data looks like attached image. When I run the code as below the data printed contains 'Nan'

    import pandas as pd
df = pd.read_excel('CSTRS Chem Eng Practicals_2.xlsx', sheet_name='Flow Rates')
df = pd.DataFrame(df)
df = df.values
Time2 = df[4:,0]
Conc1 = df[4:,2]
Conc2 = df[4:,4]
Conc3 = df[4:,6]
Conc4 = df[4:,8]
Conc5 = df[4:,10]
print (Time2)
print (Conc1)

    If I use df.notna() then I get this error message 'AttributeError: 'numpy.ndarray' object has no attribute 'notna'' Can anyone suggest a way to remove the NaN values so I am able to plot the data

    Thanks

    I have tried df.notna() and I have also tried slicing the data and neither works

    I am trying to import my data from excel in to python using Pandas. I then want to plot the data. At the moment I am struggling with blank values in my data. Source data looks like attached image. When I run the code as below the data printed contains 'Nan'

    import pandas as pd
df = pd.read_excel('CSTRS Chem Eng Practicals_2.xlsx', sheet_name='Flow Rates')
df = pd.DataFrame(df)
df = df.values
Time2 = df[4:,0]
Conc1 = df[4:,2]
Conc2 = df[4:,4]
Conc3 = df[4:,6]
Conc4 = df[4:,8]
Conc5 = df[4:,10]
print (Time2)
print (Conc1)

    If I use df.notna() then I get this error message 'AttributeError: 'numpy.ndarray' object has no attribute 'notna'' Can anyone suggest a way to remove the NaN values so I am able to plot the data

    Thanks

    I have tried df.notna() and I have also tried slicing the data and neither works

    • python
    • excel
    • pandas
    • dataframe
    Share Improve this question edited Feb 17 at 15:04 mozway 262k13 gold badges49 silver badges96 bronze badges asked Feb 17 at 15:04 Jess CrowJess Crow 211 bronze badge New contributor Jess Crow is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. 5
    • 1 Why do you run df = df.values? Just don't do that and it should be fine – mozway Commented Feb 17 at 15:05
    • 1 df = pd.DataFrame(df) is also useless. – mozway Commented Feb 17 at 15:05
    • Voting to close as not reproducible / caused by a typo. – mozway Commented Feb 17 at 15:06
    • 1 df.values converts a DF to numpy array so the resulting error is not surprising. – user19077881 Commented Feb 17 at 15:09
    • When I remove the df.values and try using df.notna() I get this error message 'InvalidIndexError: (slice(4, None, None), 0)' – Jess Crow Commented Feb 17 at 15:47
    Add a comment  | 

    1 Answer 1

    Reset to default 0

    I can't test since I don't have the Excel file but the following code should works:

    import pandas as pd
df = (
    pd.read_excel('CSTRS Chem Eng Practicals_2.xlsx', sheet_name='Flow Rates')
    .dropna()
)

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论